Microsoft Excel for macOS Keyboard Shortcuts Quick Reference Guide

Subject:	Excel
Versions:	macOS
Shortcuts:	205
Pages:	2
Dimensions:	8.5 x 11″
Availability:	Printed & Laminated or PDF Download
Price:	$4.95     Quantity Discounts Available
ISBN:	978-1-958446-47-8

Designed with the busy professional in mind, this 2-page quick reference guide provides 205 keyboard shortcuts for Microsoft Excel for macOS.  When you need to find a shortcut, you will find it right at your fingertips with this Excel Keyboard Shortcuts Quick Reference Guide. Clear and easy-to-use, quick reference cards are perfect for individuals, businesses and as supplemental training materials.

Shortcuts Included:

Common
Add or remove a filter
Apply bold formatting
Apply italic formatting
Apply underline formatting
Calculate all open workbooks
Check spelling
Clear selection
Close dialog box
Close window
Copy selection
Create a new workbook from template
Cut selection
Delete cells
Display the Format Cells dialog box
Display the Formula Builder
Display the Go To dialog box
Display the contextual Help window
Display the Open dialog box
Display the Replace dialog box
Display the Save As dialog box
Fill cells down
Fill cells right
Insert a new sheet
Insert cells
Minimize or maximize the ribbon tabs
Open a new blank workbook
Open Help
Open the thesaurus after selecting word
Open the Create names dialog box
Open Visual Basic
Paste selection
Paste Special
Print workbook
Quit Excel
Redo action
Save workbook
Select all
State a formula
Undo action

Entering Data
Cancel cell entry
Complete cell entry and move down
Complete cell entry and move left
Complete cell entry and move right
Complete cell entry and move up
Define a name
Delete text to the end of the line
Delete character to left or selection
Delete charter to right or selection
Edit the selected cell
Fill down
Fill selected range with text you type
Fill to the right
Flash Fill
Insert a note
Insert a threaded comment
Move one character
Move to the beginning of the line
Open and edit a cell note
Open and reply to a threaded comment
Start a new line in the same cell

Formatting and Editing Data
Add border around selection
Add border to bottom of selection
Add border to left of selection
Add border to right of selection
Add border to top of selection
Align center
Align left
Apply or remove bold formatting
Apply or remove italic formatting
Apply or remove strikethrough formatting
Apply or remove underline formatting
Apply the currency format
Apply the date format
Apply the exponential number format
Apply the general number format
Apply the number format
Apply the percentage format
Apply the time format
Cancel an entry in the cell of the formula bar
Clear selected cell content, keep formatting
Complete a cell entry
Copy formatting only from selection
Create a table
Decrease font size
Display the Format Cells dialog box
Display the Formula Bulder for current function
Display the Modify Cell Style dialog box
Edit the selected cell
Give selected cells current cell’s entry
Hide a column
Hide a row
Increase font size
Insert a line break in a cell
Insert special characters
Paste Special
Paste text into the active cell
Remove outline borders
Unhide a column
Unhide a row

Formula Bar or Cells
Alternate displaying cell values and formulas
Calculate all open workbook worksheets
Calculate the active sheet
Cancel an entry in the cell or formula bar
Check dependent formulas
Copy a formula from the cell above
Copy value from cell above active cell
Define a name
Display the context menu
Display the AutoComplete list
Display Formula Builder for current function
Edit the selected cell
Enter the date
Enter the time
Expand or collapse the formula bar
Insert a hyperlink
Insert the AutoSum formula
Open the Formula Builder
Start a formula
Toggle absolute/relative formula references

Moving and Scrolling
Access Search from a selected cell
Display the Find & Replace dialog box
Display the Go To dialog box
Move between unlocked cells (protected sheet)
Move down one screen
Move one cell (scroll lock must be off)
Move one screen to the left
Move one screen to the right
Move to beginning of the row
Move to beginning of the sheet
Move to edge of data region
Move to last cell in use on the sheet
Move to next sheet in the workbook
Move to previous sheet in the workbook
Move to Search
Move up one screen
Scroll horizontally
Scroll to display the active cell
Switch focus between UI elements

Moving Using Arrow Keys
Moving Using Arrow Keys

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

Pivot Tables
Insert pivot chart on same sheet
Open cell data validation dropdown list
Open the Sort dialog box

Selecting
All cells referred to by selected formula
Alternate hiding and displaying objects
Cells only directly referred to by formula
Cells in a row that don’t match active cell value
Formula cells that only directly refer to active cell
Formula cells that refer to the active cell
Only the active cell if multiple cells selected
Only visible cells within the selection
The current region (cursor must be in region)
The entire column
The entire row
The entire sheet (place cursor outside region)

Selecting: Adding To and Extending Selections
Add to the selection
Extend by one cell
Extend down one screen
Extend beginning of the row
Extend to beginning of the sheet
Extend to last used cell on sheet
Extend to last nonblank cell
Extend selection up one screen
Turn on capability to extend using arrow keys

Selecting: Working With Selections
Clear a selection
Copy a selection
Cut a selection
Delete the selection
Group selected cells
Hide a column
Hide a row
Move clockwise to next corner of selection
Move down within a single selected column
Move from bottom to top in selection
Move from top to bottom in selection
Move left to right within selected rows/columns
Move right to left within selected rows/columns
Move up within a single selected column
Paste selection
Paste Special
Undo the last action
Ungroup selected cells
Unhide a column
Unhide a row

Windows and Dialog Boxes
Cancel command and close dialob box/menu
Close the active workbook window
Display the Macro dialog box
Exit a dialog box or cancel an action
Expand or minimize the ribbon
Hide Excel
Maximize or restore the active window
Minimize the active window
Move to the next box option/control/command
Move to previous box option/control/command
Perform action assigned to default button
Switch to full screen view
Switch to the next application
Switch to the previous application
Take screenshot (Entire screen)
Take screenshot (Selected area)
Take screenshot (Window)