Numbers '09: Using Sheets to organize a spreadsheet

Like chapters in a book, sheets let you divide information into manageable groups. For example, you might want to place charts in the same sheet as the tables whose data they display. Or you may want to place all the tables on one sheet and all the charts on another sheet. You might want to use one sheet for keeping track of business contacts and other sheets for friends and relatives.

The sheets in a spreadsheet and the tables and charts on each sheet are represented in the Sheets pane, located along the left edge of the window. Only tables and charts are listed for any sheet, even if you have text, images, and other objects in your spreadsheet. The order of a sheet's tables and charts in the Sheets pane may not match their order in the spreadsheet.

Here are ways to see a sheet’s objects:

  • To show or hide all a sheet's tables and charts in the Sheets pane, click the disclosure triangle to the left of the sheet in the pane.
  • To display the contents of a sheet, click the sheet in the Sheets pane.

When you’re working on a table or chart in a spreadsheet, the table or chart is highlighted in the Sheets pane.

Last Modified:

Additional Product Support Information

Start a Discussion

in Apple Support Communities
See all questions on this article See all questions I have asked
United States (English)