Course / Sheets and workbooks

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.

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

  1. Three sheets, three names that say nothing. Sheet2 holds January's sales. Double-click its tab, type January, and press Enter.

  2. Name the other two the same way: Sheet3 is February, and Sheet1, this one, is the Summary.

  3. On Summary, total each month from its own sheet. In B2, enter =SUM(January!B2:B4), and in B3, =SUM(February!B2:B4).

  4. In B5, add the two months: =SUM(B2:B3).

  5. What happens to a formula when its sheet is renamed? Rename January to Jan, then click B2 and read its formula.

  6. March is coming. Click the + beside the tabs to add a sheet, and name it March.

Remember

In the function reference: SUM

Previous: Formulas that read another sheet · Next: Freeze panes: keep the headings in view