Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Monday, July 9, 2018

EXCEL WORKBOOK AND WORKSHEETS SHORTCUT KEYS

EXCEL WORKBOOK AND WORKSHEETS SHORTCUT KEYS

ALT + H + D + S
Purpose:Use this excel shortcut key to Delete current active sheet

ALT + H + O + M
Purpose:Use this excel shortcut key to Display the Move or Copy sheet dialog

ALT + H + O + P
Purpose:Use this excel shortcut key to Display the Protect Sheet dialog box

ALT + H + O + R
Purpose:Use this excel shortcut key to Rename current active sheet

ALT + H + O + T
Purpose:Use this excel shortcut key to Expand the sheet Tab Color drop-down menu

ALT + H + O + T + N
Purpose:Use this excel shortcut key to Set current worksheet tab to have no color

ALT + H + O + U + H
Purpose:Use this excel shortcut key to Display the Unhide sheet dialog box

ALT + H + O + U + S
Purpose:Use this excel shortcut key to Hide current active sheet

ALT + SHIFT + F1
Purpose:Use this excel shortcut key to Insert new worksheet

CTRL + F11
Purpose:Use this excel shortcut key to Insert New Macro sheet

CTRL + F12
Purpose:Use this excel shortcut key to Display the Open dialog box

CTRL + F4
Purpose:Use this excel shortcut key to Close current selected workbook window

CTRL + F7
Purpose:Use this excel shortcut key to Apply Move command on active workbook window (when not maximized). (A) Use arrow keys to move window; and When finished, use Enter to confirm or Esc to cancel.

CTRL + F8
Purpose:Use this excel shortcut key to Apply Resize command on active workbook window (when not maximized). (A) Use arrow keys to move window; and When finished, use Enter to confirm or Esc to cancel.

CTRL + F9
Purpose:Use this excel shortcut key to Minimize current selected workbook window

CTRL + N
Purpose:Use this excel shortcut key to Create a new blank workbook

CTRL + O
Purpose:Use this excel shortcut key to Display Open tab of Backstage View (open a workbook)

CTRL + S
Purpose:Use this excel shortcut key to Save active file (A) using current file name and format, and (B) in current file location

CTRL + W
Purpose:Use this excel shortcut key to Close the selected workbook

F12
Purpose:Use this excel shortcut key to Display the Save As dialog box

SHIFT + F11
Purpose:Use this excel shortcut key to Insert a new worksheet in the current workbook

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...