KEYBOARD SHORTCUT KEYS in Excel || POWERFUL Microsoft Excel keyboard shortcuts || EASY Microsoft Excel keyboard shortcuts
Here’s a list of useful Microsoft Excel keyboard shortcuts, grouped by category for easier reference. These work in most modern versions of Excel (Windows):
Basic Shortcuts
Action Shortcut
New workbook Ctrl + N
Open workbook Ctrl + O
Save workbook Ctrl + S
Print Ctrl + P
Undo Ctrl + Z
Redo Ctrl + Y
Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Select all Ctrl + A
Find Ctrl + F
Replace Ctrl + H
Close workbook Ctrl + W
Navigation
Action Shortcut
Move to beginning of row Home
Move to beginning of worksheet Ctrl + Home
Move to last cell with data Ctrl + End
Move one screen down/up Page Down / Page Up
Move one worksheet right/left Ctrl + Page Down / Ctrl + Page Up
Move to next cell Tab
Move to previous cell Shift + Tab
Editing Cells
Action Shortcut
Edit active cell F2
Fill down Ctrl + D
Fill right Ctrl + R
Insert current date Ctrl + ;
Insert current time Ctrl + Shift + ;
Insert new row Ctrl + Shift + +
Delete selected row/column Ctrl + -
Formatting
Action Shortcut
Bold Ctrl + B
Italic Ctrl + I
Underline Ctrl + U
Open Format Cells dialog Ctrl + 1
Center align Alt + H, A, C
Format as currency Ctrl + Shift + $
Format as percentage Ctrl + Shift + %
Format as number Ctrl + Shift + !
Formulas
Action Shortcut
Start a formula =
Toggle absolute/relative reference F4 (while editing formula)
Calculate active worksheet F9
Insert function Shift + F3
AutoSum Alt + =
Table and Cell Selection
Action Shortcut
Select entire row Shift + Space
Select entire column Ctrl + Space
Select current region Ctrl + Shift + *
Extend selection down/up Shift + ↓ / Shift + ↑
Extend selection right/left Shift + → / Shift + ←