Resources

Microsoft Excel

Here are some shortcuts for Microsoft Excel.

CTRL Shortcut Keys

Unhides any Hidden Rows within Selection	CTRL + (
Unhides any Hidden Columns within Selection	CTRL + )
Applies Outline Border to selected	CTRL + &
Removes Outline Border to selected	CTRL + _
Applies General Number Format	CTRL + ~
Applies Currency Format	CTRL + $
Applies Percentage Format	CTRL + %
Applies Exponential Number Format	CTRL + ^
Applies Date Format	CTRL + #
Applies Time Format	CTRL + @
Applies Number Format	CTRL + !
Displays Delete Dialog Box for selected	CTRL + -
Enters Current Time	CTRL + :
Enters Current Date	CTRL + ;
Alternates between displaying Values & Formulas	CTRL + `
Displays the Insert Dialogue Box	CTRL + +
Displays the Format Cells Dialogue Box	CTRL + 1
Applies or Removes Bold Formatting	CTRL + 2
Applies or Removes Italic	CTRL + 3
Applies or Removes Underlining	CTRL + 4
Applies or Removes Strikethrough	CTRL + 5
Toggle Hide Objects, Displaying Objects, Displaying Placeholders.	CTRL + 6
Displays or Hides the Standard Toolbar	CTRL + 7
Displays or Hides the Outline Symbols	CTRL + 8
Hides the Selected Rows	CTRL + 9
Hides the Selected Columns	CTRL + 0
Selects the Entire Worksheet	CTRL + A
Applies or Removes Bold Formatting	CTRL + B
Copies the Selected Cells	CTRL + C
Copy Contents and Formatting to Below	CTRL + D
Display the Find Dialogue Box	CTRL + F
Displays the Go To Dialogue Box	CTRL + G
Displays Find & Replace Dialogue Box	CTRL + H
Applies or Removes Italic Formatting	CTRL + I
Displays the Insert/Edit Hyperlink	CTRL + K
Displays the Create List Dialogue Box	CTRL + L
Creates New Blank File	CTRL + N
Displays Open Dialogue Box	CTRL + O
Displays Print Dialogue Box	CTRL + P
Copy Format and Contents to the Right	CTRL + R
Saves the Active File	CTRL + S
Applies or Removes Underlining	CTRL + U
Inserts contents of Clipboard	CTRL + V
Closes the Selected Workbook Window	CTRL + W
Cuts the Selected Cells	CTRL + X
Repeats the Last Command or Action	CTRL + Y
Undo	CTRL + Z

Function Keys

Displays the Help Task Pane	F1
Closes and Reopens Current Task Pane	CTRL + F1
Creates Chart of Data within Range	Alt + F1
Inserts a New Worksheet	Alt + Shift + F1
Edits the active cell	F2
Edits a Cell Comment	Shift + F2
Pastes a Defined Name Into a Formula	F3
Displays the Insert Function Dialogue Box	Shift + F3
Repeats the Last Command or Action	F4
Closes the Selected Workbook Window	CTRL + F4
Displays the Go To Dialogue Box	F5
Restores the window size	CTRL + F5
Switches to Next Pane in Split Worksheet	F6
Switches to Previous Pane in Split Worksheet	Shift + F6
Switches to Next Workbook Window	CTRL + F6
Displays the Spelling Dialogue Box	F7
Performs the Move Command on Workbook Window	CTRL + F7
Toggles Extend Mode On / Off	F8
Calculates all Worksheets in All Open Workbooks	F9
Displays the Save As Dialogue Box	F12

Window Operations

Toggle Access Navigation Pane	F11
Cycle Between Open Windows	CTRL + F6
Restore Selected Minimized Window	Enter
Display Access Control Menu	Alt + Spacebar
Dsplay the Access Shortcut Menu	Shift + F10
Close the Active Window	CTRL + W

Visit Our Divisions: