Keyboard shortcuts in Google Sheets - Dashboard Guide

Dashboard Mode - Keyboard shortcuts

Goal

Learn how to use keyboard shortcuts in Google Sheets to work faster and more efficiently.

Sample Data

Task	Shortcut	Action
Copy	Ctrl + C	Copy selected cells
Paste	Ctrl + V	Paste copied cells
Undo	Ctrl + Z	Undo last action
Redo	Ctrl + Y	Redo last undone action
Find	Ctrl + F	Open find box
Bold	Ctrl + B	Make text bold
Insert Row	Ctrl + Shift + =	Insert row above

Dashboard Components

• Shortcut Table: Shows common keyboard shortcuts with their actions.
• Search Box: A cell with formula =IF(ISNUMBER(SEARCH(E2, B2:B8)), B2:B8, "") to filter shortcuts by keyword (E2 is search input).
• KPI Card: Counts how many shortcuts match the search using =IFERROR(COUNTA(FILTER(B2:B8, ISNUMBER(SEARCH(E2, B2:B8)))), 0).

Dashboard Layout

+----------------------+------------------+
| Shortcut Table       | Search Box       |
| (B2:D8)             | (E2)             |
+----------------------+------------------+
| KPI Card: Count      |                  |
| (Below Search Box)   |                  |
+----------------------+------------------+

Interactivity

Type a keyword in the Search Box (cell E2). The Shortcut Table filters to show only shortcuts containing that keyword. The KPI Card updates to show how many shortcuts match the search.

Self Check

If you type "Copy" in the Search Box, which shortcuts appear in the table and what does the KPI Card show?

Key Result

A dashboard showing common Google Sheets keyboard shortcuts with a search filter and count of matching shortcuts.