Setting Default Format Options

The Default Format options are for setting the font style, text color and background color of a worksheet's data, column headings, and totals.

To set Format options:

1. From the menu, choose Tools | Options. The Options dialog appears. The tabs across the top of the dialog list the different option categories.

2. Click the Default Formats tab.

   
   

3. To see a default format, select it in the list. The Example box shows an example of the format.

4. To change a default format, select from the list of formats.

5. Click the Change button. The Data Format dialog appears.

   
   

6. Select options on the Data Format dialog to set the default font style, alignment, text color, and background color for the selected format.

   Size--Choose a size for the font from the drop-down list.

   Style--Click a button to display the text in a boldface, italic, underline, or strikethrough. Click the appropriate button to remove the style if it is already in effect.

   Color--Click the button to apply a color to either the text or the background. A palette of colors appears. Click the one you want.

   Alignment--Click an alignment option. The options display the data in the top, middle or bottom of the appropriate cell on the table or crosstab.

   Actual font size--Select this option to display the data in the sample in the font size that you choose from the size drop-down list.

7. Click OK.

   See also:
   Setting Query Governor Options
   Setting Sheet Format Options
   Setting General Options
   Setting Advanced Options
   Setting EUL Options
   Using SQL

Resetting the Default Formats

Sometimes, after changing several aspects of a format you want to change it back to the original Discoverer default settings. Instead of changing each format setting individually, you can click the Reset button.

1. In the Format Options dialog, select the default format to reset.

   Resetting applies only to the selected format. Thus, you can reset one format but keep your changes made to the others.

2. Click the Reset button.

3. Click OK.