Jump to: Open and Save Workbooks, Print Workbooks, Manage Worksheet Tabs, Freeze, Split, and Hide Windows
Ctrl+O | Open Workbook via 'new' open box to access additional locations |
Ctrl+Alt+F2 | Open file via classic open dialog window |
Alt+F, O | File Open via Excel file manager |
Alt+F, O + 1...9 | Open recent file (1 thru 9) |
Alt+F, O, Y1...Z | Open recent file (10 upwards) |
Alt+F, O, K | File Open from OneDrive Link |
Ctrl+S | Save File with current file name |
F12 | Save file as via standard save dialog box |
Alt+F, A | File Save as via Excel file manager |
Alt+F, A, K | File Save to OneDrive Link |
Esc | Exit open/ save menu |
Ctrl+P | Print. This won't offer offer Key Tips/ Options. To continue with shortcuts, use the new Key Options below. |
Alt+F, P | Open File Print menu |
I in Print Menu | Select printer |
Alt+P if Key Tips disappear | Return Print key tips/ options |
V in Print Menu | Focus on View pane; use arrow keys to forward/ backward preview pages |
G in Print Menu | Page setup |
N in Print Menu | Set Number of copies |
Ctrl+Page Down/Page Up | Move to the next/ previous worksheet in current workbook |
Alt+H, IS | Insert worksheet (Home - Insert Sheet) |
Alt+H, DS | Delete worksheet Home - Delete Sheet |
Alt+H, OR | Rename worksheet (Home - Format - Rename worksheet) |
Alt+H, OM | Move worksheet (Home - Format - Move worksheet) |
Alt+H, OT | Worksheet tab color, continue with mouse or arrow keys (Home - Format - Tab color) |
Alt+W+FF | View - Freeze or unfreeze; unfreeze works for any Freeze Setting |
Alt+W+R | View - Freeze first visible Row on screen |
Alt+W+C | View - Freeze first Column on screen |
Ctrl+9 | Hide selected rows |
Ctrl+Shift+9 | Unhide hidden rows within the selection |
Ctrl+0 | Hide selected columns |
Shift+F10, then U | Unhide selected columns (Ctrl+Shift+0 not working in Excel 2010, 2013, or 2016) |
Alt+W S | Split or unsplit Worksheet at current position |
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy