Keyboard shortcuts
The Google Sheets shortcuts for moving, selecting, formatting and writing formulas.
Lessons
In the order the Roadmap teaches them.
In the full course. Beginner · 10 min
The 10 shortcuts that save the most time
Use the ten shortcuts people reach for all day, to jump, select, fill, undo, edit, copy and paste without the mouse.
See the lessonIn the full course. Beginner · 8 min
Move around big sheets fast
Jump to the top, the bottom and the edges of a long list with the keyboard instead of scrolling.
See the lessonIn the full course. Beginner · 9 min
Select data instantly
Select a whole column, a whole table or an exact range in one or two key presses, even when the data has gaps.
See the lessonIn the full course. Confident · 10 min
Formatting shortcuts
Make text bold or italic and show numbers as dollars or percents with key presses instead of the mouse.
See the lessonIn the full course. Confident · 9 min
Insert and delete shortcuts
Select whole rows or columns, then insert or delete them with one key press.
See the lessonIn the full course. Confident · 10 min
Formula shortcuts
Lock a reference with F4, total a column with AutoSum's keys, open a formula with F2 and check a whole sheet with Show formulas.
See the lessonGet the full course
Every lesson in the Google Sheets course, with new lessons added as they're written.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Excel course for US$49.