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
|