Excel Shortcuts Managing Workbooks, Worksheets, and Tabs

Jump to: Open and Save Workbooks, Print Workbooks, Manage Worksheet Tabs, Freeze, Split, and Hide Windows

1. Open and Save Workbooks

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

2. Print Workbooks

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

3. Manage Worksheet Tabs

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)

4. Freeze, Split, and Hide Windows

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

Created by max on 1/14/2021

 

0 Comments for '(Excel) - Excel Shortcuts Managing Workbooks, Worksheets, and Tabs'   

 
Email me replies   
icon

Microsoft Excel Shortcuts

Advertising for Consideration:

Ads for Consideration:

Related:

Please kindly review and accept Terms of Use and Cookie & Policy Policy