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.