Excel Shortcuts

Excel Keyboard Shortcuts

Shortcut Keys to Display and Use Windows
Press Keys	To Do
Alt+Tab	Switch to the next program.
Alt+Shift+Tab	Switch to the previous program.
Ctrl+ESC	Display the Windows Start menu.
Ctrl+W or Ctrl+F4	Close the selected workbook window.
Ctrl+F5	Restore the window size of the selected workbook window.
F6	Switch to the next pane in a worksheet that has been split (Window menu, Split command).
Shift+F6	Switch to the previous pane in a worksheet that has been split.
Ctrl+F6	When more than one workbook window is open, switch to the next workbook window.
Ctrl+Shift+F6	Switch to the previous workbook window.
Ctrl+F7	When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC.
Ctrl+F8	When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press Enter.
Ctrl+F9	Minimize a workbook window to an icon.
Ctrl+F10	Maximize or restore the selected workbook window.
Print Screen	Copy a picture of the screen to the Clipboard.
Alt+Print Screen	Copy a picture of the selected window to the Clipboard.

Shortcut Keys for Print and Print Preview
Press Keys	To Do
Ctrl+P or Ctrl+Shift+F12	Display the Print dialog box
Work with Worksheets
Shift+F11 or Alt+Shift+F1	Insert a new worksheet.
Ctrl+Page Down	Move to the next sheet in the workbook.
Ctrl+Page Up	Move to the previous sheet in the workbook.
Shift+Ctrl+Page Down	Select the current and next sheet. To cancel selection of multiple sheets, press Ctrl+Page Down or, to select a different sheet, press Ctrl+Page Up.
Shift+Ctrl+Page Up	Select the current and previous sheet.
Alt+O, H, R	Rename the current sheet (Format menu, Sheet submenu, Rename command).
Alt+E, M	Move or copy the current sheet (Edit menu, Move or Copy Sheet command).
Alt+E, L	Delete the current sheet (Edit menu, Delete Sheet command).

Shortcut Keys to Move and Scroll within a Worksheet
Press Keys	To Do
Arrow keys	Move one cell up, down, left, or right.
Tab	Move one cell to the right.
Shift+Tab	Move one cell to the left.
Ctrl+Arrow key	Move to the edge of the current data region (A range of cells that contains data and that is bounded by empty cells or worksheet borders).
Home	Move to the beginning of the row.
Ctrl+Home	Move to the beginning of the worksheet
Ctrl+End	Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.
Page Down	Move down one screen.
Page Up	Move up one screen.
Alt+Page Down	Move one screen to the right.
Alt+Page Up	Move one screen to the left.
F6	Switch to the next pane in a worksheet that has been split (Window menu, Split command).
Ctrl+Backspace	Scroll to display the active cell.
F5	Display the Go To dialog box.
Shift+F5	Display the Find dialog box.
Shift+F4	Repeat the last Find action (same as Find Next).
Tab	Move between unlocked cells on a protected worksheet.

Shortcut Keys to Move within a Selected Range
Press Keys	To Do
Enter	Move from top to bottom within the selected range
Shift+Enter	Move from bottom to top within the selected range
Tab	Move from left to right within the selected range. If cells in a single column are selected, move down.
Shift+Tab	Move from right to left within the selected range. If cells in a single column are selected, move up.
Ctrl+PERIOD	Move clockwise to the next corner of the selected range.
Ctrl+Alt+Right Arrow	In nonadjacent selections, switch to the next selection to the right.
Ctrl+Alt+Left Arrow	Switch to the next nonadjacent selection to the left.

Shortcut Keys for Selecting Data and Cells
Press Keys	To Do
Ctrl+Spacebar	Select the entire column.
Shift+Spacebar	Select the entire row.
Ctrl+A	Select the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region. Pressing Ctrl+A a second time selects the entire worksheet.
Shift+Backspace	With multiple cells selected, select only the active cell.
Ctrl+6	Alternate between hiding objects, displaying objects, and displaying place-holders for objects.

