Google Sheets shortcuts practice
Learn Google Sheets shortcuts by pressing them on your own keyboard, one short lesson at a time.
55 shortcuts in 7 lessons. Your progress is kept in this browser.
Getting started
- Just learned
- Recalling
- Steady
- Quick
- Fluent
- Second nature
- Learned
- 0
- Due now
- 0
- New
- 0
- Streak
- 0
Lessons
- 1Common actions
Open the shortcut help panelSearch the menusUndoRedoFindFind and replacePaste values onlyPaste format onlyPrint
- 2Selecting and moving
Select the columnSelect the rowSelect allGo to the first cellGo to the last cellExtend the selection to the data edgeGo to the next sheetGo to the previous sheetInsert a new sheet
- 3Editing cells, part 1
Edit the active cellNew line in a cellFill downFill rightInsert today's dateInsert the timeInsert the date and time
- 4Editing cells, part 2
Insert a linkInsert a commentInsert a noteToggle absolute and relative referencesInsert an array formulaShow formulas
- 5Formatting, part 1
BoldItalicUnderlineStrikethroughAlign leftCenterAlign rightNumber format
- 6Formatting, part 2
Time formatDate formatCurrency formatPercent formatScientific formatClear formattingOuter borderRemove borders
- 7Rows and columns
Insert rows or columnsDelete rows or columnsHide rowsUnhide rowsHide columnsUnhide columnsGroup rows or columnsUngroup rows or columns
How practice works
Each lesson is up to ten Google Sheets shortcuts from one group. Press the keys on your own keyboard, or tap them on the keyboard on screen. Some combinations, such as Cmd+W, are kept by your browser or system; those are always tapped, so practising never closes your tab.
- Learn shows each new shortcut once with its keys, then asks for it again without them. A small copy of Google Sheets sets each task up, and pressing the shortcut does the job in it. It schedules the next review.
- Practice goes through a lesson at your own pace. Choose whether the keys show always, after three seconds or never. It does not change your review schedule.
- Speed run asks for every shortcut in the lesson once, without hints, against the clock. Get 70% right first time to pass the lesson; your best time is kept.
- Today's session brings back the shortcuts that are due for review, plus up to eight new ones.
Every shortcut climbs six levels as you recall it first time: just learned, recalling, steady, quick, fluent and second nature. Reviews space out from a day to six months; a miss drops it back two levels and brings it back within minutes. Progress is stored in this browser only, separately for each system.
To look a shortcut up instead, use the Google Sheets keyboard shortcuts list or print the Google Sheets cheat sheet.