Hotkeys and shortcuts for Microsoft Excel 2011 (MacOS)

(Total 196)

`F1`	Function keys Undo
`F2`	Function keys Cut text from the active cell
`Shift` + `F2`	Function keys Edit a cell comment
`F3`	Function keys Copy text from the active cell
`Shift` + `F3`	Function keys Open the Formula Builder
`F4`	Function keys Paste text into the active cell
`Shift` + `F4`	Function keys Repeat the last Find (Find Next)
`⌘` + `F4`	Function keys Close the window
`F5`	Function keys Display the Go To dialog box
`Shift` + `F5`	Function keys Display the Find dialog box
`⌘` + `F5`	Function keys Restore the window size.*
`F6`	Function keys Move to the next pane in a workbook that has been split
`Shift` + `F6`	Function keys Move to the previous pane in a workbook that has been split
`⌘` + `F6`	Function keys Move to the next workbook window
`⌘` + `Shift` + `F6`	Function keys Move to the previous workbook window
`F7`	Function keys Check spelling
`F8`	Function keys Turn on extend selection mode; used with arrow keys or cursor
`Shift` + `F8`	Function keys Add to the selection
`Option` + `F8`	Function keys Display the Macro dialog box
`F9`	Function keys Calculate all sheets in all open workbooks.
`Shift` + `F9`	Function keys Calculate the active sheet.
`Shift` + `F10`	Function keys Display a contextual menu.
`⌘` + `F10`	Function keys Maximize or restore the workbook window
`Option` + `F10`	Function keys Make the first button on a floating toolbar active
`F11`	Function keys Insert a new chart sheet.
`Shift` + `F11`	Function keys Insert a new sheet.
`⌘` + `F11`	Function keys Insert an Excel 4.0 macro sheet
`F12`	Function keys Display the Save As dialog box.
`⌘` + `F12`	Function keys Display the Open dialog box
`Ctrl` + `Shift` + `F12`	Function keys Display the Print dialog box
`Arrow Keys`	Moving and scrolling in a sheet or workbook Move one cell up, down, left, or right
`Ctrl` + `Arrow Key`	Moving and scrolling in a sheet or workbook Move to the edge of the current data region
`Home`	Moving and scrolling in a sheet or workbook Move to the beginning of the row
`Ctrl` + `Home` ./ `Ctrl` + `End`	Moving and scrolling in a sheet or workbook Move to the beginning / to the end of the sheet
`Page Down` / `Page Up`	Moving and scrolling in a sheet or workbook Move down one screen / up one screen
`Option` + `Page Down` / `Option` + `Page Up`	Moving and scrolling in a sheet or workbook Move one screen to the right / to the left
`Ctrl` + `Page Down` / `Ctrl` + `Page Up`	Moving and scrolling in a sheet or workbook Move to the next sheet / to the previous sheet in the workbook
`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`	Moving and scrolling in a sheet or workbook Move to the next workbook / move to the previous workbook or window
`F6` / `Shift` + `F6`	Moving and scrolling in a sheet or workbook Move to the next pane / move to the previous pane in a workbook that has been split
`Ctrl` + `Delete`	Moving and scrolling in a sheet or workbook Scroll to display the active cell
`Ctrl` + `g`	Moving and scrolling in a sheet or workbook Display the Go To dialog box
`⌘` + `f`	Moving and scrolling in a sheet or workbook Display the Find dialog box
`⌘` + `g`	Moving and scrolling in a sheet or workbook Repeat the last Find action (same as Find Next)
`Tab`	Moving and scrolling in a sheet or workbook Move between unlocked cells on a protected sheet
`⌘` + `p`	Previewing and printing Display the Print dialog box
`Arrow Keys`	Previewing and printing In print preview, move around the page when zoomed in
`Ctrl` + `Arrow Down`	Previewing and printing In print preview, move to the last page when zoomed out
`Return`	Entering data on a sheet Complete a cell entry and move forward in the selection
`Ctrl` + `Option` + `Return`	Entering data on a sheet Start a new line in the same cell
`Ctrl` + `Return`	Entering data on a sheet Fill the selected cell range with the text that you type
`Shift` + `Return`	Entering data on a sheet Complete a cell entry and move back in the selection
`Tab`	Entering data on a sheet Complete a cell entry and move to the right in the selection
`Shift` + `Tab`	Entering data on a sheet Complete a cell entry and move to the left in the selection
`Esc`	Entering data on a sheet Cancel a cell entry
`Delete`	Entering data on a sheet Delete the character to the left of the insertion point, or delete the selection
`Delete ⌦`	Entering data on a sheet Delete the character to the right of the insertion point, or delete the selection
`Ctrl` + `Delete ⌦`	Entering data on a sheet Delete text to the end of the line
`Arrow Keys`	Entering data on a sheet Move one character up, down, left, or right
`Home`	Entering data on a sheet Move to the beginning of the line
`⌘` + `y`	Entering data on a sheet Repeat the last action
`Shift` + `F2`	Entering data on a sheet Edit a cell comment
`Ctrl` + `d`	Entering data on a sheet Fill down
`Ctrl` + `r`	Entering data on a sheet Fill to the right
`Ctrl` + `l`	Entering data on a sheet Define a name
`Delete`	Working in cells or the Formula bar Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
`Return`	Working in cells or the Formula bar Complete a cell entry
`Ctrl` + `Shift` + `Return`	Working in cells or the Formula bar Enter a formula as an array formula
`Esc`	Working in cells or the Formula bar Cancel an entry in the cell or formula bar
`Ctrl` + `a`	Working in cells or the Formula bar Display the Formula Builder after you type a valid function name in a formula
`⌘` + `k`	Working in cells or the Formula bar Insert a hyperlink
`Ctrl` + `u`	Working in cells or the Formula bar Edit the active cell and position the insertion point at the end of the line
`Shift` + `F3`	Working in cells or the Formula bar Open the Formula Builder
`⌘` + `=`	Working in cells or the Formula bar Calculate all sheets in all open workbooks
`⌘` + `Shift` + `=`	Working in cells or the Formula bar Calculate the active sheet
`=`	Working in cells or the Formula bar Start a formula
`⌘` + `t`	Working in cells or the Formula bar Toggle the formula reference style between absolute, relative, and mixed
`⌘` + `Shift` + `t`	Working in cells or the Formula bar Insert the AutoSum formula
`Ctrl` + `;` (semicolon)	Working in cells or the Formula bar Enter the date
`⌘` + `;` (semicolon)	Working in cells or the Formula bar Enter the time
`Ctrl` + `Shift` + `"`	Working in cells or the Formula bar Copy the value from the cell above the active cell into the cell or the formula bar
`Ctrl` + ` (grave accent)	Working in cells or the Formula bar Alternate between displaying cell values and displaying cell formulas
`Ctrl` + `'` (apostrophe))	Working in cells or the Formula bar Copy a formula from the cell above the active cell into the cell or the formula bar
`Ctrl` + `Option` + `Arrow Down`	Working in cells or the Formula bar Display the AutoComplete list
`Ctrl` + `l`	Working in cells or the Formula bar Define a name
`⌘` + `Shift` + `l`	Formatting and editing data Display the Style dialog box
`⌘` + `1`	Formatting and editing data Display the Format Cells dialog box
`Ctrl` + `Shift` + `~`	Formatting and editing data Apply the general number format
`Ctrl` + `Shift` + `$`	Formatting and editing data Apply the currency format with two decimal places (negative numbers appear in red with parentheses)
`Ctrl` + `Shift` + `%`	Formatting and editing data Apply the percentage format with no decimal places
`Ctrl` + `Shift` + `^`	Formatting and editing data Apply the exponential number format with two decimal places
`Ctrl` + `Shift` + `#`	Formatting and editing data Apply the date format with the day, month, and year
`Ctrl` + `Shift` + `@`	Formatting and editing data Apply the time format with the hour and minute, and indicate A.M. or P.M.
`Ctrl` + `Shift` + `!`	Formatting and editing data Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values
`⌘` + `Option` + `0` (zero)	Formatting and editing data Apply the outline border around the selected cells
`⌘` + `Option` + `Arrow Right`	Formatting and editing data Add an outline border to the right of the selection
`⌘` + `Option` + `Arrow Left`	Formatting and editing data Add an outline border to the left of the selection
`⌘` + `Option` + `Arrow Up`	Formatting and editing data Add an outline border to the top of the selection
`⌘` + `Option` + `Arrow Down`	Formatting and editing data Add an outline border to the bottom of the selection
`⌘` + `Option` + `-`	Formatting and editing data Remove outline borders
`⌘` + `b`	Formatting and editing data Apply or remove bold formatting
`⌘` + `i`	Formatting and editing data Apply or remove italic formatting
`⌘` + `u`	Formatting and editing data Apply or remove underscoring
`⌘` + `Shift` + `x`	Formatting and editing data Apply or remove strikethrough formatting
`Ctrl` + `9`	Formatting and editing data Hide rows
`Ctrl` + `Shift` + `(`	Formatting and editing data Unhide rows
`Ctrl` + `0` (zero)	Formatting and editing data Hide columns
`Ctrl` + `Shift` + `)`	Formatting and editing data Unhide columns
`⌘` + `Shift` + `w`	Formatting and editing data Add or remove the shadow font style
`⌘` + `Shift` + `d`	Formatting and editing data Add or remove the outline font style
`Ctrl` + `u`	Formatting and editing data Edit the active cell
`Esc`	Formatting and editing data Cancel an entry in the cell or the formula bar
`Delete`	Formatting and editing data Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
`⌘` + `v`	Formatting and editing data Paste text into the active cell
`Return`	Formatting and editing data Complete a cell entry
`Ctrl` + `Shift` + `Return`	Formatting and editing data Enter a formula as an array formula
`Ctrl` + `a`	Formatting and editing data Display the Formula Builder after you type a valid function name in a formula
`⌘` + `c`	Working with a selection Copy the selection
`⌘` + `x`	Working with a selection Cut the selection
`⌘` + `v`	Working with a selection Paste the selection
`⌘` + `Ctrl` + `v`	Working with a selection Paste special
`Delete`	Working with a selection Clear the contents of the selection
`Ctrl` + `-`	Working with a selection Delete the selection
`⌘` + `Shift` + `c`	Working with a selection Copy a style
`⌘` + `Shift` + `v`	Working with a selection Paste a style
`Ctrl` + `Option` + `c`	Working with a selection Copy text or graphics to the Scrapbook
`Ctrl` + `Option` + `v`	Working with a selection Paste to the Scrapbook
`⌘` + `z`	Working with a selection Undo the last action
`Return`	Working with a selection Move from top to bottom within the selection (down), or move in the direction that is selected in Edit in thePreferences dialog box (Excel menu, Preferences command)
`Shift` + `Return`	Working with a selection Move from bottom to top within the selection (up), or move opposite to the direction that is selected in Edit in the Preferences dialog box (Excel menu, Preferences command)
`Tab`	Working with a selection Move from left to right within the selection, or move down one cell if only one column is selected
`Shift` + `Tab`	Working with a selection Move from right to left within the selection, or move up one cell if only one column is selected
`Ctrl` + `.` (Period)	Working with a selection Move clockwise to the next corner of the selection
`Ctrl` + `Option` + `Arrow Right`	Working with a selection Move to the right between nonadjacent selections
`Ctrl` + `Option` + `Arrow Left`	Working with a selection Move to the left between nonadjacent selections
`⌘` + `Ctrl` + `m`	Working with a selection Insert graphics using the Media Browser
`Shift` + `Arrow Key`	Selecting cells, columns, or rows Extend the selection by one cell
`Ctrl` + `Shift` + `Arrow Key`	Selecting cells, columns, or rows Extend the selection to the last nonblank cell in the same column or row as the active cell
`Shift` + `Home`	Selecting cells, columns, or rows Extend the selection to the beginning of the row
`Ctrl` + `Shift` + `Home`	Selecting cells, columns, or rows Extend the selection to the beginning of the sheet
`Ctrl` + `Shift` + `End`	Selecting cells, columns, or rows Extend the selection to the last cell used on the sheet (lower-right corner)
`Ctrl` + `Space`	Selecting cells, columns, or rows Select the entire column
`Shift` + `Space`	Selecting cells, columns, or rows Select the entire row
`⌘` + `a`	Selecting cells, columns, or rows Select the entire sheet
`Shift` + `Delete`	Selecting cells, columns, or rows Select only the active cell when multiple cells are selected
`Shift` + `Page Down`	Selecting cells, columns, or rows Extend the selection down one screen
`Shift` + `Page Up`	Selecting cells, columns, or rows Extend the selection up one screen
`Ctrl` + `6`	Selecting cells, columns, or rows Alternate between hiding objects, displaying objects, and displaying placeholders for objects
`Ctrl` + `7`	Selecting cells, columns, or rows Show or hide the Standard toolbar
`F8`	Selecting cells, columns, or rows Turn on the capability to extend a selection by using the arrow keys
`Shift` + `F8`	Selecting cells, columns, or rows Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range
`Ctrl` + `/`	Selecting cells, columns, or rows Select the current array, which is the array that the active cell belongs to
`Ctrl` + `\`	Selecting cells, columns, or rows 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.
`Ctrl` + `Shift` + `[`	Selecting cells, columns, or rows Select only cells that are directly referred to by formulas in the selection
`Ctrl` + `[`	Selecting cells, columns, or rows Select cells in a column that don't match the value in the active cell in that column. You must select the column starting with the active cell.
`Ctrl` + `Shift` + `{`	Selecting cells, columns, or rows Select all cells that are directly or indirectly referred to by formulas in the selection
`Ctrl` + `]`	Selecting cells, columns, or rows Select only cells with formulas that refer directly to the active cell
`Ctrl` + `Shift` + `}`	Selecting cells, columns, or rows Select all cells with formulas that refer directly or indirectly to the active cell
`⌘` + `Shift` + `z`	Selecting cells, columns, or rows Select only visible cells in the current selection
`F11`	Charts Insert a new chart sheet.*
`Arrow Key`	Charts Cycle through chart object selection
`Arrow Down` / `Arrow Up`	Data forms Move to the same field in the next record / previous record
`Tab` / `Shift` + `Tab`	Data forms Move to the next field / previous field that you can edit in the record
`Return` / `Shift` + `Return`	Data forms Move to the first field in the next record / in the previous record
`Page Down` / `Page Up`	Data forms Move to the same field 10 records forward / 10 records back
`Ctrl` + `Page Down`	Data forms Move to a new record
`Ctrl` + `Page Up`	Data forms Move to the first record
`Option` + `Arrow Down`	Filters and PivotTable reports Display the Filter list or PivotTable page field pop-up menu for the selected cell
`Ctrl` + `8`	Outlining data Display or hide outline symbols
`Ctrl` + `9`	Outlining data Hide selected rows
`Ctrl` + `Shift` + `(`	Outlining data Unhide selected rows
`Ctrl` + `0` (zero)	Outlining data Hide selected columns
`Ctrl` + `Shift` + `)`	Outlining data Unhide selected columns
`Option` + `F10`	Toolbars Make the first button on a floating toolbar active
`Tab`	Toolbars When a toolbar is active, select the next button or menu on the toolbar
`Shift` + `Tab`	Toolbars When a toolbar is active, select the previous button or menu on the toolbar
`Ctrl` + `Tab`	Toolbars When a toolbar is active, select the next toolbar
`Ctrl` + `Shift` + `Tab`	Toolbars When a toolbar is active, select the previous toolbar
`Return`	Toolbars Perform the action assigned to the selected button
`⌘` + `Option` + `1`	Windows Expand or minimize the ribbon
`⌘` + `Tab`	Windows Switch to the next application
`⌘` + `Shift` + `Tab`	Windows Switch to the previous application
`⌘` + `w`	Windows Close the active workbook window
`⌘` + `F5` *	Windows Restore the active workbook window size
`F6`	Windows Move to the next pane in a workbook that has been split
`Shift` + `F6`	Windows Move to the previous pane in a workbook that has been split
`⌘` + `F6`	Windows Switch to the next workbook window
`⌘` + `Shift` + `F6`	Windows Switch to the previous workbook window
`Ctrl` + `F10`	Windows Maximize or restore the workbook window
`⌘` + `Shift` +3*	Windows Copy the image of the screen to the Clipboard
`⌘` + `Shift` +4*	Windows Copy the image of the active window to the Clipboard (after pressing and releasing the key combination, click the window that you want to take a picture of).
`Tab`	Dialog boxes Move to the next text box
`Shift` + `Tab`	Dialog boxes Move to the previous text box
`Ctrl` + `Tab`	Dialog boxes Switch to the next tab in a dialog box
`Ctrl` + `Shift` + `Tab`	Dialog boxes Switch to the previous tab in a dialog box
`Return`	Dialog boxes Perform the action assigned to the default command button in the dialog box (the button with the bold outline, often the OK button)
`Esc`	Dialog boxes Cancel the command and close the dialog box

Hotkeys and shortcuts for Microsoft Excel 2011 (MacOS)

(Total 196)

F1

Function keys

Undo

F2

Function keys

Cut text from the active cell

Shift + F2

Function keys

Edit a cell comment

F3

Function keys

Copy text from the active cell

Shift + F3

Function keys

Open the Formula Builder

F4

Function keys

Paste text into the active cell

Shift + F4

Function keys

Repeat the last Find (Find Next)

⌘ + F4

Function keys

Close the window

F5

Function keys

Display the Go To dialog box

Shift + F5

Function keys

Display the Find dialog box

⌘ + F5

Function keys

Restore the window size.*

F6

Function keys

Move to the next pane in a workbook that has been split

Shift + F6

Function keys

Move to the previous pane in a workbook that has been split

⌘ + F6

Function keys

Move to the next workbook window

⌘ + Shift + F6

Function keys

Move to the previous workbook window

F7

Function keys

Check spelling

F8

Function keys

Turn on extend selection mode; used with arrow keys or cursor

Shift + F8

Function keys

Add to the selection

Option + F8

Function keys

Display the Macro dialog box

F9

Function keys

Calculate all sheets in all open workbooks.

Shift + F9

Function keys

Calculate the active sheet.

Shift + F10

Function keys

Display a contextual menu.

⌘ + F10

Function keys

Maximize or restore the workbook window

Option + F10

Function keys

Make the first button on a floating toolbar active

F11

Function keys

Insert a new chart sheet.

Shift + F11

Function keys

Insert a new sheet.

`F1`

`F2`

`Shift` + `F2`

`F3`

`Shift` + `F3`

`F4`

`Shift` + `F4`

`⌘` + `F4`

`F5`

`Shift` + `F5`

`⌘` + `F5`

`F6`

`Shift` + `F6`

`⌘` + `F6`

`⌘` + `Shift` + `F6`

`F7`

`F8`

`Shift` + `F8`

`Option` + `F8`

`F9`

`Shift` + `F9`

`Shift` + `F10`

`⌘` + `F10`

`Option` + `F10`

`F11`

`Shift` + `F11`

`⌘` + `F11`

`F12`

`⌘` + `F12`

`Ctrl` + `Shift` + `F12`

`Arrow Keys`

`Ctrl` + `Arrow Key`

`Home`

`Ctrl` + `Home` ./ `Ctrl` + `End`

`Page Down` / `Page Up`

`Option` + `Page Down` / `Option` + `Page Up`

`Ctrl` + `Page Down` / `Ctrl` + `Page Up`

`Ctrl` + `Tab` / `Ctrl` + `Shift` + `Tab`

`F6` / `Shift` + `F6`

`Ctrl` + `Delete`

`Ctrl` + `g`

`⌘` + `f`

`⌘` + `g`

`Tab`

`⌘` + `p`

`Arrow Keys`

`Ctrl` + `Arrow Down`

`Return`

`Ctrl` + `Option` + `Return`

`Ctrl` + `Return`