How to display or hide worksheet titles or text

You can display or hide a worksheet title or worksheet text when the worksheet is displayed, printed, or exported. For example, you might want to hide the current date and current time in the title when you are designing a worksheet but display the current date and current time in the title when a Discoverer end user prints the worksheet.

To display or hide a worksheet title or text area:

1. Open the workbook containing the worksheet that you want to edit (for more information, see "How to open workbooks").

2. Display the worksheet that you want to edit.

3. Choose the View menu to display a list of check boxes.

4. Use the Title check box to specify whether the worksheet title area is displayed at the top of the worksheet when the worksheet is displayed, printed, or exported, as follows:

   • Select the Title check box to display the worksheet title area.

   • Clear the Title check box to hide the worksheet title area.

5. Use the Text area check box to specify whether the worksheet text area is displayed at the botton of the worksheet when the worksheet is displayed, printed, or exported, as follows:

   • Select the Text area check box to display the worksheet text area.

   • Clear the Text area check box to hide the worksheet text area.

The worksheet is updated with the changes that you specified.

Notes

• To specify that Discoverer always displays the worksheet title area when you create a new worksheet, choose Tools | Options and select the Show title check box on the "Options dialog: Sheet tab".

• To specify that Discoverer always displays the worksheet text area when you create a new worksheet, choose Tools | Options and select the Show text area check box on the "Options dialog: Sheet tab".