SHORTCUT CHEAT SHEET
All worksheet shortcuts
| What you want to do | Keyboard shortcut |
|---|---|
| Add a new worksheet | Shift + F11 |
| Go to the next sheet | Ctrl + Page Down |
| Go to the previous sheet | Ctrl + Page Up |
| Go to the first sheet | Ctrl + Home (then Ctrl+Home again) |
| Rename a sheet | Alt+H, O, R or double-click the tab |
| Delete a sheet | Alt+H, D, S |
| Insert a sheet (older Excel) | Shift + F11 |
| Select all sheets | Right-click a tab → Select All Sheets |
| Select several sheets | Ctrl + click each tab |
| Copy a sheet | Ctrl + drag the sheet tab |
| Move a sheet | Drag the sheet tab |
| Open Move or Copy dialog | Alt+H, O, M |
| Jump to a specific sheet | Right-click the tab arrows (bottom-left) |
| Hide a sheet | Right-click the tab → Hide |
| Unhide a sheet | Right-click any tab → Unhide |
💡 Note: Mac users replace Ctrl with ⌘ Command for most of these (Page Down becomes Fn+↓).
MOST USED
Add a new worksheet (3 ways)
| Method | How |
|---|---|
| Fastest | Shift + F11 — inserts a sheet instantly |
| Mouse | Click the + button next to the sheet tabs |
| Menu | Home → Insert → Insert Sheet, or right-click a tab → Insert |
✅ Pro Tip: To add several sheets at once, select multiple existing sheets first (Ctrl+click), then press Shift+F11 — Excel inserts one new sheet for each selected sheet.
GOOD TO KNOW
Two shortcuts that save the most time
▸ Ctrl + Page Down / Page Up
If your workbook has 10+ tabs, scrolling to find the right one wastes time. Ctrl+Page Down moves one sheet right and Ctrl+Page Up moves one left — instantly, no matter how many sheets you have.
▸ Ctrl + drag to copy a sheet
Hold Ctrl and drag a sheet tab sideways. The cursor shows a small +, and Excel creates a copy named "Sheet1 (2)". This is the fastest way to duplicate a formatted worksheet.
FREQUENTLY ASKED
Frequently Asked Questions
What is the shortcut to add a new sheet in Excel?
Press Shift+F11 to insert a new worksheet. It is added before the active sheet.
How do I switch between worksheets quickly?
Press Ctrl+Page Down to move to the next sheet and Ctrl+Page Up for the previous sheet.
What is the shortcut to rename a sheet?
Press Alt then H, then O, then R (Alt+H, O, R). You can also just double-click the sheet tab.
How do I delete a sheet with the keyboard?
Press Alt then H, then D, then S (Alt+H, D, S). Excel asks you to confirm before deleting.
Can I select all sheets at once?
Right-click any sheet tab and choose Select All Sheets, or Ctrl+click each tab to select individual ones.
QUICK LINKS
Continue Exploring
SOURCES
Sources & References
Written and fact-checked against Microsoft's official Excel documentation.
Disclaimer: This guide is for informational purposes only. Last Updated: September 21, 2026.