0
0
Google Sheetsspreadsheet~10 mins

Keyboard shortcuts in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Common keyboard shortcuts in Google Sheets for quick actions.

CellValue
A1Action
B1Shortcut
A2Copy
B2Ctrl + C
A3Paste
B3Ctrl + V
A4Undo
B4Ctrl + Z
A5Redo
B5Ctrl + Y
A6Find
B6Ctrl + F
A7Save
B7Ctrl + S
Formula Trace
="Copy: " & B2 & ", Paste: " & B3 & ", Undo: " & B4
Step 1: "Copy: " & B2 & ", Paste: " & B3 & ", Undo: " & B4
Cell Reference Map
    A       B
1 | Action | Shortcut
2 | Copy   | Ctrl + C
3 | Paste  | Ctrl + V
4 | Undo   | Ctrl + Z

Arrows: Formula uses B2, B3, B4
The formula references shortcuts in cells B2, B3, and B4 to build a combined text.
Result
    A                             
8 | Copy: Ctrl + C, Paste: Ctrl + V, Undo: Ctrl + Z
The formula result is a single text string summarizing the shortcuts for Copy, Paste, and Undo.
Sheet Trace Quiz - 3 Questions
Test your understanding
Which cells does the formula use to get shortcut keys?
AB2, B3, B4
BA2, A3, A4
CB1, B2, B3
DA1, B1, B2
Key Result
Concatenate text and cell values using & to build a combined string.