Previous Worksheet in Excel
Navigating to the previous worksheet in a workbook helps you move efficiently between multiple sheets without using the mouse.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Page Up | Fn + Ctrl + Up Arrow |
What Does This Shortcut Do?
This shortcut moves the active selection to the previous worksheet in the workbook, cycling from the current sheet to the left.
How to Use the Shortcut
- Open your Excel workbook
- Press the keyboard shortcut:
Windows: Ctrl + Page Up
Mac: Fn + Ctrl + Up Arrow - The active worksheet will switch to the previous sheet
Tips & Best Practices
- Combine with Next Worksheet shortcut for fast navigation
- Use when reviewing data across multiple worksheets
- Works well with grouped sheets for sequential navigation
FAQ
- Q: Can I use this shortcut to jump multiple sheets?
- No, it moves one sheet at a time. For multiple sheets, you need to repeat the shortcut.
- Q: What if I’m on the first sheet?
- The shortcut cycles to the last sheet in the workbook if pressed again.
- Q: Does this affect my data?
- No, it only changes the active worksheet view.