You can also format and modify the column headings. You can select the names, fonts and colors for the headings, as well as create and customize help callouts for them.
This section discusses the following topics:
Hiding Column Headings on page 183.
Displaying Column Headings on page 183.
Modifying Callouts for Column Headings on page 183.
Formatting Fonts for Column Headings on page 184.
Changing the Text Flow for Column Headings on page 185.
Formatting Colors for Column Headings on page 185.
Aligning Column Headings on page 186.
Changing Column Heading Orientation on page 187.
Hiding Column Headings To hide a column heading:
Displaying Column Headings To display a hidden column heading:
Modifying Callouts for Column Headings
Heading callouts remind your team members what information should be entered in the column. When you move the cursor over a column heading, a call out containing the item + full name + comments appears in a box. You can modify - change, add or remove - the callout to meet your needs.
Step Action
1. Right-click the column heading you want to hide.
A pop-up menu opens.
2. Click Hide Heading.
The heading disappears from your screen, but the column remains visible.
Step Action
1. In the column that you want to redisplay the heading, right-click either:
• The blank gray area at the top of the column.
• A cell within the column.
A pop-up menu opens.
2. Select Show Heading.
The column headings appear.
3. Click the column heading you want to display.
The heading reappears on your screen.
Tip: You can also use the above three steps to display a main heading above other column headings. The software displays a gray rectangle that runs across the sheet above the other column headings, and the name you chose appears inside the gray area.
Figure 7-5: The Help Text page in the Heading Format dialog box allows you to customize the heading callouts.
To modify a column heading callout:
Formatting Fonts for Column Headings
To format the font for a column heading:
Step Action
1. In the column that you want to change the callout, right-click the column heading.
A pop-up menu open.
2. Select Heading Format.
3. Click the Help Text tab.
Note: If you have selected cells from multiple columns, the Help Text tab does not appear.
4. Select one of the following options by clicking the appropriate radio button:
• Automatically chosen text (usually name of containing item + full name + comments)
• Comments for Hierarchy item (if any)
• Do not show any text.
• Other
Note: If Other is chosen, enter the callout message in the text field.
5. Click OK.
Step Action
1. Select the column and click Format on the menu.
Or
Right-click either:
• Any cell within the column of interest.
• The heading of the column.
A pop-up menu opens.
2. Click Heading Format.
The Heading Format dialog box opens.
3. Click the Font tab.
The Font page opens.
Changing the Text Flow for Column Headings
You can enter data in a left to right or right to left order. The right to left order allows you to enter languages that read from right to left. When you change the data entry, the justification automatically adjusts to the new style. The default justification for left to right data entry is left justification; the default justification for right to left data entry is right justified.
To change the text flow in a column heading:
Formatting Colors for Column Headings
To select text and background colors for a column heading:
4. Select your font from the Font list. (Optional)
Note: Arial is the default font. The fonts that appear in the list depend on the fonts that are installed on your computer system.
5. Select your font size from the Size list. (Optional) Note: 8-point type is the default size.
6. If you wish to bold or italicize the text, click the box beside Bold or Italic.
Note: Click both boxes if you wish to both bold and italicize the text.
7. Click OK.
Step Action
Note: The default text flow is left to right.
Step Action
1. Select the column and click Format on the menu.
Or
Right-click either:
• Any cell within the column of interest.
• The heading of the column.
A pop-up menu opens.
2. Click Heading Format.
The Heading Format dialog box opens.
3. Click the Text Flow tab.
4. Select the direction of the text flow by selecting the appropriate radio button:
• Left to Right.
• Right to Left.
5. Click OK.
Note: The text and background color option for column headings affects the print or export output only. It does not change the on-screen appearance.
Aligning Column Headings Headings are centered, both vertically and horizontally, by default.
To change the alignment for any column heading:
Step Action
1. Select the column and click Format on the menu.
Or
Right-click either:
• Any cell within the column of interest.
• The heading of the column.
A pop-up menu opens.
2. Click Heading Format.
The Heading Format dialog box opens.
3. Click the Font tab.
The Font page opens.
4. Select your Text Color.
Black is the default font color. To use a different color:
1. Click the arrow to display a pop-up palette.
2. Click the color you want to use for the font color.
5. Select your Background Color.
White is the default background color. To use a different color:
1. Click the arrow to open a pop-up palette.
2. Click the color you want to use for the background color.
6. Click OK.
Step Action
1. Select the column and click Format on the menu.
Or
Right-click either:
• Any cell within the column of interest.
• The heading of the column.
A pop-up menu opens.
2. Click Heading Format.
The Heading Format dialog box opens.
3. Click the Alignment tab.
The Alignment page opens.
4. To change the vertical placement, click the arrow under Vertical Alignment.
A drop-down list opens.
5. Click one of the following:
• Top.
• Center.
• Bottom.
6. To change the horizontal placement, click the arrow under Horizontal Alignment.
Changing Column Heading Orientation
There are four types of orientation that you can have for the text in the column heading:
• Horizontal.
• Vertical (Up).
• Vertical (Down).
• Vertical (Stacked Letters).
To change the orientation for any column heading:
7. Click one of the following:
• Left.
• Center.
• Right.
8. Click OK.
All data in the column is now realigned.
Step Action
Step Action
1. Select the column and click Format on the menu.
Or
Right-click either:
• Any cell within the column of interest.
• The heading of the column.
A pop-up menu opens.
2. Click Heading Format.
The Heading Format dialog box opens.
3. Click the Alignment tab.
The Alignment page opens.
4. To change the text orientation, click the arrow next to Orientation.
A drop-down list opens.
5. Select one of the following:
• Horizontal.
• Vertical (Up).
• Vertical (Down).
• Vertical (Stacked Letters).
6. Click OK.
All data in the column is now realigned.