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.
Reordering tables and charts in the Sheets pane doesn’t affect their location on the
sheet canvas. 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 on the sheet canvas, 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:
To move a sheet, select it and drag it to a new location in the pane. Sheets shift as
m
you drag.
40
Chapter 2
Creating, Saving, and Organizing a Numbers Spreadsheet
Chapter 2
Creating, Saving, and Organizing a Numbers Spreadsheet
41
You can also select multiple sheets and move them as a group.
To copy (or cut) and paste sheets, select the sheets, choose Edit > Cut or Edit > Copy,
m
select the sheet after which you want to place the sheets you’re moving, and choose
Edit > Paste.
To move one or more tables and charts associated with a sheet, select them and drag
m
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.
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
for printing or creating a PDF, follow the instructions in “Dividing a Sheet into
Pages” on page 42.