Excel Shortcut Keys

🗂️ 1. Basic Excel Shortcuts

Shortcut	Action
Ctrl + N	New workbook
Ctrl + O	Open workbook
Ctrl + S	Save workbook
F12	Save As
Ctrl + P	Print workbook
Ctrl + Z	Undo
Ctrl + Y	Redo
Ctrl + C	Copy
Ctrl + X	Cut
Ctrl + V	Paste
Ctrl + A	Select all
Ctrl + F	Find
Ctrl + H	Replace
Alt + F4	Close Excel

🧭 2. Navigation Shortcuts

Shortcut	Action
Arrow keys	Move one cell
Ctrl + Arrow key	Jump to data edge
Home	Move to beginning of row
Ctrl + Home	Go to cell A1
Ctrl + End	Go to last used cell
Page Up / Down	Scroll up/down one screen
Alt + Page Up / Down	Scroll left/right one screen

🎨 3. Formatting Shortcuts

Shortcut	Action
Ctrl + B	Bold
Ctrl + I	Italic
Ctrl + U	Underline
Ctrl + 1	Format cells dialog
Ctrl + Shift + $	Currency format
Ctrl + Shift + %	Percent format
Ctrl + Shift + #	Date format
Ctrl + Shift + ^	Scientific format
Ctrl + Shift + !	Number format
Alt + H + H	Fill color menu

📄 4. Worksheet & Workbook Management

Shortcut	Action
Ctrl + Page Up / Down	Switch worksheets
Shift + F11	Insert new worksheet
Alt + E + L	Delete worksheet
Alt + H + O + R	Rename worksheet
Ctrl + Tab	Switch open workbooks

🧾 5. Data Entry & Editing

Shortcut	Action
Enter	Complete cell entry
Tab	Move to next cell right
Shift + Tab	Move to previous cell
Alt + Enter	Insert line break in cell
Ctrl + D	Fill down
Ctrl + R	Fill right
Backspace	Delete one character
Delete	Clear content
F2	Edit active cell

➕ 6. Formulas & Functions

Shortcut	Action
=	Start a formula
Alt + =	AutoSum
Ctrl + Shift + Enter	Enter array formula
F4	Toggle absolute/relative references
Ctrl + ` (grave accent)	Show/hide formulas
Shift + F9	Calculate active sheet
F9	Calculate all worksheets

🖱️ 7. Data Selection Shortcuts

Shortcut	Action
Shift + Arrow keys	Select cells
Ctrl + Shift + Arrow keys	Select to edge
Ctrl + Space	Select entire column
Shift + Space	Select entire row
Ctrl + A	Select entire worksheet/data region
Ctrl + Shift + *	Select current region

📊 8. Cell, Row & Column Operations

Shortcut	Action
Ctrl + Shift + +	Insert row/column
Ctrl + –	Delete row/column
Ctrl + 9	Hide row
Ctrl + 0	Hide column
Ctrl + Shift + 9	Unhide row
Ctrl + Shift + 0	Unhide column
Alt + H + O + I	AutoFit column width

🧩 9. PivotTable Shortcuts

Shortcut	Action
Alt + N + V	Insert PivotTable
Alt + J T + F	Refresh PivotTable
Alt + Down Arrow	Open filter list
Ctrl + –	Remove field (contextual)

🔍 10. Filter & Sort Shortcuts

Shortcut	Action
Ctrl + Shift + L	Toggle filters
Alt + Down Arrow	Open filter menu
Alt + D + S	Sort dialog
Alt + A + T	Filter data
Alt + A + S + S	Sort ascending
Alt + A + S + D	Sort descending

📈 11. Chart Shortcuts

Shortcut	Action
F11	Create chart on new sheet
Alt + F1	Create chart in same sheet
Ctrl + 1	Format chart elements
Arrow keys	Navigate chart components

🛠️ 12. Other Useful Shortcuts

Shortcut	Action
Ctrl + K	Insert hyperlink
Ctrl + Alt + V	Open Paste Special
Alt + E + S + V	Paste values only
Ctrl + Shift + U	Expand/collapse formula bar
Ctrl + Alt + F9	Force calculate all sheets
Ctrl + ;	Insert current date
Ctrl + Shift + :	Insert current time

⌨️ 13. Function Key Shortcuts (F1–F12)

Shortcut	Action
F1	Open Help
Shift + F1	Show “What’s This?” help
F2	Edit active cell
Shift + F2	Insert/edit cell comment
Ctrl + F2	Print Preview
F3	Paste named range (if defined)
Shift + F3	Insert Function dialog box
F4	Repeat last action / Toggle absolute & relative refs (in formula)
Ctrl + F4	Close workbook window
Alt + F4	Close Excel
F5	Go To dialog box
Ctrl + F5	Restore workbook window size
F6	Switch between worksheet, ribbon, task pane, and Zoom controls
Shift + F6	Switch to previous pane
Ctrl + F6	Switch to next workbook window
F7	Spell check
Ctrl + F7	Move workbook window (with arrow keys)
F8	Turn on/off extend selection mode
Shift + F8	Add to selection
Ctrl + F8	Resize workbook window
F9	Calculate all worksheets
Shift + F9	Calculate active worksheet
Ctrl + F9	Minimize workbook window
F10	Activate menu bar
Shift + F10	Display right-click menu
Ctrl + F10	Maximize or restore workbook window
F11	Create chart on new sheet
Shift + F11	Insert new worksheet
Alt + F11	Open Visual Basic for Applications (VBA) Editor
F12	Save As dialog