Microsoft Excel shortcuts for Mac

Hover a shortcut to add it to Pie Menu

Frequently used shortcuts

Paste⌘ (command) + v Add →
Copy⌘ (command) + c Add →
Clear⌫ Add →
Save⌘ (command) + s Add →
Undo⌘ (command) + z Add →
Redo⌘ (command) + y Add →
Cut⌘ (command) + x Add →
Bold⌘ (command) + b Add →
Print⌘ (command) + p Add →
Open Visual Basic⌥ + f11 Add →
Fill Down⌘ (command) + d Add →
Fill Right⌘ (command) + r Add →
Insert cells⌃ (control) + ⇧ (shift) + = Add →
Delete cells⌘ (command) + - Add →
Calculate all open workbooks⌘ (command) + = Add →
Close window⌘ (command) + w Add →
Quit Excel⌘ (command) + q Add →
Display the Go To dialog box⌃ (control) + g Add →
Display the Format Cells dialog box⌘ (command) + 1 Add →
Display the Replace dialog box⌃ (control) + ⇧ (shift) + h Add →
Paste Special⌘ (command) + ⌃ (control) + v Add →
Underline⌘ (command) + u Add →
Italic⌘ (command) + i Add →
New blank workbook⌘ (command) + n Add →
New workbook from template⌘ (command) + ⇧ (shift) + p Add →
Display the Save As dialog box⌘ (command) + ⇧ (shift) + s Add →
Display the Help windowf1 Add →
Select All⌘ (command) + a Add →
Display the Open dialog box⌘ (command) + o Add →
Check spellingf7 Add →
Open the thesaurus⇧ (shift) + f7 Add →
Display the Formula Builder⇧ (shift) + f3 Add →
Open the Define Name dialog box⌘ (command) + f3 Add →
Open the Create names dialog box⌘ (command) + ⇧ (shift) + f3 Add →
Insert a new sheet *⇧ (shift) + f11 Add →
Print⌘ (command) + p Add →

Work in windows and dialogs

Expand or minimize the ribbon⌘ (command) + ⌥ + r Add →
Switch to full screen view⌘ (command) + ⌃ (control) + f Add →
Switch to the next application⌘ (command) + ⇥ Add →
Switch to the previous application⌘ (command) + ⇧ (shift) + ⇥ Add →
Close the active workbook window⌘ (command) + w Add →
Copy the image of the screen and save it to a Screen Shot file on your desktop.⌘ (command) + ⇧ (shift) + 3 Add →
Minimize the active window⌃ (control) + f9 Add →
Maximize or restore the active window⌘ (command) + f10 Add →
Hide Excel.⌘ (command) + h Add →
Move to the next box, ⌥, control, or command⇥ Add →
Move to the previous box, ⌥, control, or command⇧ (shift) + ⇥ Add →
Exit a dialog or cancel an actionesc Add →
Perform the action assigned to the default command button (the button with the bold outline, often the OK button)↵ Add →
Cancel the command and closeesc Add →

Move and scroll in a sheet or workbook

