Microsoft Excel Shortcuts

Function keys 
F1Undo
F2
Cut text from the active cell
Shift+F2Edit a cell comment
F3Copy text from the active cell
Shift+F3Open the Formula Builder
F4Paste text into the active cell
Shift+F4Repeat the last Find (Find Next)
⌘+F4Close the window
F5Display the Go To dialog box
Shift+F5Display the Find dialog box
⌘+F5Restore the window size.*
F6Move to the next pane in a workbook that has been split
Shift+F6Move to the previous pane in a workbook that has been split
⌘+F6Move to the next workbook window
⌘+Shift+F6Move to the previous workbook window
F7Check spelling
F8Turn on extend selection mode; used with arrow keys or cursor
Shift+F8Add to the selection
Option+F8Display the Macro dialog box
F9Calculate all sheets in all open workbooks.
Shift+F9Calculate the active sheet.
Shift+F10Display a contextual menu.
⌘+F10Maximize or restore the workbook window
Option+F10Make the first button on a floating toolbar active
F11Insert a new chart sheet.
Shift+F11Insert a new sheet.
⌘+F11Insert an Excel 4.0 macro sheet
F12Display the Save As dialog box.
⌘+F12Display the Open dialog box
Ctrl+Shift+F12Display the Print dialog box

 

Moving and scrolling in a sheet or workbook 
Arrow KeysMove one cell up, down, left, or right
Ctrl+Arrow KeyMove to the edge of the current data region
HomeMove to the beginning of the row
Ctrl+Home./Ctrl+EndMove to the beginning / to the end of the sheet
Page Down/Page UpMove down one screen / up one screen
Option+Page Down/ Option+Page UpMove one screen to the right / to the left
Ctrl+Page Down/ Ctrl+Page UpMove to the next sheet / to the previous sheet in the workbook
Ctrl+Tab/ Ctrl+Shift+TabMove to the next workbook / move to the previous workbook or window
F6/Shift+F6Move to the next pane / move to the previous pane in a workbook that has been split
Ctrl+DeleteScroll to display the active cell
Ctrl+gDisplay the Go To dialog box
⌘+fDisplay the Find dialog box
⌘+gRepeat the last Find action (same as Find Next)
TabMove between unlocked cells on a protected sheet

 

 Entering data on a sheet 
ReturnComplete a cell entry and move forward in the selection
Ctrl+Option+ReturnStart a new line in the same cell
Ctrl+ReturnFill the selected cell range with the text that you type
Shift+ReturnComplete a cell entry and move back in the selection
TabComplete a cell entry and move to the right in the selection
Shift+TabComplete a cell entry and move to the left in the selection
EscCancel a cell entry
DeleteDelete the character to the left of the insertion point, or delete the selection
Delete ⌦Delete the character to the right of the insertion point, or delete the selection
Ctrl+Delete ⌦Delete text to the end of the line
Arrow KeysMove one character up, down, left, or right
HomeMove to the beginning of the line
⌘+yRepeat the last action
Shift+F2Edit a cell comment
Ctrl+dFill down
Ctrl+rFill to the right
Ctrl+lDefine a name

 

Formatting and editing data 
⌘+Shift+lDisplay the Style dialog box
⌘+1Display the Format Cells dialog box
Ctrl+Shift+~Apply the general number format
Ctrl+Shift+$Apply the currency format with two decimal places (negative numbers appear in red with parentheses)
Ctrl+Shift+%Apply the percentage format with no decimal places
Ctrl+Shift+^Apply the exponential number format with two decimal places
Ctrl+Shift+#Apply the date format with the day, month, and year
Ctrl+Shift+@Apply the time format with the hour and minute, and indicate A.M. or P.M.
Ctrl+Shift+!Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values
⌘+Option+0 (zero)Apply the outline border around the selected cells
⌘+Option+Arrow RightAdd an outline border to the right of the selection
⌘+Option+Arrow LeftAdd an outline border to the left of the selection
⌘+Option+Arrow UpAdd an outline border to the top of the selection
⌘+Option+Arrow DownAdd an outline border to the bottom of the selection
⌘+Option+-Remove outline borders
⌘+bApply or remove bold formatting
⌘+iApply or remove italic formatting
⌘+uApply or remove underscoring
⌘+Shift+xApply or remove strikethrough formatting
Ctrl+9Hide rows
Ctrl+Shift+(Unhide rows
Ctrl+0 (zero)Hide columns
Ctrl+Shift+)Unhide columns
⌘+Shift+wAdd or remove the shadow font style
⌘+Shift+dAdd or remove the outline font style
Ctrl+uEdit the active cell
EscCancel an entry in the cell or the formula bar
DeleteEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
⌘+vPaste text into the active cell

 

Working with a selection 
⌘+cCopy the selection
⌘+xCut the selection
⌘+vPaste the selection
⌘+Ctrl+vPaste special
DeleteClear the contents of the selection
Ctrl+-Delete the selection

 

Outlining data 
Ctrl+8Display or hide outline symbols
Ctrl+9Hide selected rows
Ctrl+Shift+(Unhide selected rows
Ctrl+0 (zero)Hide selected columns
Ctrl+Shift+)Unhide selected columns
ae-sliders4-26