How to view and edit worksheet properties

You edit a worksheet's properties to change the appearance and behavior of the worksheet. For example, you might want to:

• change the name and description of the worksheet

• show vertical or horizontal gridlines

To view and edit worksheet properties:

1. If it is not already open, open the workbook that contains the worksheet you want to view or edit and display the worksheet.

2. Choose Edit | Worksheet Properties to display the "Worksheet Properties dialog: General tab".

   
   Description of the illustration d_wsprnm.gif
   
   

3. Display the appropriate tab for the properties that you want to edit as shown below.

   Tab	Use to
   "Worksheet Properties dialog: General tab"	Specify the worksheet name and description, and view the worksheet identifier.
   "Worksheet Properties dialog: Sheet/Crosstab Format tab"	Specify how Discoverer displays the current worksheet (e.g. with a text area, null values, grid lines, row numbers).
   "Worksheet Properties dialog: Aggregation tab"	Specify how Discoverer displays aggregated values for the worksheet (for more information, see "What are aggregated values in Discoverer").

   
   

4. Click OK to save the changes that you have made and close the Worksheet Properties dialog.

The changes to worksheet properties that you have made take effect immediately.