How to display or hide worksheet calculations

When a worksheet contains calculations, you can display or hide the calculations. You display calculations on a worksheet when you want to use them to analyze worksheet data. You hide calculations on a worksheet when you do not need to use them to analyze worksheet data. For example, you might display a calculation when you export a worksheet.

To display or hide calculations:

1. Display the worksheet that you want to analyze.

2. Choose Tools | Calculations to display the "Edit Worksheet dialog: Select Items tab: Calculations tab".

   
   Description of the illustration tot6.gif
   
   

   The Calculations tab lists existing calculations, percentages, and totals available in the worksheet. Active calculations are marked with a tick symbol (or check mark) in the Available list and are also displayed in the Selected list.

3. To display an existing calculation, move the calculation from the Available list to the Selected list.

4. To hide an existing calculation, move the calculation from the Selected list to the Available list.

5. Click OK to close the Calculations tab and display the worksheet.

   Discoverer refreshes the worksheet.

Notes

• You can also display existing calculations in the following way:

  • If the Available Items pane is displayed, drag and drop a calculation from the Calculations tab to the worksheet.

• You can also hide calculations in the following way:

  • If the Selected Items pane is displayed, right-click on a calculation in the Selected Items list and select Remove from Worksheet.

• If you want to remove a calculation item from the worksheet permanently, delete the calculation (see "How to delete calculations").