Keyboard shortcuts in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant who uses Google Sheets daily.

📋 Request: Your manager wants you to speed up your work by using keyboard shortcuts for common tasks.

📊 Data: You have a simple sales data sheet with product names, quantities sold, and prices.

🎯 Deliverable: Create a guide sheet in the Google Sheets file listing useful keyboard shortcuts with descriptions and examples.

Sample Data

Product	Quantity Sold	Price
Notebook	15	2.50
Pen	30	1.20
Marker	10	3.00
Folder	20	1.50
Stapler	5	5.00
Paper Pack	50	4.00
Glue	8	1.75
Scissors	12	3.25

1

Step 1: Create a new sheet named 'Shortcuts Guide' in the Google Sheets file.

No formula needed; use the '+' button at the bottom to add a new sheet and rename it.

Expected Result

A new sheet named 'Shortcuts Guide' is added.

2

Step 2: In 'Shortcuts Guide', create a table with columns: 'Shortcut', 'Description', and 'Example'.

Enter headers in cells A1, B1, and C1 respectively.

Expected Result

Headers 'Shortcut', 'Description', and 'Example' appear in the first row.

3

Step 3: List the shortcut 'Ctrl + C' in cell A2, describe it as 'Copy selected cells' in B2, and write 'Copy product names' in C2.

Manually type the texts in the respective cells.

Expected Result

Row 2 shows the copy shortcut with description and example.

4

Step 4: List the shortcut 'Ctrl + V' in cell A3, describe it as 'Paste copied cells' in B3, and write 'Paste copied product names' in C3.

Manually type the texts in the respective cells.

Expected Result

Row 3 shows the paste shortcut with description and example.

5

Step 5: List the shortcut 'Ctrl + Z' in cell A4, describe it as 'Undo last action' in B4, and write 'Undo accidental deletion' in C4.

Manually type the texts in the respective cells.

Expected Result

Row 4 shows the undo shortcut with description and example.

6

Step 6: List the shortcut 'Ctrl + Y' in cell A5, describe it as 'Redo last undone action' in B5, and write 'Redo undone paste' in C5.

Manually type the texts in the respective cells.

Expected Result

Row 5 shows the redo shortcut with description and example.

7

Step 7: List the shortcut 'Ctrl + Arrow Keys' in cell A6, describe it as 'Move to edge of data region' in B6, and write 'Jump to last product in list' in C6.

Manually type the texts in the respective cells.

Expected Result

Row 6 shows navigation shortcut with description and example.

8

Step 8: List the shortcut 'Ctrl + Shift + L' in cell A7, describe it as 'Toggle filter on/off' in B7, and write 'Filter products by quantity' in C7.

Manually type the texts in the respective cells.

Expected Result

Row 7 shows filter toggle shortcut with description and example.

9

Step 9: Format the header row with bold text and a background color for clarity.

Select row 1, click bold, and apply a light fill color from the toolbar.

Expected Result

Header row stands out visually.

10

Step 10: Freeze the header row so it stays visible when scrolling.

Go to View > Freeze > 1 row.

Expected Result

Header row remains visible when scrolling down.

Final Result

Shortcuts Guide Sheet

+---------------------+--------------------------+--------------------------+
| Shortcut            | Description              | Example                  |
+---------------------+--------------------------+--------------------------+
| Ctrl + C            | Copy selected cells      | Copy product names       |
| Ctrl + V            | Paste copied cells       | Paste copied product names|
| Ctrl + Z            | Undo last action         | Undo accidental deletion |
| Ctrl + Y            | Redo last undone action  | Redo undone paste        |
| Ctrl + Arrow Keys   | Move to edge of data     | Jump to last product     |
| Ctrl + Shift + L    | Toggle filter on/off     | Filter products by quantity|
+---------------------+--------------------------+--------------------------+

✓Using keyboard shortcuts can save time and reduce mouse use.

✓Common shortcuts like copy, paste, undo, and redo are essential.

✓Navigation shortcuts help move quickly through data.

✓Toggle filter shortcut helps manage data views efficiently.

Bonus Challenge

Add a column 'Shortcut Category' to classify shortcuts (e.g., Editing, Navigation, Data Management) and fill it for each shortcut.

Show Hint

Use an extra column D with the header 'Shortcut Category' and type categories like 'Editing' for copy/paste, 'Navigation' for arrow keys.