Shortcut Keys to Extend Selection
Press Keys	To Do
F8	Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection.
Shift+F8	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+Arrow Key	Extend the selection by one cell
Ctrl+Shift+Arrow key	Extend the selection to the last non-blank cell in the same column or row as the active cell
Shift+Home	Extend the selection to the beginning of the row.
Ctrl+Shift+Home	Extend the selection to the beginning of the worksheet.
Ctrl+Shift+End	Extend the selection to the last used cell on the worksheet (lower-right corner).
Shift+Page Down	Extend the selection down one screen.
Shift+Page Up	Extend the selection up one screen.
End+Shift+Arrow key	Extend the selection to the last non-blank cell in the same column or row as the active cell.
End+Shift+Home	Extend the selection to the last used cell on the worksheet (lower-right corner).

Shortcut Keys to Entering Data in Cells
Press Keys	To Do
Enter	Complete a cell entry and select the cell below.
Alt+Enter	Start a new line in the same cell.
Ctrl+Enter	Fill the selected cell range with the current entry.
Shift+Enter	Complete a cell entry and select the previous cell above.
Tab	Complete a cell entry and select the next cell to the right.
Shift+Tab	Complete a cell entry and select the previous cell to the left.
ESC	Cancel a cell entry.
Arrow keys	Move one character up, down, left, or right.
Home	Move to the beginning of the line.
F4 or Ctrl+Y	Repeat the last action.
Ctrl+Shift+F3	Create names (A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) from row and column labels.
Ctrl+D	Fill down.
Ctrl+R	Fill to the right.
Ctrl+F3	Define a name.
Ctrl+K	Insert a hyperlink.
Ctrl+Shift+: (colon)	Enter the time.
Alt+Down Arrow	Display a drop-down list of the values in the current column of a range.
Ctrl+Z	Undo the last action.

Shortcut Keys to Enter and Calculate Formulas
Press Keys	To Do
= (equal sign)	Start a formula.
F2	Move the insertion point into the Formula Bar when editing in a cell is turned off.
Backspace	In the Formula Bar, Delete one character to the left.
ESC	Cancel an entry in the cell or Formula Bar.
Shift+F3	In a formula, display the Insert Function dialog box.
Ctrl+A	When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
Alt+= (equal sign)	Insert an AutoSum formula with the SUM function.
Ctrl+Shift+" (quotation mark)	Copy the value from the cell above the active cell into the cell or the Formula Bar.
Ctrl+' (apostrophe)	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
Ctrl+` (single left quotation mark)	Alternate between displaying cell values and displaying formulas.
F9	Calculate all worksheets in all open workbooks.

Shortcut Keys to Edit Data
Press Keys	To Do
F2	Edit the active cell and position the insertion point at the end of the cell contents.
Alt+Enter	Start a new line in the same cell.
Backspace	Edit the active cell and then clear it, or Delete the preceding character in the active cell as you edit cell contents.
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.
F7	Display the Spelling dialog box.
Shift+F2	Edit a cell comment
Enter	Complete a cell entry and select the next cell below.
Ctrl+Z	Undo the last action.
ESC	Cancel a cell entry.
Ctrl+Shift+Z	When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.

Shortcut Keys to Insert, Delete or Copy Cells
Press Keys	To Do
Ctrl+C	Copy the selected cells.
Ctrl+C, immediately followed by another Ctrl+C	Display the Microsoft Office Clipboard (multiple copy and paste).
Ctrl+X	Cut the selected cells.
Ctrl+V	Paste copied or cut cells
Delete	Clear the contents of the selected cells.
Ctrl+Hyphen	Delete the selected cells.
Ctrl+Shift+Plus Sign	Insert blank cells.

Shortcut Keys to Format Data
Press Keys	To Do
Alt+' (apostrophe)	Display the Style dialog box.
Ctrl+1	Display the Format Cells dialog box.
Ctrl+Shift+~	Apply the General number format.
Ctrl+Shift+$	Apply the Currency format with two decimal places (negative numbers in 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 AM or PM.
Ctrl+Shift+!	Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Ctrl+B	Apply or remove bold formatting.
Ctrl+I	Apply or remove italic formatting.
Ctrl+U	Apply or remove underlining.
Ctrl+5	Apply or remove strikethrough.
Ctrl+9	Hide the selected rows.
Ctrl+Shift+( (opening parenthesis)	Unhide any hidden rows within the selection.
Ctrl+0 (zero)	Hide the selected columns.
Ctrl+Shift+) (closing parenthesis)	Unhide any hidden columns within the selection.
Ctrl+Shift+&	Apply the outline border to the selected cells.
Ctrl+Shift+_	Remove the outline border from the selected cells.