Hiding Sheet

Hiding is used for the sheets that contain subtotals. Hidden sheets are not displayed in the working area, they cannot be previewed or printed, and they can be exported only to XLS format.

Regular reports enable the user to go to hidden sheets by hyperlink.

Adding a hiding for the sheet

To hide a sheet, select the Hide context menu item for the sheet tab.

NOTE. Hiding a sheet automatically deselects the Print Sheet with Book checkbox in page settings on the Print tab. If the sheet is displayed again, the checkbox is not restored.

Showing Hidden Sheets

To show sheets, select the Show context menu item for the sheet tab. In the dialog box, select sheets to be displayed in the working area:

NOTE. The Show item is available in the context menu for the menu tab if the report contains hidden sheets.

See also:

Adding a New Sheet and Working with It