MS Excel: Workbook Shortcuts for Windows, Mac, Web
- Fakhriddinbek
- 1 hour ago
- 2 min read
Mastering shortcuts for file handling and workbook management in Excel boosts your workflow by minimizing reliance on the ribbon or mouse. From quickly opening a workbook to adjusting how it's viewed, these shortcuts are essential for efficient spreadsheet use.
File Open, Close, Save Shortcuts
Action | Windows Shortcut | Mac Shortcut | Excel for Web | Description |
Open Workbook | Ctrl + O | Command + O | Ctrl + O | Opens the Open dialog to select a file. |
Save Workbook | Ctrl + S | Command + S | Ctrl + S | Saves the current workbook. |
Save As | F12 | Command + Shift + S | Ctrl + S (in web) | Opens Save As dialog for renaming or new format. |
Close Workbook | Ctrl + W | Command + W | Ctrl + W | Closes the active workbook window. |
Exit Excel | Alt + F4 | Command + Q | Not applicable | Closes the entire Excel application. |
Workbook Actions & Options Shortcuts
Action | Windows Shortcut | Mac Shortcut | Excel for Web | Description |
Excel Options Dialog | Alt + F + T | Command + , | Not available | Opens the Excel Options menu for app-wide settings. |
New Workbook | Ctrl + N | Command + N | Ctrl + N | Creates a new, blank workbook. |
Print Workbook | Ctrl + P | Command + P | Ctrl + P | Opens the Print dialog. |
Show File Menu | Alt + F | Control + Fn + F2 (partial) | Alt + F | Displays the File backstage menu. |
Open Recent Files | Alt + F + R | No direct shortcut | Not available | Quickly opens the recent files list. |
Show Save As Menu | Alt + F + A | Command + Shift + S | Not available | Access Save As options like OneDrive, PDF, etc. |
Workbook View Settings Shortcuts
Action | Windows Shortcut | Mac Shortcut | Excel for Web | Description |
Zoom In | Alt + W + Q, then tab to value | Command + Mouse Scroll Up | Not supported | Changes zoom level (use mouse scroll + Ctrl/Cmd if applicable). |
Zoom Out | Same as above | Command + Mouse Scroll Down | Not supported | Decreases zoom level. |
Freeze Panes | Alt + W + F + F | Command + Shift + R | Not available | Freezes rows or columns based on selection. |
Split Window | Alt + W + S | Command + Option + S | Not available | Splits the worksheet into separate scrollable panes. |
Full Screen View | Alt + V + U | Control + Command + F | Not available | Toggles full screen mode (Excel window maximized). |
Show/Hide Gridlines | Alt + W + V + G | No direct shortcut | Not available | Toggles visibility of worksheet gridlines. |
Show/Hide Formula Bar | Alt + W + V + F | No direct shortcut | Not available | Shows or hides the formula bar above worksheet. |
Show/Hide Headings | Alt + W + V + H | No direct shortcut | Not available | Toggles row and column headers. |
Tips for Workbook Efficiency
Use Ctrl + N, Ctrl + S, and Ctrl + P as part of your daily routine.
Access advanced file options quickly using Alt + F followed by the relevant key.
Customize view settings to match your screen or task.
These shortcuts empower you to handle Excel workbooks swiftly—from opening and saving files to adjusting how you interact with your spreadsheet workspace.
留言