Excel keyboard shortcuts

File management Formatting Text

New workbook Ctrl + N Bold Ctrl + B Find Ctrl + F
Open Ctrl + O Underline Ctrl + U Replace Ctrl + H
Save Ctrl + S Italic Ctrl + I Delete 1 character to the left Backspace
Save as F12 Remove fill color Alt H H N Delete 1 word to the left Ctrl + Backspace
Close workbook Ctrl + W Remove borders Alt H B N Contextual menu (=right-click) Shift + F10
Close application Alt + F4 Add borders (all) Alt H B A Run a spelling and grammar check F7
Move to the next/previous sheet Ctrl + ⇟ / ⇞ Add borders (external) Alt H B S
Data
Add new sheet Shift + Alt + F1 Add borders (thick) Alt H B T
Merge cells Alt H M C
Rename active sheet Alt H O R Format as percentage Ctrl + Shift + %
Alt H D S
Unmerge cells Alt H M U
Delete active sheet Open the format dialog box Ctrl + Shift + F
Add/remove filter Ctrl + Shift + L
Autofit columns Alt H O I
Copy and paste Show values in a filter or list Alt + ↓
Autofit rows Alt H O A
Copy Ctrl + C Check/uncheck values in a filter’s list Space
Selection Insert Table Alt N T
Paste Ctrl + V
Select all Ctrl + A Insert PivotTable Alt N V
Paste to the right Ctrl + R
Go to end of range Ctrl + Arrow
Paste down Ctrl + D Windows
Add 1 cell to the selection Shift + Arrow
Cut Ctrl + X Go to Desktop ⊞ + D
Add 1 range to the selection Ctrl + Shift + Arrow
Duplicate Ctrl + D Open Computer ⊞ + E
Move item up/down in bulleted list Alt + Shift + Arrow
Paste as formula Alt H V F Open Clipboard history ⊞ + V
Alt H V V Activation Selection Mode F8
Paste as value Lock computer ⊞ + L
Select current row Shift + Space
Delete selection Ctrl + - Launch speech-to-text ⊞ + H
Select current column Ctrl + Space
Insert cells/rows/columns Ctrl + + Show screen display options ⊞ + P
Hide active row Ctrl + Shift + 9
Cancel and repeat Screen clipping ⊞ + Shift + S
Cancel Ctrl + Z Formulas Move a window to screen corner ⊞ + Arrow
Cancel cancellation Ctrl + Y Edit active cell F2 Insert emoji or animated Gif ⊞ + .
View and insert named ranges F3 Move to previous folder Alt + ←
Repeat last action F4
Validate the suggested formula Tab Move to parent folder Alt + ↑
Date and time Add a line break in the formula Alt + Enter Open new tab Ctrl + T
Insert current date Ctrl + ; Sum all cells above Alt + = Close current tab Ctrl + W
Insert current time Ctrl + Shift + ; Expand the formula bar Ctrl + Shift + U Restore last closed tab Ctrl + Shift + T
Flash fill the selected range Ctrl + E Full screen ON/OFF F11