Microsoft Excel 2011 (MacOS)

Formatting and editing data

Unhide columns

`Ctrl` + `Shift` + `)`

All hotkeys for Microsoft Excel 2011 (MacOS)

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

Similar combinations for other applications

Microsoft Excel 2007 (Windows)

Unhides any hidden columns within the selection.

CTRL Combinations in Excel 2007

`Ctrl` + `Shift` + `)`

Microsoft Excel 2011 (MacOS)

Formatting and editing data

Unhide columns

Ctrl + Shift + )

All hotkeys for Microsoft Excel 2011 (MacOS)

Function keys

Undo

F1

Function keys

Cut text from the active cell

F2

Function keys

Edit a cell comment

Shift + F2

Function keys

Copy text from the active cell

F3

Function keys

Open the Formula Builder

Shift + F3

Function keys

Paste text into the active cell

F4

Function keys

Repeat the last Find (Find Next)

Shift + F4

Function keys

Close the window

⌘ + F4

Function keys

Display the Go To dialog box

F5

Function keys

Display the Find dialog box

Shift + F5

Function keys

Restore the window size.*

⌘ + F5

Function keys

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

F6

Function keys

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

Shift + F6

Function keys

Move to the next workbook window

⌘ + F6

Function keys

Move to the previous workbook window

⌘ + Shift + F6

Function keys

Check spelling

F7

Function keys

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

F8

Function keys

Add to the selection

Shift + F8

Function keys

Display the Macro dialog box

Option + F8

Function keys

Calculate all sheets in all open workbooks.

F9

Function keys

Calculate the active sheet.

Shift + F9

Function keys

Display a contextual menu.

Shift + F10

Function keys

Maximize or restore the workbook window

⌘ + F10

Function keys

Make the first button on a floating toolbar active

Option + F10

Function keys

Insert a new chart sheet.

F11

`Ctrl` + `Shift` + `)`

`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`