Apple numbers User Manual
38
Chapter 2
Working with a Numbers Spreadsheet
Adding and Deleting Sheets
There are several ways to add and delete sheets.
Here are ways to create and remove sheets:
m
To add a new sheet, click the Sheet button in the toolbar. You can also choose Insert >
Sheet.
Sheet.
A new sheet containing a predefined table is added at the bottom of the Sheets pane.
You can move the sheet by dragging it to a new location in the Sheets pane.
You can move the sheet by dragging it to a new location in the Sheets pane.
m
To add a sheet that’s a copy of a sheet in the spreadsheet, select the sheet to copy,
choose Edit > Copy, select the sheet after which you want the copy located, and
choose Edit > Paste.
choose Edit > Copy, select the sheet after which you want the copy located, and
choose Edit > Paste.
m
To delete a sheet and its contents, select it in the Sheets pane and press the Delete key.
When you add a sheet, Numbers assigns it a default name, but you can change the
name, as “Changing Sheet Names” on page 39 describes.
name, as “Changing Sheet Names” on page 39 describes.
Reorganizing Sheets and Their Contents
In the Sheets pane, you can move sheets around and reorder their tables and charts.
You can also move tables and charts from one sheet to another.
You can also move tables and charts from one sheet to another.
Reordering tables and charts in the Sheets pane doesn’t affect their location in a sheet.
In a sheet in the Sheets pane, for example, you may want to place charts next to the
tables they’re derived from, or list tables in the order in which you want to work on
them. But in the sheet itself, you may want to present these objects in a different order
(for example, when you lay out your spreadsheet for printing).
In a sheet in the Sheets pane, for example, you may want to place charts next to the
tables they’re derived from, or list tables in the order in which you want to work on
them. But in the sheet itself, you may want to present these objects in a different order
(for example, when you lay out your spreadsheet for printing).
Here are ways to reorganize sheets in the Sheets pane:
m
To move a sheet, select it and drag it to a new location in the pane. Sheets shift to
make room for your insertion as you drag.
make room for your insertion as you drag.
You can also select multiple sheets and move them as a group.
m
To copy (or cut) and paste sheets, select the sheets, choose Edit > Cut or Edit > Copy,
select the sheet after which you want to place the sheets you’re moving, and choose
Edit > Paste.
select the sheet after which you want to place the sheets you’re moving, and choose
Edit > Paste.
m
To move one or more tables and charts associated with a sheet, select them and drag
them to a new location in the same sheet or to a different sheet.
them to a new location in the same sheet or to a different sheet.
You can also use cut/paste or copy/paste actions to move tables and charts in the
pane.
pane.
To move an object within a sheet in the spreadsheet, select it and drag it to a different
location, or use cut/paste or copy/paste actions. To place objects on specific pages,
follow the instructions in “Dividing a Sheet into Pages” on page 39.
location, or use cut/paste or copy/paste actions. To place objects on specific pages,
follow the instructions in “Dividing a Sheet into Pages” on page 39.