Introduction to Excelย
Navigation Shortcuts (Move Around Quickly)
-
- ๐ผ
Ctrl + โโ Jump to top
- ๐ผ
-
- ๐ฝ
Ctrl + โโ Jump to bottom
- ๐ฝ
-
- โฌ
๏ธ
Ctrl + โโ Jump to far left
- โฌ
๏ธ
-
- โก๏ธ
Ctrl + โโ Jump to far right
- โก๏ธ
-
- ๐งญ
Ctrl + Homeโ Go to A1
- ๐งญ
-
- ๐งญ
Ctrl + Endโ Go to last cell with data
- ๐งญ
โ๏ธ Editing Shortcuts (Fast Edits)
-
- ๐
F2โ Edit current cell
- ๐
-
- โ
Deleteโ Clear contents
- โ
-
- ๐
Ctrl + Zโ Undo
- ๐
-
- ๐
Ctrl + Yโ Redo
- ๐
-
- ๐
Ctrl + Xโ Cut
- ๐
-
- ๐
Ctrl + Cโ Copy
- ๐
-
- ๐ฅ
Ctrl + Vโ Paste
- ๐ฅ
๐ Formatting Shortcuts (Beautify It)
-
- ๐ก
Ctrl + 1โ Format cells
- ๐ก
-
- ๐ฒ
Ctrl + Shift + $โ Currency format
- ๐ฒ
-
- ๐
Ctrl + Shift + #โ Date format
- ๐
-
- ๐ข
Ctrl + Shift + !โ Number format
- ๐ข
-
- ๐
ฑ๏ธ
Ctrl + Bโ Bold
- ๐
ฑ๏ธ
-
- ๐ก
Ctrl + Uโ Underline
- ๐ก
-
- โ๏ธ
Ctrl + Iโ Italic
- โ๏ธ
๐ Data & Worksheet Management
-
- โ
Shift + F11โ New sheet
- โ
-
- ๐
Ctrl + PageUp/PageDownโ Switch sheets
- ๐
-
- ๐
Ctrl + Spaceโ Select column
- ๐
-
- ๐
Shift + Spaceโ Select row
- ๐
-
- ๐
Alt + =โ AutoSum
- ๐
-
- ๐
Ctrl + Fโ Find
- ๐
-
- ๐งฉ
Ctrl + Hโ Replace
- ๐งฉ
๐ง Power Shortcuts (Productivity Boosters)
-
- โ๏ธ
Ctrl + Shift + Lโ Toggle filters
- โ๏ธ
-
- ๐งฎ
F4โ Repeat last action
- ๐งฎ
-
- ๐ข
F9โ Recalculate
- ๐ข
-
- ๐
Alt + Enterโ New line in a cell
- ๐
-
- ๐
Ctrl + Dโ Fill down
- ๐
-
- โก๏ธ
Ctrl + Rโ Fill right
- โก๏ธ