Course outline / Excel shortcuts
Lesson 9 of 75 · Beginner · 4 exercises
Moving around fast
Jump to the edges of your data and select it all from the keyboard.
What you'll practise
- Jump to the bottom of the data Shortcut
- Jump to the end of a row Shortcut
- Go to the last used cell Shortcut
- Select everything Shortcut
Jump to the bottom of the data
In a long list, scrolling wastes time. Ctrl + Down arrow jumps to the last filled cell in the column.
Hold Ctrl and press the Down arrow.
Jump to the end of a row
Ctrl + Right arrow jumps to the last filled cell in the row.
Hold Ctrl and press the Right arrow.
Go to the last used cell
Ctrl + End goes to the bottom-right corner of everything you've used on the sheet.
Hold Ctrl and press End.
Select everything
Ctrl + A selects the whole table you're in. Press it again to select the entire sheet.
Hold Ctrl and press A.
Try it in a real spreadsheet
Every step checks your answer instantly and tells you exactly what to fix.