Boost your productivity with these essential keyboard combinations
How to use shortcuts
Hold down the Ctrl key while pressing the other key(s) to execute these shortcuts.
Excel Control Key Shortcuts Categories
File & Workbook Operations
Create new workbook
Ctrl + N
Open existing workbook
Ctrl + O
Save workbook
Ctrl + S
Save As
Ctrl + Shift + S
Print
Ctrl + P
Close workbook
Ctrl + W
Quit Excel
Ctrl + Q
Editing Shortcuts
Copy selection
Ctrl + C
Cut selection
Ctrl + X
Paste selection
Ctrl + V
Undo last action
Ctrl + Z
Redo last action
Ctrl + Y
Find text
Ctrl + F
Replace text
Ctrl + H
Insert hyperlink
Ctrl + K
Insert comment
Ctrl + Shift + F2
Navigation Shortcuts
Go to cell
Ctrl + G
Move to edge of data region
Ctrl + Arrow
Select entire column
Ctrl + Space
Select entire row
Ctrl + Shift + Space
Select entire worksheet
Ctrl + A
Switch between worksheets
Ctrl + Page Up/Down
Move to next workbook
Ctrl + Tab
Move to previous workbook
Ctrl + Shift + Tab
Formatting Shortcuts
Bold text
Ctrl + B
Italic text
Ctrl + I
Underline text
Ctrl + U
Apply outline border
Ctrl + Shift + &
Remove all borders
Ctrl + Shift + _
Open Format Cells dialog
Ctrl + 1
Apply general format
Ctrl + Shift + ~
Apply time format
Ctrl + Shift + @
Apply date format
Ctrl + Shift + #
Formula & Data Shortcuts
Insert function
Ctrl + Shift + A
Toggle absolute/relative references
Ctrl + F4
AutoSum selection
Ctrl + =
Insert current date
Ctrl + ;
Insert current time
Ctrl + Shift + :
Create a table
Ctrl + T
Open filter dropdown
Ctrl + Shift + L
Expand/Collapse formula bar
Ctrl + Shift + U
Calculate all worksheets
Ctrl + F9
Additional Useful Shortcuts
Fill down
Ctrl + D
Fill right
Ctrl + R
Hide selected rows
Ctrl + 9
Unhide selected rows
Ctrl + Shift + 9
Hide selected columns
Ctrl + 0
Unhide selected columns
Ctrl + Shift + 0
Check spelling
Ctrl + F7
Open thesaurus
Ctrl + Shift + F7
Insert new worksheet
Ctrl + Shift + F11
Open macro dialog
Ctrl + F8
