Work Faster in Microsoft Excel
Never move your hand over to the mouse again. Getting used to a select few shortcuts like navigation, formatting, and calculations on your spreadsheets. Constant movement of hand will immensely affect your efficiency and performance in Excel.
Basic Navigation Shortcuts
|
Action |
Windows |
Mac |
|
Move to the next cell |
Tab |
Tab |
|
Move to the previous cell |
Shift + Tab |
Shift + Tab |
|
Move to the beginning of the row |
Home |
Fn + ← |
|
Move to the end of the worksheet |
Ctrl + End |
Cmd + ↓ |
|
Select the entire row |
Shift + Space |
Shift + Space |
|
Select the entire column |
Ctrl + Space |
Cmd + Space |
Data Entry and Editing Shortcuts
|
Action |
Windows |
Mac |
|
Copy |
Ctrl + C |
Cmd + C |
|
Paste |
Ctrl + V |
Cmd + V |
|
Cut |
Ctrl + X |
Cmd + X |
|
Undo |
Ctrl + Z |
Cmd + Z |
|
Redo |
Ctrl + Y |
Cmd + Y |
|
Fill down |
Ctrl + D |
Cmd + D |
|
Fill right |
Ctrl + R |
Cmd + R |
|
Start a new line in the same cell |
Alt + Enter |
Ctrl + Option + Return |
Formula & Calculation Shortcuts
|
Action |
Windows |
Mac |
|
Insert function |
Shift + F3 |
Shift + F3 |
|
Start a formula |
= (equal sign) |
= |
|
Calculate the active worksheet |
F9 |
Fn + F9 |
|
Toggle absolute reference |
F4 |
Cmd + T |
|
AutoSum |
Alt + = |
Cmd + Shift + T |
Formatting Shortcuts
|
Action |
Windows |
Mac |
|
Bold |
Ctrl + B |
Cmd + B |
|
Italic |
Ctrl + I |
Cmd + I |
|
Underline |
Ctrl + U |
Cmd + U |
|
Open Format Cells dialog |
Ctrl + 1 |
Cmd + 1 |
|
Center align |
Alt + H + A + C |
Cmd + E (via Ribbon) |
🧠 Tips to Memorise Shortcuts
Start with three to five at a time, using them day to day.
Put some cheat sheets on the wall next to your monitor.
Use the shortcut keys instead of toolbar buttons until you get used to them.
Bonus: Create personalised Keyboard Shortcuts (Mac Only):
Go to System Preferences > Keyboard > Shortcuts and add your Excel-specific combinations for common actions.
🎓 Learn More with Other Level's
Take your Microsoft Excel skills to the next level:
-
🌐 Visit our Other Levels Website
-
📺 Watch free tutorials on our Other Levels YouTube Channel, and learn Microsoft Excel from beginner to advanced.
✍️ Other Articles, Tips & Tricks you would like:
- Master Flash Fill in Microsoft Excel
- Create a Progress Bar in Excel Using REPT Formula – No Charts Needed!
- Top 10 Microsoft Excel Tips and Tricks
يشارك:
Experience the Power of CONCAT Function in Microsoft Excel
Use VLOOKUP Function Like a Pro in Microsoft Excel