Shortcuts Playground

Keep your go-to actionsright at hand

Mac keyboard shortcuts for everyday apps. Search in English or Chinese. Add actions to Invoke.

Google Sheets

Google's online spreadsheet editor for calculations and team collaboration.

Get the appOpen

Common

Select column
Select row
Select all
Find and replace
Fill range
Fill down
Fill right
Print
Paste
Paste values only
Show common keyboard shortcuts
Insert new sheet
Compact controls
Toggle input tools
Select input tools
⌘⇧⌥K
Add to Invoke
Tool finder
Select current region around selected cell
Displays or hides the menus
Convert range to table

Format cells

Underline
Italic
Strikethrough
Center align
Left align
Right align
Apply top border
Apply right border
Apply bottom border
Apply left border
Remove borders
Apply outer border
Insert link
Insert time
Insert date
Insert date and time
⌘⇧⌥;
Add to Invoke
Format as decimal
Format as time
Format as date
Format as currency
Format as percentage
Format as exponent
Clear formatting

Spreadsheet navigation

Move to beginning of row
Move to beginning of sheet
Move to end of row
Move to end of sheet
Scroll to active cell
⌘Delete
Add to Invoke
Move to next sheet
Move to previous sheet
Display list of sheets
Open hyperlink
Open Explore
⌘⇧⌥I
Add to Invoke
Go to side panel
Move focus out of spreadsheet
⌘⇧⌃M
Add to Invoke
Go to quick sum
Focus popup
⌘⌃E→⌘⌃P
Add to Invoke
Open drop-down menu on filtered cell
Open revision history
⌘⇧⌥H
Add to Invoke
Close drawing editor
⌘Escape
Add to Invoke
Show "Go to range" dialog
Find and replace with Find tab selected

Notes and comments

Insert/edit note
Insert/edit comment
Open comment discussion thread
⌘⇧⌥A
Add to Invoke
Enter current comment
Move to next comment
Move to previous comment

Comment actions

Reply to current comment
Move to next comment
Move to previous comment
Resolve current comment
Exit current comment

Open menus

File menu
Edit menu
View menu
Insert menu
Format menu
Data menu
Tools menu
Open insert menu
Open delete menu
Form menu
Add-ons menu
Help menu
Accessibility menu
Sheet menu
Context menu
Table column menu

Rows and columns

Insert rows above
Insert rows below
⌥⌃I→R→B
Add to Invoke
Insert columns to the left
Insert columns to the right
⌥⌃I→C→O
Add to Invoke
Delete rows
Delete columns
Hide row
Unhide row
Hide column
Unhide column
Group rows or columns
⇧⌥→
Add to Invoke
Ungroup rows or columns
⇧⌥←
Add to Invoke
Expand grouped rows or columns
⇧⌥↓
Add to Invoke
Collapse grouped rows or columns
⇧⌥↑
Add to Invoke

Formulas

Show all formulas
Insert array formula
⌘⇧Enter
Add to Invoke
Collapse an expanded array formula
Show or hide formula help
Full or compact formula help
Absolute or relative references
Toggle formula preview
Resize formula bar (move up or down)
⌥⌃↑/⌥⌃↓
Add to Invoke
Toggle formula range

Screen reader help

Turn on screen reader support
Enable braille support
Read column
⌘⇧⌥C
Add to Invoke
Read row
⌘⇧⌥R
Add to Invoke