Adding a New Worksheet
Click the plus button beside the tabs, or press Shift + F11, to add another page to the workbook.
Another Page in the Same File
Related information belongs in one file on separate sheets, not in separate files. Adding a sheet takes one click.
- Click the plus — New sheet at the end
- Or Shift + F11 — New sheet before the current one
- Rename it — Double click the tab
How to do it
The + button beside the sheet tabs or Shift + F11
The plus button adds the sheet at the end. Shift + F11 adds it before the current sheet.
| Item | What it does |
|---|---|
| + button | Adds at the end |
| Shift + F11 | Adds before the current sheet |
| Right-click ▸ Insert | Choose a template too |
| Default name | Sheet2, Sheet3, and so on |
Ways to Add a Sheet
Shift + F11 ▸ a new sheet appears before the current one
| Method | Where the sheet goes | Speed |
|---|---|---|
| + button | At the end | One click |
| Shift + F11 | Before current | One keystroke |
| Right-click ▸ Insert | Before current | Slower, more options |
| Ctrl + drag a tab | Copies a sheet | Duplicates content |
Result: Shift + F11
Ctrl + drag a tab duplicates a sheet, layout and formulas included.
Do this
- Rename each sheet as you create it
- Use Ctrl + drag to duplicate a sheet layout
- Keep related work in one workbook
Avoid
- Leaving sheets named Sheet2 and Sheet3
- Creating a new file when a new sheet would do
- Adding sheets in a random order
📌 Set how many sheets a new workbook starts with at File ▸ Options ▸ General.
Practice
- Add a sheet with the + button.
- Add another with Shift + F11.
- Duplicate a sheet by Ctrl + dragging its tab.
Quick quiz: You need a second month's sheet with the same layout as January. What is quickest?
- Insert a blank sheet and rebuild it
- Hold Ctrl and drag the January tab to duplicate it
- Copy and paste all the cells
Show answer
Hold Ctrl ▸ drag the sheet tab ▸ release — Ctrl + drag duplicates the entire sheet, including widths, formats and formulas.
🔒 Want the full interactive course? This is a free preview. The complete 39-module Excel Master Course — with hands-on lessons, quizzes and a certificate — is available inside the app.
Learn Excel the fun way
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →