Shortcuts Playground

Keep your go-to actionsright at hand

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

Microsoft Excel

Organize data, calculate with formulas, analyze results, and build charts.

Get the appOpen

Common

Print
Open Visual Basic
Fill Down
Fill Right
Insert cells
Delete cells
Calculate all open workbooks
Close window
Quit Excel
Display the Replace dialog box
Paste Special
Underline
Italic
New blank workbook
New workbook from template
Display the Save As dialog box
Display the Help window
Select All
Display the Open dialog box
Check spelling
Open the thesaurus
Display the Formula Builder
Open the Define Name dialog box
Open the Create names dialog box
Insert a new sheet *

Work in windows and dialogs

Expand or minimize the ribbon
Switch to full screen view
Switch to the next application
Switch to the previous application
⌘⇧⇥
Add to Invoke
Close the active workbook window
Screenshot
Minimize the active window
Maximize or restore the active window
Hide Excel.
Move to the next box, ⌥, control, or command
Move to the previous box, ⌥, control, or command
Exit a dialog or cancel an action
Default button
Cancel the command and close

Sheet movement

Move to the beginning of the row
Move to the beginning of the sheet
Move to the last cell in use on the sheet
Move down one screen
Page Down
Add to Invoke
Move up one screen
Move one screen to the right
⌥Page Down
Add to Invoke
Move one screen to the left
⌥Page Up
Add to Invoke
Scroll to display the active cell
Display the Go To dialog box
Search
Move between unlocked cells on a protected sheet
Move to next workbook

Enter data on a sheet

Edit the selected cell
Confirm and move forward
Start a new line in the same cell
⌥⌃↩
Add to Invoke
Fill cells with typed text
Complete a cell entry and move up in the selection
Confirm and move right
Confirm and move left
Cancel a cell entry
Delete backward
Move to the beginning of the line
Insert a comment
Open and edit a cell comment
Fill down
Fill to the right
Define a name

Work in cells or the Formula bar

Edit the selected cell
Clear active cell
Complete a cell entry
Cancel an entry in the cell or formula bar
Function arguments
Insert a hyperlink
Edit cell
Open the Formula Builder
Calculate the active sheet
Display a contextual menu
Start a formula
Toggle reference style
Insert the AutoSum formula
Enter the date
Enter the time
Copy value from above
Toggle values and formulas
Copy formula from above
Display the AutoComplete list
⌥⌃↓
Add to Invoke
Define a name
Open the Smart Lookup pane
⌘⌥⌃L
Add to Invoke

Format and edit data

Edit the selected cell
Create a table
Insert a line break in a cell
⌘⌥↩
Add to Invoke
Increase font size
Decrease font size
Align center
Align left
Display the Format Cells dialog box
Apply the general number format
Currency format
Apply the percentage format with no decimal places
Scientific format
Apply the date format with the day, month, and year
Time format
Number format
Apply the outline border around the selected cells
Add an outline border to the right of the selection
⌘⌥→
Add to Invoke
Add an outline border to the left of the selection
⌘⌥←
Add to Invoke
Add an outline border to the top of the selection
⌘⌥↑
Add to Invoke
Add an outline border to the bottom of the selection
⌘⌥↓
Add to Invoke
Remove outline borders
Apply or remove bold formatting
Apply or remove italic formatting
Apply or remove underscoring
Apply or remove strikethrough formatting
Hide a column
Unhide a column
Hide a row
Unhide a row
Edit the active cell
Cancel an entry in the cell or the formula bar
Clear active cell
Paste text into the active cell
Complete a cell entry
Enter a formula as an array formula
⌘⇧↩
Add to Invoke
Function arguments

Work with a selection

Paste
Delete the selection
Undo the last action
Hide a column
Unhide a column
Hide a row
Unhide a row
Move from top to bottom within the selection (down)*
Move from bottom to top within the selection (up)*
Next cell in selection
Previous cell in selection
Move clockwise to the next corner of the selection
Group selected cells
Ungroup selected cells

Use charts

Insert a new chart sheet.

Outline data

Display or hide outline symbols
Hide selected rows
Unhide selected rows
Hide selected columns
Unhide selected columns

Function keys

Display the Help window
Insert or edit a cell comment
Open the Save dialog
Open the Define Name dialog
Close
Display the Go To dialog
Display the Find dialog
Move to the Search Sheet dialog
Extend the selection
Add to the selection
Display the Macro dialog
Calculate all open workbooks
Display a contextual menu, or "right click" menu
Maximize or restore the active window
Insert a new chart sheet*
Insert a new sheet*
Insert an Excel 4.0 macro sheet
Display the Save As dialog
Display the Open dialog