Apple numbers User Manual

 Working with a Numbers Spreadsheet

 

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.

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. 

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.