Common Excel shortcut keys
|
|
Close workbook |
Ctrl+W |
|
Open workbook |
Ctrl+O |
|
Go to the Home tab |
Alt+H |
|
Save workbook |
Ctrl+S |
|
Copy |
Ctrl+C |
|
Paste |
Ctrl+V |
|
Undo |
Ctrl+Z |
|
Delete cell contents |
Delete key |
|
Select fill color |
Alt+H, H |
|
Cut |
Ctrl+X |
|
Go to the Insert tab |
Alt+N |
|
Bold |
Ctrl+B |
|
Center cell contents |
Alt + H, A, C |
|
Go to the Page Layout tab |
Alt+P |
|
Go to the Data tab |
Alt+A |
|
Go to the View tab |
Alt+W |
|
Open context menu |
Shift+F10 or context key |
|
Add border |
Alt+H, B |
|
Delete column |
Alt + H, D, C |
|
Go to Formulas tab |
Alt+M |
|
Hide selected rows |
Ctrl+9 |
|
Hide selected columns |
Ctrl+0 |
Access keys for ribbon tabs
|
|
Instruction search box |
Alt + Q |
|
Open the "File" page |
Alt+F |
|
Open the "Home" tab |
Alt+H |
|
Open the "Insert" tab |
Alt+N |
|
Open the "Page Layout" tab |
Alt+P |
|
Open the Formulas tab |
Alt+M |
|
Open the Data tab |
Alt+A |
|
Open the Review tab |
Alt+R |
|
Open the View tab |
Alt+W |
Use the Ribbon with the Keyboard
|
|
Select the active tab of the Ribbon and activate the access key. |
Alt or F10 |
|
Move the focus to a command on the ribbon. |
Tab or Shift+Tab |
|
Move down, up, left, or right, respectively, between items on the ribbon. |
Down, Up, Left, or Right Arrow key |
|
Activate the selected button. |
Spacebar or Enter |
|
Open a list of selected commands. |
Down Arrow |
|
Opens the menu for the selected button. |
Alt+Down Arrow key |
|
When a menu or submenu is open, moves to the next command. |
Down Arrow key |
|
Expands or collapses the ribbon. |
Ctrl+F1 |
|
Opens the context menu. |
Shift+F10 |
|
When a main menu is open or selected, moves to a submenu. |
Left Arrow |
Keyboard shortcuts for cell navigation
|
|
Move to the previous cell in a worksheet or the previous option in a dialog box |
Shift+Tab |
|
Move up one cell in a worksheet. |
Up Arrow |
|
Move down one cell in a worksheet. |
Down Arrow |
|
Move left one cell in a worksheet. |
Left Arrow |
|
Move one cell to the right in the worksheet. |
Right Arrow |
|
Move to the edge of the current data area in the worksheet. |
Ctrl + Arrow Keys |
|
Move to the last cell on the worksheet, that is, the bottom row of the rightmost column in use. |
Ctrl+End |
|
Extend the cell selection to the last used cell on the worksheet (lower right corner). |
Ctrl+Shift+End |
|
When Scroll Lock is on, move to the upper-left cell of the window. |
Home+Scroll Lock |
|
Move to the beginning of the worksheet. |
Ctrl+Home |
|
Move down one screen in the worksheet. |
Page Down |
|
Move to the next worksheet in the workbook. |
Ctrl+Page Down |
|
Move right one screen in the worksheet. |
Alt+Page Down |
|
Move up one screen in a worksheet. |
Page Up |
|
Move left one screen in a worksheet. |
Alt+Page Up |
|
Move to the previous worksheet in a workbook. |
Ctrl+Page Up |
|
Move right one cell in a worksheet. Or, in a protected worksheet, move between unlocked cells. |
Tab |
|
Open a list of validation options on a cell that has data validation options applied. |
Alt+Down Arrow key |
|
Wrap around floating shapes such as text boxes or images. |
Press Ctrl+Alt+5, then press Tab repeatedly |
|
Exit floating shape navigation and return to normal navigation. |
Esc |
Keyboard shortcuts for cell formatting
|
|
Open the Format Cells dialog box. |
Ctrl+1 |
|
Set font format in the Format Cells dialog box. |
Ctrl+Shift+F or Ctrl+Shift+P |
|
Edit the active cell and place the insertion point at the end of its contents. Or, if editing is off for the cell, move the insertion point to the formula bar. If editing a formula, turn point mode off or on so that you can create references using the arrow keys. |
F2 |
|
Add or edit a cell comment. |
Shift+F2 |
|
Open the Insert dialog box for inserting a blank cell. |
Ctrl+Shift+Plus Sign (+) |
|
Open the Delete dialog box for deleting selected cells. |
Ctrl+Minus sign (-) |
|
Enter the current time. |
Ctrl+Shift+Colon (:) |
|
Enter the current date. |
Ctrl+Semicolon (;) |
|
In a worksheet, switch between showing cell values or formulas. |
Ctrl+Grave accent (`) |
|
Copy a formula from the cell above the active cell into a cell or the edit bar. |
Ctrl+Apostrophe (') |
|
Move selected cells. |
Ctrl+X |
|
Copy selected cells. |
Ctrl+C |
|
Paste contents at the insertion point, replacing any selected contents. |
Ctrl+V |
|
Open the Paste Special dialog box. |
Ctrl+Alt+V |
|
Italicize text or remove italic formatting. |
Ctrl+I or Ctrl+3 |
|
Make text bold or remove bold formatting. |
Ctrl+B or Ctrl+2 |
|
Add or remove underlining to text. |
Ctrl+U or Ctrl+4 |
|
Apply or remove strikethrough formatting. |
Ctrl+5 |
|
Switch between hiding objects, showing objects, and showing placeholders for objects. |
Ctrl+6 |
|
Applies an outline border to selected cells. |
Ctrl+Shift+Ampersand (&) |
|
Remove an outline border from selected cells. |
Ctrl+Shift+Underline (_) |
|
Show or hide outline symbols. |
Ctrl+8 |
|
Use the Fill Down command to copy the contents and formatting of the topmost cell in the selected range to the cells below. |
Ctrl+D |
|
Apply the General number format. |
Ctrl+Shift+Tilde (~) |
|
Apply the Currency format with two decimal places (negative numbers are enclosed in parentheses). |
Ctrl+Shift+Dollar Sign ($) |
|
Applies the Percent format with no decimal places. |
Ctrl+Shift+Percent (%) |
|
Applies the Scientific notation format with two decimal places. |
Ctrl+Shift+Caret (^) |
|
Applies the Date format with the day, month, and year. |
Ctrl+Shift+Number Sign (#) |
|
Applies the Time format with hours and minutes and AM or PM. |
Ctrl+Shift+@ sign (@) |
|
Applies a Number format with two decimal places, a thousands separator, and a minus sign (-) for negative values. |
Ctrl+Shift+Exclamation point (!) |
|
Opens the Insert Hyperlink dialog box |
Ctrl+K |
|
Checks spelling in the active worksheet or selected range. |
F7 |
|
Displays the Quick Analysis options for selected cells that contain data. |
Ctrl+Q |
|
Display the Create Table dialog box. |
Ctrl+L or Ctrl+T |
Keyboard shortcuts for making selections and performing actions
|
|
Select the entire worksheet. |
Ctrl+A or Ctrl+Shift+Spacebar |
|
Select the current and next worksheets in the workbook. |
Ctrl+Shift+Page Down |
|
Select the current and previous worksheets in the workbook. |
Ctrl+Shift+Page Up |
|
Expand the selection of cells by one cell. |
Shift+arrow keys |
|
Expand the selection of cells to the last non-blank cell in the column or row of the active cell, or to the next non-blank cell if the next cell is blank. |
Ctrl+Shift+arrow keys |
|
Turn on extend mode and use the arrow keys to extend the selection. Press again to turn off. |
F8 |
|
Add nonadjacent cells or ranges to a selection of cells by using the arrow keys. |
Shift+F8 |
|
Start a new row in the same cell. |
Alt+Enter |
|
Fill the selected cell range with the current entry. |
Ctrl+Enter |
|
Complete a cell entry and select the cell above. |
Shift+Enter |
|
Select an entire column in a worksheet. |
Ctrl+Spacebar |
|
Selects an entire row in a worksheet. |
Shift+Spacebar |
|
When an object is selected, select all objects on the worksheet. |
Ctrl+Shift+Spacebar |
|
Extend the selection of cells to the beginning of the worksheet. |
Ctrl+Shift+Home |
|
If the worksheet contains data, selects the current area. Pressing it again selects the current area and its summary rows. Pressing it a third time selects the entire worksheet. |
Ctrl+A or Ctrl+Shift+Spacebar |
|
Selects the current area surrounding the active cell or selects the entire PivotTable. |
Ctrl+Shift+Asterisk (*) |
|
When a menu or submenu is visible, selects the first command on the menu. |
Home |
|
Repeats the last command or action, if possible. |
Ctrl+Y |
|
Undoes the last action. |
Ctrl+Z |
Keyboard shortcuts for working with data, functions, and the formula bar
|
|
Type a formula |
= (equal sign) |
|
Enter a formula as an array formula |
Ctrl+Shift+Enter |
|
Insert an AutoSum formula with the SUM function |
Alt+= (equal sign) |
|
Select the entire PivotTable. |
Ctrl+Shift+Asterisk (*) |
|
Edit the active cell and place the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point to the formula bar. If editing a formula, turns point mode off or on so that you can create references using the arrow keys. |
F2 |
|
Expand or collapse the formula bar. |
Ctrl+Shift+U |
|
Cancel entry in a cell or formula bar. |
Esc |
|
Complete entry in the formula bar and select the cell below. |
Enter |
|
When in the formula bar, moves the cursor to the end of the text. |
Ctrl+End |
|
Selects all text in the formula bar from the cursor position to the end. |
Ctrl+Shift+End |
|
Calculates all worksheets in all open workbooks. |
F9 |
|
Calculates the active worksheet. |
Shift+F9 |
|
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
Ctrl+Alt+F9 |
|
Checks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing calculation. |
Ctrl+Alt+Shift+F9 |
|
Displays the menu or message for the Error Checking button. |
Alt+Shift+F10 |
|
When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. |
Ctrl+A |
|
When the insertion point is to the right of a function name in a formula, inserts argument names and parentheses. |
Ctrl+Shift+A |
|
Invokes Flash Fill to automatically recognize patterns in adjacent columns and fill the current column |
Ctrl+E |
|
If a cell reference or range is selected, cycles through all the various combinations of absolute and relative references in the formula. |
F4 |
|
Inserts a function. |
Shift+F3 |
|
Copies the value of the cell above the active cell into a cell or the formula bar. |
Ctrl+Shift+Straight Double Quote (") |
|
Creates an embedded chart of the data in the current range. |
Alt+F1 |
|
Creates a chart of the data in the current range in a separate chart sheet. |
F11 |
|
Defines a name for use in references. |
Alt+M, M, D |
|
Pastes a name from the Paste Names dialog box (if the name is already defined in the workbook) |
F3 |
|
Moves to the first field in the next record in the data form. |
Enter |
|
Create, run, edit, or delete a macro. |
Alt+F8 |
|
Open Microsoft Visual Basic For Applications Editor. |
Alt+F11 |
Function keys
|
|
Display the Excel Help task pane. |
F1 |
|
Show or hide the ribbon. |
Ctrl+F1 |
|
Create an embedded chart of data in the current range. |
Alt+F1 |
|
Insert a new worksheet. |
Alt+Shift+F1 |
|
Edit the active cell and place the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point to the formula bar. If editing a formula, turns point mode off or on so that you can create references using the arrow keys. |
F2 |
|
Add or edit a cell comment. |
Shift+F2 |
|
Display the print preview area on the Print tab in Backstage view. |
Ctrl+F2 |
|
Display the Paste Name dialog box. Available only if names are already defined in the workbook. |
F3 |
|
Display the Insert Function dialog box. |
Shift+F3 |
|
Repeat the last command or action (if possible). When a cell reference or range is selected in a formula, F4 cycles through all the various combinations of absolute and relative references. |
F4 |
|
Close the selected workbook window. |
Ctrl+F4 |
|
Close Excel. |
Alt+F4 |
|
Display the Go To dialog box. |
F5 |
|
Restores the window size of the selected workbook window. |
Ctrl+F5 |
|
Switches between worksheets, ribbons, task panes, and zoom controls. In a split worksheet, F6 includes split panes when switching between panes and ribbon areas. |
F6 |
|
Switches between worksheets, zoom controls, task panes, and ribbons. |
Shift+F6 |
|
If more than one workbook window is open, Ctrl+F6 switches to the next workbook window. |
Ctrl+F6 |
|
Opens the Check Spelling dialog box, which is used to check spelling in the active worksheet or selected range. |
F7 |
|
If the workbook window is not maximized, Ctrl+F7 performs the Move command for that window. Use the arrow keys to move the window, and press Enter when you are finished, or Esc to cancel. |
Ctrl+F7 |
|
Turns Extended mode on or off. In Extended mode, "Extend Selection" appears in the status line, and pressing the arrow keys extends the selection. |
F8 |
|
Allows you to use the arrow keys to add nonadjacent cells or ranges to a selection of cells. |
Shift+F8 |
|
Executes the Size command when the workbook is not maximized. |
Ctrl+F8 |
|
Displays the Macro dialog box, which is used to create, run, edit, or delete macros. |
Alt+F8 |
|
Calculates all worksheets in all open workbooks. |
F9 |
|
Calculates the active worksheet. |
Shift+F9 |
|
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
Ctrl+Alt+F9 |
|
Recheck dependent formulas and then calculate all cells in all open workbooks, including cells not marked as needing calculation. |
Ctrl+Alt+Shift+F9 |
|
Minimize the workbook window to an icon. |
Ctrl+F9 |
|
Turn KeyTips on or off. (Pressing Alt also accomplishes the same purpose.) |
F10 |
|
Display the shortcut menu for the selected item. |
Shift+F10 |
|
Displays the menu or message for the Error Checking button. |
Alt+Shift+F10 |
|
Maximizes or restores the selected workbook window. |
Ctrl+F10 |
|
Creates a chart of the data in the current range in a separate chart sheet. |
F11 |
|
Inserts a new worksheet. |
Shift+F11 |
|
Opens the Microsoft Visual Basic For Applications Editor, in which you can create charts by using the Visual Basic for Applications (VBA) to create a macro. |
Alt+F11 |
|
Display the Save As dialog box. |
F12 |
