Closing a spreadsheet without quitting numbers, Using sheets to organize a spreadsheet, 39 using sheets to organize a spreadsheet – Apple Numbers '09 User Manual

Page 39: 39 f

Advertising
background image

Chapter 2

Creating, Saving, and Organizing a Numbers Spreadsheet

39

Closing a Spreadsheet Without Quitting Numbers

When you have finished working with a spreadsheet, you can close it without
quitting Numbers.

Here are ways to close the active spreadsheet and keep the application open:
To close the active spreadsheet, choose File > Close or click the close button in the

m

upper-left corner of the Numbers window.
To close all open spreadsheets, press the Option key and choose File > Close All or

m

click the active spreadsheet’s close button.

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 along the left edge of the window.

Click to show or hide a

sheet’s tables and charts

in the Sheets pane.

Drag left or right to
resize the Sheets pane.

Click a table or chart in the
list to select it and show it
on the sheet canvas.

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 40 describes.

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

m

triangle to the left of the sheet in the pane.

Advertising