Practice

1. Which keyboard shortcut in Google Sheets is used to undo the last action?

easy

A. Ctrl + Z (Command + Z on Mac)

B. Ctrl + Y (Command + Y on Mac)

C. Ctrl + C (Command + C on Mac)

D. Ctrl + V (Command + V on Mac)

Solution

1. Step 1: Understand the undo function

   Undo reverses the last change made in the sheet.

2. Step 2: Identify the correct shortcut

   Ctrl + Z (or Command + Z on Mac) is the standard undo shortcut in Google Sheets.

3. Final Answer:

   Ctrl + Z (Command + Z on Mac) -> Option A

4. Quick Check:

   Undo = Ctrl + Z [OK]

Hint: Undo is always Ctrl + Z or Command + Z on Mac [OK]

Common Mistakes:

• Confusing undo with redo shortcut
• Using copy or paste shortcuts instead
• Trying Ctrl + Y for undo instead of redo

2. Which of the following is the correct keyboard shortcut to copy selected cells in Google Sheets?

easy

A. Ctrl + C

B. Ctrl + V

C. Ctrl + X

D. Ctrl + Z

Solution

1. Step 1: Recall the copy shortcut

   Copy duplicates the selected content without removing it.

2. Step 2: Match the shortcut to copy

   Ctrl + C (Command + C on Mac) is the standard copy shortcut.

3. Final Answer:

   Ctrl + C -> Option A

4. Quick Check:

   Copy = Ctrl + C [OK]

Hint: Copy is always Ctrl + C or Command + C on Mac [OK]

Common Mistakes:

• Mixing copy with paste shortcut
• Using cut shortcut instead of copy
• Confusing undo shortcut with copy

3. If you want to quickly select an entire column in Google Sheets, which shortcut should you use?

medium

A. Shift + Space

B. Alt + Space

C. Ctrl + A

D. Ctrl + Space

Solution

1. Step 1: Understand selection shortcuts

   Ctrl + Space selects the entire column of the active cell.

2. Step 2: Identify the correct shortcut

   Ctrl + Space is the standard shortcut for selecting a column in Google Sheets.

3. Final Answer:

   Ctrl + Space -> Option D

4. Quick Check:

   Select column = Ctrl + Space [OK]

Hint: Select column quickly with Ctrl + Space [OK]

Common Mistakes:

• Using Shift + Space which selects a row
• Trying Ctrl + A which selects all cells
• Confusing Alt + Space with other shortcuts

4. You tried to paste copied cells using Ctrl + P in Google Sheets, but it didn't work. What is the correct shortcut to paste?

medium

A. Ctrl + X

B. Ctrl + P

C. Ctrl + V

D. Ctrl + C

Solution

1. Step 1: Identify the paste shortcut

   Paste inserts copied content into the selected cells.

2. Step 2: Correct the wrong shortcut

   Ctrl + V (Command + V on Mac) is the correct paste shortcut, not Ctrl + P.

3. Final Answer:

   Ctrl + V -> Option C

4. Quick Check:

   Paste = Ctrl + V [OK]

Hint: Paste is Ctrl + V, not Ctrl + P [OK]

Common Mistakes:

• Using Ctrl + P which is print
• Confusing paste with copy or cut
• Trying Ctrl + X which cuts instead of pastes

5. You want to quickly insert a new row above the current row in Google Sheets without using the mouse. Which keyboard shortcut should you use?

hard

A. Ctrl + Alt + Down Arrow

B. Ctrl + Shift + Plus (+)

C. Ctrl + Shift + Minus (-)

D. Ctrl + Enter

Solution

1. Step 1: Understand inserting rows shortcut

   Ctrl + Shift + Plus (+) inserts a new row or column depending on selection.

2. Step 2: Confirm the correct shortcut for new row

   Using Ctrl + Shift + Plus (+) with a selected row inserts a new row above.

3. Final Answer:

   Ctrl + Shift + Plus (+) -> Option B

4. Quick Check:

   Insert row = Ctrl + Shift + + [OK]

Hint: Insert row with Ctrl + Shift + + (plus) [OK]

Common Mistakes:

• Using Ctrl + Shift + Minus which deletes rows
• Trying Ctrl + Enter which edits cell
• Confusing with arrow key shortcuts