Move one cell up, down, left, or right↓↑→←
Move to the edge of the current data region⌘ ↓↑→←
Move to the beginning of the rowhome Add →
Move to the beginning of the sheet⌃ (control) + home Add →
Move to the last cell in use on the sheet⌃ (control) + end Add →
Move down one screenpage down Add →
Move up one screenpage up Add →
Move one screen to the right⌥ + page down Add →
Move one screen to the left⌥ + page up Add →
Scroll to display the active cell⌃ (control) + ⌫ Add →
Display the Go To dialog box⌃ (control) + g Add →
Search⌘ (command) + f Add →
Move between unlocked cells on a protected sheet⇥ Add →
Move to next workbook⌘ (command) + ` Add →

Enter data on a sheet

Edit the selected cellf2 Add →
Complete a cell entry and move forward in the selection↵ Add →
Start a new line in the same cell⌃ (control) + ⌥ + ↵ Add →
Fill the selected cell range with the text that you type⌘ (command) + return Add →
Complete a cell entry and move up in the selection⇧ (shift) + ↵ Add →
Complete a cell entry and move to the right in the selection⇥ Add →
Complete a cell entry and move to the left in the selection⇧ (shift) + ⇥ Add →
Cancel a cell entryesc Add →
Delete the character to the left of the insertion point, or delete the selection⌫ Add →
Move to the beginning of the linehome Add →
Insert a comment⇧ (shift) + f2 Add →
Open and edit a cell comment⇧ (shift) + f2 Add →
Fill down⌘ (command) + d Add →
Fill to the right⌘ (command) + r Add →
Define a name⌃ (control) + l Add →

Work in cells or the Formula bar

Edit the selected cellf2 Add →
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents⌫ Add →
Complete a cell entry↵ Add →
Cancel an entry in the cell or formula baresc Add →
Display the Formula Builder after you type a valid function name in a formula⌃ (control) + a Add →
Insert a hyperlink⌘ (command) + k Add →
Edit the active cell and position the insertion point at the end of the line⌃ (control) + u Add →
Open the Formula Builder⇧ (shift) + f3 Add →
Calculate the active sheet⇧ (shift) + f9 Add →
Display a contextual menu⇧ (shift) + f10 Add →
Start a formula= Add →
Toggle the formula reference style between absolute, relative, and mixed⌘ (command) + t Add →
Insert the AutoSum formula⌘ (command) + ⇧ (shift) + t Add →
Enter the date⌃ (control) + ; Add →
Enter the time⌘ (command) + ; Add →
Copy the value from the cell above the active cell into the cell or the formula bar⌃ (control) + ⇧ (shift) + \ Add →
Alternate between displaying cell values and displaying cell formulas⌃ (control) + ` Add →
Copy a formula from the cell above the active cell into the cell or the formula bar⌃ (control) + ' Add →
Display the AutoComplete list⌃ (control) + ⌥ + ↓ Add →
Define a name⌃ (control) + l Add →
Open the Smart Lookup pane⌃ (control) + ⌥ + ⌘ (command) + l Add →

Format and edit data

