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.
To display the contents of a sheet, click the sheet in the Sheets pane.
m
When you’re working on a table or chart in a spreadsheet, the table or chart is
highlighted in the Sheets pane.
To learn how to
Go to
Create and remove sheets
“Adding and Deleting Sheets” on page 40
Move sheets around, reorder their tables and
charts, and move tables and charts among sheets
“Reorganizing Sheets and Their Contents” on
page 40
Name a sheet
“Changing Sheet Names” on page 41