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 + )