Edit the selected cellf2 Add →
Create a table⌘ (command) + t Add →
Insert a line break in a cell⌘ (command) + ⌥ + return Add →
Increase font size⌘ (command) + ⇧ (shift) + > Add →
Decrease font size⌘ (command) + ⇧ (shift) + < Add →
Align center⌘ (command) + e Add →
Align left⌘ (command) + l Add →
Display the Format Cells dialog box⌘ (command) + 1 Add →
Apply the general number format⌃ (control) + ⇧ (shift) + ~ Add →
Apply the currency format with two decimal places (negative numbers appear in red with parentheses)⌃ (control) + ⇧ (shift) + $ Add →
Apply the percentage format with no decimal places⌃ (control) + ⇧ (shift) + % Add →
Apply the exponential number format with two decimal places⌃ (control) + ⇧ (shift) + ^ Add →
Apply the date format with the day, month, and year⌃ (control) + ⇧ (shift) + # Add →
Apply the time format with the hour and minute, and indicate AM or PM⌃ (control) + ⇧ (shift) + @ Add →
Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values⌃ (control) + ⇧ (shift) + ! Add →
Apply the outline border around the selected cells⌘ (command) + ⌥ + 0 Add →
Add an outline border to the right of the selection⌘ (command) + ⌥ + → Add →
Add an outline border to the left of the selection⌘ (command) + ⌥ + ← Add →
Add an outline border to the top of the selection⌘ (command) + ⌥ + ↑ Add →
Add an outline border to the bottom of the selection⌘ (command) + ⌥ + ↓ Add →
Remove outline borders⌘ (command) + ⌥ + - Add →
Apply or remove bold formatting⌘ (command) + b Add →
Apply or remove italic formatting⌘ (command) + i Add →
Apply or remove underscoring⌘ (command) + u Add →
Apply or remove strikethrough formatting⌘ (command) + ⇧ (shift) + x Add →
Hide a column⌘ (command) + ) Add →
Unhide a column⌘ (command) + ⇧ (shift) + ) Add →
Hide a row⌘ (command) + ( Add →
Unhide a row⌘ (command) + ⇧ (shift) + ( Add →
Edit the active cell⌃ (control) + u Add →
Cancel an entry in the cell or the formula baresc Add →
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents⌫ Add →
Paste text into the active cell⌘ (command) + v Add →
Complete a cell entry↵ Add →
Enter a formula as an array formula⌘ (command) + ⇧ (shift) + return Add →
Display the Formula Builder after you type a valid function name in a formula⌃ (control) + a Add →

Select cells, columns, or rows

Extend the selection by one cellshift ↓→↑←
Extend the selection to the last nonblank cell in the same column or row as the active cell⌘ shift ↓→↑←
Extend the selection to the beginning of the row⇧ (shift) + home Add →
Extend the selection to the beginning of the sheet⌃ (control) + ⇧ (shift) + home Add →
Extend the selection to the last cell used on the sheet (lower-right corner)⌃ (control) + ⇧ (shift) + end Add →
Select the entire column⌃ (control) + space Add →
Select the entire row⇧ (shift) + space Add →
Select the entire sheet⌘ (command) + a Add →
Select only visible cells⌘ (command) + ⇧ (shift) + * Add →
Select only the active cell when multiple cells are selected⇧ (shift) + ⌫ Add →
Extend the selection down one screen⇧ (shift) + page down Add →
Extend the selection up one screen⇧ (shift) + page up Add →
Alternate between hiding objects, displaying objects, and displaying placeholders for objects⌃ (control) + 6 Add →
Turn on the capability to extend a selection by using the arrow keysf8 Add →
Add another range of cells to the selection⇧ (shift) + f8 Add →
Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.⌃ (control) + \ Add →
Select only cells that are directly referred to by formulas in the selection⌃ (control) + ⇧ (shift) + [ Add →
Select all cells that are directly or indirectly referred to by formulas in the selection⌃ (control) + ⇧ (shift) + { Add →
Select only cells with formulas that refer directly to the active cell⌃ (control) + ] Add →
Select all cells with formulas that refer directly or indirectly to the active cell⌃ (control) + ⇧ (shift) + } Add →

Work with a selection

Copy⌘ (command) + c Add →
Paste⌘ (command) + v Add →
Cut⌘ (command) + x Add →
Clear⌫ Add →
Delete the selection⌃ (control) + - Add →
Undo the last action⌘ (command) + z Add →
Hide a column⌘ (command) + ) Add →
Unhide a column⌘ (command) + ⇧ (shift) + ) Add →
Hide a row⌘ (command) + ( Add →
Unhide a row⌘ (command) + ⇧ (shift) + ( Add →
Move from top to bottom within the selection (down)*↵ Add →
Move from bottom to top within the selection (up)*⇧ (shift) + ↵ Add →
Move from left to right within the selection, or move down one cell if only one column is selected⇥ Add →
Move from right to left within the selection, or move down one cell if only one column is selected⇧ (shift) + ⇥ Add →
Move clockwise to the next corner of the selection⌃ (control) + . Add →
Group selected cells⌘ (command) + ⇧ (shift) + k Add →
Ungroup selected cells⌘ (command) + ⇧ (shift) + j Add →

Use charts

Insert a new chart sheet.f11 Add →

Sort, filter, and use PivotTable reports

Open the Sort dialog box⌘ (command) + ⇧ (shift) + r Add →
Add or remove a filter⌘ (command) + ⇧ (shift) + f Add →
Display the Filter list or PivotTable page field pop-up menu for the selected cell⌥ + ↓ Add →