Using sheets to organize a spreadsheet, Viewing sheets – Apple Numbers '08 User Manual

Page 37

Advertising
background image

Chapter 2

Working with a Numbers Spreadsheet

37

If you’ve made changes since you last saved the spreadsheet, Numbers prompts you to
save.

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 to the left of the canvas above the styles pane.

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, as “Reorganizing Sheets and Their Contents” on page 38 describes.

Viewing Sheets

The Sheets pane on the left of the Numbers window lists all the sheets in your
spreadsheet and the tables and charts in each sheet.

Here are ways to see a sheet’s tables and charts:

m

To show or hide all a sheet’s tables and charts in the Sheets pane, click the triangle to
the left of the sheet in the pane.

m

To display the contents of a sheet, click the sheet in the Sheets pane.

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

Click to show or hide a

sheet’s tables and charts.

Click to add a new sheet.

Advertising