How to edit worksheets using the Edit Worksheet wizard

You edit a worksheet to change the way that the worksheet looks or behaves. For example, you might want to change the layout of worksheet data, or add calculations, percentages, or totals.

To edit a worksheet using the Edit Worksheet Wizard:

1. Display the worksheet that you want to edit.

2. Choose Edit | Worksheet... to display the "Edit Worksheet dialog".

   
   Description of the illustration ed1.gif
   
   

   The tabs on the Edit Worksheet dialog enable you to edit the properties of the current worksheet, as follows:

   • use the Worksheet Layout tab to select the worksheet elements (e.g. title area, graph) to display on the worksheet (for more information, see "Edit Worksheet dialog: Worksheet Layout tab")

   • use the Select Items tab to specify which items to display on the current worksheet (for more information, see "Edit Worksheet dialog: Select Items tab")

   • use the Crosstab/Table Layout tab to change the layout of the current worksheet (for more information, see "Edit Worksheet dialog: Crosstab Layout tab" or "Edit Worksheet dialog: Table Layout tab")

   • use the Sort tab to change the sort order of items on the current table worksheet (e.g. title area, graph) to display on the worksheet (for more information, see "Edit Worksheet dialog: Sort tab")

     Note: The Sort tab is only displayed for table worksheets. To sort a crosstab worksheet, Choose Tools | Sort to display the "Sort Crosstab dialog" (for more information, see "How to sort data on a crosstab worksheet").

   • use the Parameters tab to manage existing parameters and create new parameters (for more information, see "Edit Worksheet dialog: Parameters tab")

3. Click OK to save changes you have made and return to the worksheet.

   Discoverer updates the worksheet with the changes that you specified.

Notes

• You can also edit the worksheet directly in the Discoverer work area using drag and drop, right click menus, and toolbars (for more information, see " About the Discoverer Plus Relational work area").