Three ways to add a worksheet (fastest first)
- Click the + icon — at the bottom of the sheet tabs (1 second)
- Shift + F11 — inserts a new sheet before the active one
- Home → Insert → Insert Sheet — the menu route
How do you want to add a worksheet?
| Your Need | Recommended Method | Key Consideration |
|---|---|---|
| ⌨️ Fastest for keyboard users | Shift + F11 | ✅ Inserts left of current sheet — fastest |
| 🖱️ Most intuitive for mouse users | + Icon | ✅ Inserts at the end — most intuitive |
| 📍 Insert at a specific position | Right-Click Menu | ✅ Can insert anywhere you choose |
Choose Your Method
+ Icon Method (Most Intuitive)
Best for beginners or when you want to add a new sheet at the END of the workbook.
Find the + Icon
Look at the bottom of the workbook — the + icon is to the right of the LAST sheet tab.
Click the + Icon
Click it. A new worksheet is automatically inserted at the END of the tabs.
Rename the New Sheet
Double-click the new tab → type a name → press Enter.
+ icon ALWAYS inserts at the end. It CANNOT insert a sheet in the middle!
Shift + F11 Shortcut (Fastest)
Best for keyboard power users who want speed. No mouse needed!
Select a Sheet
Click the worksheet tab that should be to the RIGHT of your new sheet.
Press Shift + F11
Press Shift + F11. A new sheet is inserted immediately to the LEFT of the selected sheet.
Rename Immediately
Type a name or right-click → Rename to give the new sheet a meaningful name.
Shift + Fn + F11 (or Shift + F11 if Fn lock is enabled).
Right-Click Menu (Insert at Specific Position)
Best when you need to insert a worksheet at a specific location between existing sheets.
Right-Click the Sheet Tab
Right-click (or Control+click on Mac) the sheet tab that should be to the RIGHT of your new sheet.
Select Insert > Worksheet
Click Insert → choose Worksheet → Click OK.
Rename the New Sheet
Double-click the new tab and type a name.
About This Guide
Excel gives you three built-in ways to insert a sheet: the + tab button, the Shift+F11 shortcut, and right-click → Insert. Each places the new tab in a different position, so the method you pick depends on where you want the sheet to land.
Frequently Asked Questions
Added Your Worksheet? Organize It Properly!
Protect New Worksheets
Prevent accidental edits to your new sheets. Learn the correct protection method.
Learn More →Copy Worksheets
Duplicate your new sheet as a template. Master the 3-second copy method.
Learn More →Combine Worksheets
Merge your new sheets into one. Consolidate, VSTACK, and VBA methods.
Learn More →Continue Exploring
Sources & References
This guide was written and fact-checked against Microsoft's official Excel documentation.
Disclaimer: This guide is for informational and educational purposes only. Rename sheets immediately after adding to stay organized. Last Updated: August 18, 2026.