About editing worksheets

When you create a new worksheet, Discoverer applies a default format (e.g. colors, fonts) to worksheet items. For more information about changing the default format that is applied to worksheet items, see "How to change default worksheet formats").

Discoverer's powerful layout tools enable you to format worksheets exactly how you want them. For example, you might want to:

• add items to a worksheet

• remove items from a worksheet

• change the color of rows and columns

• change the background color or title of worksheets

• change the format of text and numbers

• change the column width on table worksheets (Discoverer automatically sets the column size on crosstab worksheets)

You can edit worksheets using any of the following methods:

• by dragging and dropping a worksheet item from one area of a worksheet to another area (you can also resize worksheet columns using drag and drop)

• by right-clicking on any area of a worksheet (e.g. a graph, worksheet item, worksheet item heading) to display a list of options for that area.

• by using the Edit Worksheet wizard (for more information, see "How to edit worksheets using the Edit Worksheet wizard")

Hint: If you want to change a worksheet but keep a copy of the original worksheet, use the duplicate worksheet facility. Here, you make an exact copy of a worksheet that you can work on (for more information, see "How to duplicate a worksheet"). Alternatively, save the whole workbook under a different name and work with this copy (for more information, see "How to save workbooks").s