How to format worksheet items and cells

You format worksheet items and cells to change their appearance (e.g. text font, text color, background color). On table worksheets, you format worksheet items, but not individual worksheet cells. On crosstab worksheets, you can format worksheet items and individual worksheet cells.

Hint: You can select more than one worksheet item or cell by pressing the Ctrl key and clicking another worksheet item or cell.

To format worksheet items:

1. Display the worksheet that you want to edit (for more information, see "How to open a Discoverer worksheet").

2. Select one or more worksheet items or cells by selecting the grab handle of worksheet items to highlight them.

   Hint: You can select more than one item by pressing Ctrl and selecting another item.

3. Select the Format link to display formatting tools above the worksheet data.

4. Use the formatting tools to format the selected worksheet items.

   For example, you might:

   • click the B, i, or U buttons to format the text as bold, italic, or underlined

   • select the color palette icons next to the Background and Font tools to display a color palette

   • select the More link to display the "Format Cells page", which enables you to specify font, border, and number format options for the selected worksheet items

     Note: Number format options are only available for OLAP worksheets.

   Discoverer applies the format changes you have specified.

   Hint: Select the minus (-) icon next to the Tools label to hide the formatting tools.