Add, rename and link sheets
Give sheets names that say what is on them, total each month from a summary sheet, and see formulas follow a sheet when it is renamed. Beginner · 6 min · Sheet tabs, Rename a sheet, Add a sheet, Summary sheet
New sheets are called Sheet1, Sheet2, Sheet3, which tells nobody anything. The first job in any workbook is to name the sheets after what is on them.
- Rename: double-click a tab, type the name, press Enter.
- Add: click the + beside the tabs.
- Copy, move, delete: open the small arrow on the selected tab.
A common layout is one sheet per month and a summary sheet that totals them, with formulas such as =SUM(January!B2:B4).
In Excel it is the same: double-click a tab to rename it, and click the + to add a sheet. Right-click a tab for the rest.
Steps
Three sheets, three names that say nothing. Sheet2 holds January's sales. Double-click its tab, type January, and press Enter.
Name the other two the same way: Sheet3 is February, and Sheet1, this one, is the Summary.
On Summary, total each month from its own sheet. In
B2, enter=SUM(January!B2:B4), and inB3,=SUM(February!B2:B4).In
B5, add the two months:=SUM(B2:B3).What happens to a formula when its sheet is renamed? Rename January to Jan, then click
B2and read its formula.March is coming. Click the + beside the tabs to add a sheet, and name it March.
Remember
- Double-click a tab to rename it; the + adds a sheet.
- A summary sheet totals the others:
=SUM(January!B2:B4). - Renaming a sheet rewrites the formulas that name it.
- Deleting a sheet leaves #REF! in the formulas that read it.
In the function reference: SUM
Previous: Formulas that read another sheet · Next: Freeze panes: keep the headings in view