How to Add a Worksheet in Excel for the Web
A workbook can hold several sheets, each with its own grid: data on one, totals on another. In Excel for the web, the + button next to the sheet tabs at the bottom of the page adds one.
The old overtime timesheet from Part 1 of the Overtime Timesheet series has three sheets: Overtime log with the data, Monthly totals, and Clock change, each added this way.
Prerequisites
- A workbook open for editing in Excel for the web.
Step 1: Select New Sheet
At the bottom of the page, next to the last sheet tab, select +, labelled New sheet:
The keyboard shortcut is Shift+F11, according to Microsoft's Keyboard shortcuts in Excel for Excel for the web.
Step 2: Check the New Tab
Excel adds an empty sheet after the last one and opens it. Mine was called Sheet1, because the workbook's first sheet had already been renamed from that.
Step 3: Name It
Give the sheet a name that says what's on it. I renamed Sheet1 to Monthly totals: How to Rename a Worksheet in Excel for the Web.
Common Mistakes
| Mistake | What happens | Do this instead |
|---|---|---|
| Putting totals on the data sheet | Sorting or adding rows can disturb them | Keep totals on a sheet of their own |
| Leaving default names like Sheet1 | Formulas and readers can't tell sheets apart | Rename each new sheet |
Troubleshooting
| Symptom | Likely cause | Fix |
|---|---|---|
| The tab you want isn't visible | There are more tabs than fit | Use the arrows at the left of the tabs |
| The new sheet is called Sheet2 or similar | Excel picks the next free default name | Rename it |
FAQ
Can formulas use data from another sheet?
Yes. A table's name works from any sheet, which is how Monthly totals reads OvertimeLog[Hours] from Overtime log.
Can I add a sheet from the Home tab instead?
Microsoft's Insert or delete a worksheet gives Home → Insert → Insert Sheet for the desktop app; in Excel for the web I used +.
Conclusion
Select + next to the sheet tabs, then rename the new sheet so its tab says what it holds.
