Edit Worksheet dialog: Worksheet Layout tab

Use this dialog to select the worksheet elements (for example, title area, graph) to display on the worksheet. For example, you might want to display a title area at the top of the worksheet and a text area at the bottom of the worksheet.


This dialog is also displayed as:
Worksheet Wizard dialog: Worksheet Layout page

For more information, see:

"What are workbooks?"

"What are worksheets?"

  • Title

    Use this check box to display a title area at the top of the worksheet (for more information, see "About worksheet titles and text").

  • Page Items

    Use this check box to display data grouped by the items in the Page Axis area (for more information, see "What are axis items?").

  • Crosstab/Table

    Use this check box to specify whether you display the worksheet data area.

  • Graph

    Use this check box to specify whether you display a graph alongside the worksheet data area.

  • Placement

    Use this drop down list to specify where to place the graph in relation to the worksheet data.

  • Text Area

    Use this check box to display a text area at the bottom of the worksheet (for more information, see "About worksheet titles and text").