Previous Workbook in Excel
When multiple Excel workbooks are open, this shortcut lets you move backward to the previously opened workbook without using the mouse.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + F6 | Cmd + Shift + ` |
What Does This Shortcut Do?
This shortcut cycles through all open Excel workbooks in reverse order, activating the previously opened workbook.
How to Use the Shortcut
- Open two or more Excel workbooks
- Press Ctrl + Shift + F6 (Windows) or Cmd + Shift + ` (Mac)
- The previous workbook becomes active
- Repeat to continue cycling backward
Tips & Best Practices
- Use Next Workbook to move forward
- Ideal when comparing or copying data between files
- Does not change workbook content
FAQ
- Q: Does this shortcut work with only one workbook open?
- No, at least two open workbooks are required.
- Q: Does this affect workbook order?
- No, it only changes the active workbook.
- Q: Can this shortcut be customized?
- No, Excel does not allow customization of workbook navigation shortcuts.