Multiple Format allows you to apply a single format for your fonts, text and background color, and cell alignment for multiple sheets or for all the columns in one sheet.
This section discusses the following topics:
Selecting Features for Multiple Formatting on page 188. Formatting Fonts in Multiple Features on page 189. Changing the Text Flow in Multiple Features on page 189. Formatting Colors in Multiple Features on page 190. Aligning Data in Columns on page 190.
Figure 7-6: Formatting sheets/reports is easy by using the Format Multiple dialog box.
Selecting Features for Multiple Formatting
The table below gives the combinations you need for formatting the various features:
Note: Format Multiple may remove formatting of individual columns, depending on the options selected. For example, a colored background in a particular column is retained as long as you do not set the background color in the
Format Multiple options. If you use Format Multiple to set the background
color for all columns, or all columns in a sheet, then the color in that one column will be overridden.
Note: The Multiple Format function does not work with charts, diagrams or imported third party software pages.
To format: Select these check boxes:
Worksheet Header Labels Worksheet Headers & Labels Worksheet Header Content Worksheet Header & Contents Worksheet Column Heading Worksheet Columns & Labels Worksheet Column Content Worksheet Columns & Contents
Form Labels Form Field & Labels
Formatting Fonts in Multiple Features
To format the font:
Changing the Text Flow in Multiple Features
To change the text flow in multiple features:
Tip: You can create different settings for headers, label and content, and for
columns, headings and content, by repeating the procedure for the same pages a number times. Each time you repeat the procedure, you select the different features.
Step Action
1. Go to Format>Format Multiple. The Format Multiple dialog box opens.
2. Click the check box beside the sheet you want to include.
Note: If you only want to include some, but not all, of the sheets of a collection, open the collection containing the sheets that you want to include.
3. Repeat step 2 until you have specified all of the sheets you want formatted.
4. Select the feature that you want to be formatted by selecting the appropriate check box(es).
For more information, see Selecting Features for Multiple Formatting on page 188.
5. Click the Font/Color tab. The Font page opens.
6. Select the new font from the Font list.
Note: Arial is the default font. The fonts that appear in the list depend on the fonts that are installed on your computer system.
7. Select the new font size from the Font Size list. Note: 8-point type is the default size.
8. Select the Bold check box if you want to bold the text (Optional). 9. Select the Italic check box if you want to italicize the text
(Optional). 10. Click OK.
Step Action
1. Go to Format>Format Multiple. The Format Multiple dialog box opens.
2. Click the check box beside the sheet you want to include.
Note: If you only want to include some, but not all, of the sheets of a collection, open the collection containing the sheets that you want to include.
3. Repeat step 2 until you have specified all of the sheets you want formatted.
4. Select the feature that you want to be formatted by selecting the appropriate check box(es).
For more information, see Selecting Features for Multiple Formatting on page 188.
Formatting Colors in Multiple Features
To change the text and background colors:
Aligning Data in Columns To align the data:
5. Click the Text Flow tab.
6. Deselect the Use Default check box. Note: Default text flow is left to right.
7. Select the direction of the text flow by selecting the appropriate radio button: • Left to Right. • Right to Left. 8. Click OK. Step Action Step Action 1. Go to Format>Format Multiple. The Format Multiple dialog box opens.
2. Click the check box beside the sheet you want to include.
Note: If you only want to include some, but not all, of the sheets of a collection, open the collection containing the sheets that you want to include.
3. Repeat step 2 until you have specified all of the sheets you want formatted.
4. Select the feature that you want to be formatted by selecting the appropriate check box.
For more information, see Selecting Features for Multiple Formatting on page 188.
5. Click the Font/Color tab. The Font page opens. 6. 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. 7. Select your Background Color.
8. Click OK.
Save Action
1. Go to Format>Format Multiple. The Format Multiple dialog box opens.
2. Click the check box beside the sheet you want to include. Note: If you only want to include some, but not all, of the sheets of a
collection, open the collection containing the sheets that you want to include.
3. Repeat step 2 until you have specified all of the sheets you want formatted.