I'm constantly gathering information about Excel keyboard shortcuts and hotkeys. Some time ago, I started developing an extremely comprehensive list of Excel keyboard shortcuts and hotkeys.
You can get the most recent version of this Cheat Sheet for free. The current version includes more than 350 entries/shortcuts.
If you want to learn more about keyboard shortcuts, including how to find them and how to create custom shortcuts, please refer to this blog post.
You can get free access to this Keyboard Shortcut PDF Cheat Sheet by clicking the button below.
One advantage of getting the PDF Keyboard Shortcut Cheat Sheet is that you can (later) bring the keyboard shortcuts from the PDF file into Excel to rearrange them according to your preferences. You can use any of these methods to convert PDF files to Excel. You can also implement these methods using VBA.
I list the keyboard shortcuts in the Tables below. Use the following Table of Contents to navigate to the category of keyboard shortcuts you're interested in.
Table of Contents
Excel Keyboard Shortcuts: Charts And Graphs
| Shortcut #1 | Shortcut #2 | Shortcut #3 | Basic Description | Additional Comments |
|---|---|---|---|---|
| Alt + F1 | Create an embedded chart using currently selected data | |||
| Alt + JA | (1) In Excel 2013 and later, go to Format tab of the Ribbon (when active); or (2) In Excel 2007 and 2010, go to Layout tab of the Ribbon (when active) | |||
| Alt + JC | Go to Design tab of the Ribbon (when active) | |||
| Alt + JC + A | In Excel 2013 and later, expand Add Chart Element drop-down menu | |||
| Alt + N + B | Insert Bar Chart | |||
| Alt + N + C | Insert Column Chart | |||
| Alt + N + N | Insert Line Chart | |||
| Alt + N + Q | Insert Pie or Doughnut Chart | |||
| Alt + N + R | In Excel 2013 and later, Recommended Charts | |||
| Alt + N + SD | In Excel 2013 and later, Insert Combo Chart | |||
| Alt + N + X | Insert Text Box | |||
| F11 | Create a chart in a separate Chart sheet using currently selected data |
Excel Keyboard Shortcuts: Data
| Shortcut #1 | Shortcut #2 | Shortcut #3 | Basic Description | Additional Comments |
|---|---|---|---|---|
| (Ctrl + Alt + V) + B | Paste special, skipping blanks | When skipping blanks, existing values in the destination are not replaced by blanks in the source data | ||
| (Ctrl + Alt + V) + C | Paste cell comments | |||
| (Ctrl + Alt + V) + D | Paste special, performing an addition | Adds the value in the clipboard to the value(s) in the destination cells | ||
| (Ctrl + Alt + V) + E | Alt + H + V + T | Transpose when pasting | ||
| (Ctrl + Alt + V) + H | Alt + H + V + K | Paste all, keeping source formatting | ||
| (Ctrl + Alt + V) + I | Paste special, performing a division | Divides the value(s) in the destination cells by the value in the clipboard | ||
| (Ctrl + Alt + V) + M | Paste special, performing a multiplication | Multiplies the value(s) in the destination cells by the value in the clipboard | ||
| (Ctrl + Alt + V) + N | Paste data validation | |||
| (Ctrl + Alt + V) + S | Paste special, performing a subtraction | Subtracts the value in the clipboard from the value(s) in the destination cell(s) | ||
| (Ctrl + Alt + V) + U | Alt + H + V + A | Paste values and number formatting | ||
| (Ctrl + Alt + V) + V | Alt + H + V + V | Paste values | ||
| (Ctrl + Alt + V) + X | Alt + H + V + B | Paste all, except borders | ||
| Alt + A + M | Displays the Remove Duplicates dialog box | |||
| Alt + A + W + G | Display the Goal Seek dialog box | |||
| Alt + A + W + S | Display the Scenario Manager dialog box | |||
| Alt + A + W + T | Display the Data Table dialog box | |||
| Alt + Enter | Start new line within cell | |||
| Alt + H + C + P | Display the Copy as Picture dialog | |||
| Alt + H + E + A | Clear all | |||
| Alt + H + E + L | Clear hyperlinks | |||
| Alt + H + E + M | Clear comments | |||
| Alt + H + E + R | Remove hyperlinks | |||
| Alt + H + FI + A | Display the Fill Across Worksheets dialog box | |||
| Alt + H + FI + J | Fill justify | |||
| Alt + H + FI + L | Fill left as follows: (1) Copy right-most cell of a selected range into cells to the left; or (2) Copy from right cell into active cell | |||
| Alt + H + FI + S | Display the Series dialog box | |||
| Alt + H + FI + U | Fill up as follows: (1) Copy lower cell of a selected range into cells above; or (2) Copy from cell below into active cell | |||
| Alt + H + FO | Display the Clipboard task pane | |||
| Alt + H + V + E | Paste values, keeping source formatting | |||
| Alt + H + V + I | Paste linked picture | |||
| Alt + H + V + U | Paste picture | |||
| Alt + R + A | Show all comments | |||
| Alt + R + D | Delete comment | |||
| Backspace | (1) Within Formula Bar or cell (in cell-editing mode), deletes 1 character to the left or deletes the selection (if any); or (2) When not in cell-editing mode, clears the contents of selected/active cell(s) | |||
| Ctrl + ' | Ctrl + Shift + ' | Copy formula/text from cell above into active cell or Formula Bar | ||
| Ctrl + " | Copy values/text from cell above into active cell or Formula Bar | |||
| Ctrl + ; | Enter current date | |||
| Ctrl + Alt + V | Alt + H + V + S | Display the Paste Special dialog box | There must be data in the Clipboard for command to be available | |
| Ctrl + C | Ctrl + Insert | Alt + H + C + C | Copy | |
| Ctrl + D | Alt + H + FI + D | Fill down as follows: (1) Copy top cell of a selected range into cells below; or (2) Copy from cell above into active cell | ||
| Ctrl + Delete | Delete to the end of current line | |||
| Ctrl + E | Alt + H + FI + F | Flash Fill | ||
| Ctrl + Enter | (1) Enter current entry in selected range and stay in same active cell; or (2) Complete cell entry and stay in same active cell | |||
| Ctrl + K | (1) Within a cell without hyperlinks, display the Insert Hyperlink dialog box; or (2) Within a cell with a hyperlink, display the Edit Hyperlink dialog box | |||
| Ctrl + Q | Expand the Quick Analysis tool | |||
| Ctrl + R | Alt + H + FI + R | Fill right as follows: (1) Copy left-most cell of a selected range into cells to the right; or (2) Copy from left cell into active cell | ||
| Ctrl + Shift + : | Enter current time | |||
| Ctrl + Shift + : | Enter current time | |||
| Ctrl + V | Alt + H + V + P | Paste | Pastes at the insertion point and replaces any selection. There must be data in the Clipboard for command to be available | |
| Ctrl + X | Alt + H + X | Cut | ||
| Delete | Alt + H + E + C | Clear contents of the selected/active cell(s) | ||
| Delete | Within Formula Bar or cell (in cell-editing mode), deletes 1 character to the right or deletes the selection (if any) | |||
| Enter | (1) Within cell or Formula Bar, complete cell entry and (by default) go to cell below; or (2) Within an AutoFilter list, filter the list using the selected item | Enter is also under the Navigation and Selection category | ||
| Esc | Within cell of Formula Bar, cancel entry | Esc is also under the Navigation and Selection category | ||
| F2 | Edit active cell | Positions the insertion point at the end of cell contents. When Allow editing directly in cells is turned off, moves the insertion point to the Formula Bar | ||
| F7 | Display the Spelling dialog box | |||
| Right Mouse Button + E | When a row or column is selected, insert copied or cut cells | |||
| Shift + Enter | Within cell of Formula Bar, complete cell entry and (by default) go to the cell above | |||
| Shift + F10 + m | Insert or delete cell comment | |||
| Shift + F2 | Insert or edit a cell comment | |||
| Shift + F7 | Display the Thesaurus dialog box or task pane | |||
| Shift + Tab | (1) Complete cell entry and move one cell to the left in a worksheet or to previous unlocked cell in a protected sheet; (2) Select suggestion from autocomplete to complete entry and move one cell to the left or to previous unlocked cell | Shift + Tab is also under the Navigation and Selection and Formulas and Functions categories | ||
| Tab | (1) Complete cell entry and move one cell to the right in a worksheet or to next unlocked cell in a protected sheet; (2) Select suggestion from autocomplete to complete entry and move one cell to the right or to next unlocked cell | Tab is also under the Navigation and Selection and Formulas and Functions categories |
Excel Keyboard Shortcuts: Display
| Shortcut #1 | Shortcut #2 | Shortcut #3 | Basic Description | Additional Comments |
|---|---|---|---|---|
| Alt | F10 | Turn key tips (Ribbon keyboard shortcuts) On or Off | Alt is also under the Navigation and Selection category | |
| Alt + W + F + F | Freeze Panes | |||
| Alt + W + I | Page Break Preview | |||
| Alt + W + L | Normal View | |||
| Alt + W + Q | Display the Zoom dialog box | |||
| Alt + W + VG | View/hide gridlines | |||
| Ctrl + ` | Toggle between (1) displaying cell values and (2) displaying formulas in worksheet | |||
| Ctrl + 6 | Alternate between hiding and showing object(s) | |||
| Ctrl + F1 | Expand or collapse the Ribbon | |||
| Ctrl + F10 | Maximize/restore current selected workbook window | |||
| Ctrl + Scroll Mouse Wheel | Zoom in/out | |||
| Ctrl + Shift + U | Toggle between expanding and collapsing the Formula Bar |
Excel Keyboard Shortcuts: Format
| Shortcut #1 | Shortcut #2 | Shortcut #3 | Basic Description | Additional Comments |
|---|---|---|---|---|
| (Ctrl + Alt + V) + G | Alt + H + V + G | Paste merging conditional formatting of the destination and source ranges | The Paste all merging conditional formats option is only enabled when copying a range that contains conditional formatting | |
| (Ctrl + Alt + V) + T | Alt + H + V + R | Paste format | ||
| (Ctrl + Alt + V) + W | Alt + H + V + W | Paste column widths | ||
| Alt + ' | Display the Style dialog box | |||
| Alt + B | Within Border tab of Format Cells dialog box, add/remove bottom border | |||
| Alt + D | Within Border tab of Format Cells dialog box, add/remove downward diagonal border | |||
| Alt + H | Within Border tab of Format Cells dialog box and when more than 1 row is selected, add/remove horizontal interior border | |||
| Alt + H + 0 | Increase the number of decimals displayed | |||
| Alt + H + 3 + D | Apply or remove double underlining | |||
| Alt + H + 5 | Decrease indent | |||
| Alt + H + 5 | Decrease indent | |||
| Alt + H + 6 | Increase indent | |||
| Alt + H + 6 | Increase indent | |||
| Alt + H + 9 | Decrease the number of decimals displayed | |||
| Alt + H + AB | Align text to the bottom of the cell | |||
| Alt + H + AC | Align text to the center (between left and right) of the cell | |||
| Alt + H + AL | Align text to the left of the cell | |||
| Alt + H + AM | Align text to the middle (between the top and the bottom) of the cell | |||
| Alt + H + AN | Choose accounting format | |||
| Alt + H + AN + M | Display the Format Cells dialog box with the Number tab and the Accounting category selected | |||
| Alt + H + AR | Align text to the right of the cell | |||
| Alt + H + AT | Align text to the top of the cell | |||
| Alt + H + B | Expand Borders drop-down menu | |||
| Alt + H + B + A | All Borders | |||
| Alt + H + B + B | Bottom double border | |||
| Alt + H + B + C | Top and thick bottom border | |||
| Alt + H + B + D | Top and bottom border | |||
| Alt + H + B + E | Erase border | |||
| Alt + H + B + G | Draw border grid | |||
| Alt + H + B + H | Thick bottom border | |||
| Alt + H + B + I | Choose border line color | |||
| Alt + H + B + L | Left Border | |||
| Alt + H + B + M | Display the Format Cells dialog box with the Border tab selected | |||
| Alt + H + B + N | Ctrl + Shift + - | No Border | ||
| Alt + H + B + O | Bottom Border | |||
| Alt + H + B + P | Top Border | |||
| Alt + H + B + R | Right Border | |||
| Alt + H + B + S | Ctrl + Shift + 7 | Outside border | ||
| Alt + H + B + T | Thick box border | |||
| Alt + H + B + U | Top and double bottom border | |||
| Alt + H + B + W | Draw border | |||
| Alt + H + B + Y | Choose border line style | |||
| Alt + H + E + F | Clear formatting | |||
| Alt + H + FC | Choose font color | |||
| Alt + H + FC | Expand Font Color drop-down menu | |||
| Alt + H + FF | Change the font face | |||
| Alt + H + FG | Increase font size one point | |||
| Alt + H + FG | Increase the font size by 1 point | |||
| Alt + H + FK | Decrease font size one point | |||
| Alt + H + FK | Decrease the font size by 1 point | |||
| Alt + H + FM | Display the Format Cells dialog box with the Number tab selected | |||
| Alt + H + FN | Display the Format Cells dialog box with the Font tab selected | |||
| Alt + H + FP | Activate the Format Painter | |||
| Alt + H + FQ + D | Rotate text down | |||
| Alt + H + FQ + L | Rotate text in an angle clockwise | |||
| Alt + H + FQ + M | Alt + H + FA | Display the Format Cells dialog box with the Alignment tab selected | ||
| Alt + H + FQ + O | Rotate text in an angle counterclockwise | |||
| Alt + H + FQ + U | Rotate text up | |||
| Alt + H + FQ + V | Rotate text so that it is vertical | |||
| Alt + H + FS | Change the font size | |||
| Alt + H + H | Expand Fill Color drop-down menu | |||
| Alt + H + H + N | Apply no fill color to current cell selection | |||
| Alt + H + J | Expand the Cell Styles menu | |||
| Alt + H + J + M | Display the Merge Styles dialog box to merge (copy) cell styles from another workbook | |||
| Alt + H + J + N | Display the Style dialog box to create a new cell style | |||
| Alt + H + K | Format number with a thousands comma (,) separator | |||
| Alt + H + L + C + E | Clear conditional formatting rules from entire worksheet | |||
| Alt + H + L + C + P | Clear conditional formatting rules from selected PivotTable | This option is only active when the active cell is within a PivotTable | ||
| Alt + H + L + C + S | Clear conditional formatting rules from selected cells | |||
| Alt + H + L + C + T | Clear conditional formatting rules from selected table | This option is only active when the active cell is within a table | ||
| Alt + H + L + D | Expand the menu to set a conditional formatting rule using data bars with gradient or solid fill | |||
| Alt + H + L + D + M | Alt + H + L + S + M | Alt + H + L + I + M | Display the New Conditional Formatting Rule dialog box, with the Format all cells based on their values rule type selected | |
| Alt + H + L + H + A | Display the A Data Occurring dialog box to conditionally format cells whose date occurs within the time period set in the rule | |||
| Alt + H + L + H + B | Display the Between dialog box to conditionally format cells whose value is between the values set in the rule | |||
| Alt + H + L + H + D | Display the Duplicate Values dialog box to conditionally format cells with duplicate or unique values in the selected cell range | |||
| Alt + H + L + H + E | Display the Equal To dialog box to conditionally format cells whose value is equal to the value set in the rule | |||
| Alt + H + L + H + G | Display the Greater Than dialog box to conditionally format cells whose value is greater than the value set in the rule | |||
| Alt + H + L + H + L | Display the Less Than dialog box to conditionally format cells whose value is less than the value set in the rule | |||
| Alt + H + L + H + M | Display the New Conditional Formatting Rule dialog box, with the Format only cells that contain rule type selected | |||
| Alt + H + L + H + T | Display the Text That Contains dialog box to conditionally format cells whose text contains the text set in the rule | |||
| Alt + H + L + I | Expand the menu to set a conditional formatting rule using icon sets | |||
| Alt + H + L + N | Display the New Conditional Formatting Rule dialog box | |||
| Alt + H + L + R | Display the Conditional Formatting Rules Manager | |||
| Alt + H + L + S | Expand the menu to set a conditional formatting rule using color scales | |||
| Alt + H + L + T + A | Display the Above Average dialog box to conditionally format cells that are above the average in the selected cell range | |||
| Alt + H + L + T + B | Display the Bottom 10 Items dialog box to conditionally format cells that rank within the bottom values in the selected cell range | |||
| Alt + H + L + T + M | Display the New Conditional Formatting Rule dialog box, with the Format only top or bottom ranked values rule type selected | |||
| Alt + H + L + T + O | Display the Bottom 10% dialog box to conditionally format cells that rank within a certain bottom percentile in the selected cell range | |||
| Alt + H + L + T + P | Display the Top 10% dialog box to conditionally format cells that rank within a certain top percentile in the selected cell range | |||
| Alt + H + L + T + T | Display the Top 10 Items dialog box to conditionally format cells that rank within the top values in the selected cell range | |||
| Alt + H + L + T + V | Display the Below Average dialog box to conditionally format cells that are below the average in the selected cell range | |||
| Alt + H + M + A | Merge across cells | The selected cells in the same row are merged | ||
| Alt + H + M + M | Merge cells | |||
| Alt + H + M + U | Unmerge cells | |||
| Alt + H + N | Choose number format | |||
| Alt + H + O + A | Auto-fit row height | |||
| Alt + H + O + H | Display the Row Height dialog box | |||
| Alt + H + O + I | Auto-fit column width | |||
| Alt + H + O + W | Display the Column Width dialog box | |||
| Alt + H + T | Expand Format as Table drop-down menu | |||
| Alt + H + T | Expand the Format as Table menu | |||
| Alt + H + T + N | Display the New Table Style dialog box | |||
| Alt + H + T + P | Display the New PivotTable Style dialog box | |||
| Alt + H + W | Wrap text | |||
| Alt + L | Within Border tab of Format Cells dialog box, add/remove left border | |||
| Alt + R | Within Border tab of Format Cells dialog box, add/remove right border | |||
| Alt + T | Within Border tab of Format Cells dialog box, add/remove top border | |||
| Alt + V | Within Border tab of Format Cells dialog box and when more than 1 column is selected, add/remove vertical interior border | |||
| Ctrl + 1 | Alt + H + O + E | Display Format Cells dialog box | ||
| Ctrl + 5 | Apply or remove strikethrough formatting | |||
| Ctrl + B | Ctrl + 2 | Alt + H + 1 | Apply or remove bold formatting | |
| Ctrl + I | Ctrl + 3 | Alt + H + 2 | Apply or remove italic formatting | |
| Ctrl + Shift + ! | Apply number format | Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) minus (-) sign for negative values | ||
| Ctrl + Shift + # | Apply date format | Default setting is date, month and year | ||
| Ctrl + Shift + $ | Apply currency format | Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) negative values within parentheses ( ) | ||
| Ctrl + Shift + % | Alt + H + P | Apply percentage format | Default setting is without decimal places | |
| Ctrl + Shift + & | Add outside borders to selected cell(s) | |||
| Ctrl + Shift + @ | Apply time format | Default settings are: (1) hour and minute, and (2) AM or PM | ||
| Ctrl + Shift + ^ | Apply scientific format | Default setting is with 2 decimal places | ||
| Ctrl + Shift + _ | Remove outside borders | |||
| Ctrl + Shift + ~ | Apply general format | |||
| Ctrl + Shift + F | Ctrl + Shift + P | Display the Format Cells dialog box with the Font tab selected | ||
| Ctrl + T | Ctrl + L | Display the Create Table dialog box | ||
| Ctrl + U | Ctrl + 4 | Alt + H + 3 + U | Apply or remove underlining | |
| F4 | Repeat last command or action, when possible |
Excel Keyboard Shortcuts: Formulas And Functions
| Shortcut #1 | Shortcut #2 | Shortcut #3 | Basic Description | Additional Comments |
|---|---|---|---|---|
| (Ctrl + Alt + V) + F | Alt + H + V + F | Paste formulas | ||
| (Ctrl + Alt + V) + L | Alt + H + V + N | Paste link to source data | ||
| (Ctrl + Alt + V) + R | Alt + H + V + O | Paste formulas and number formatting | ||
| = | Start/enter a formula | |||
| Alt + = | Alt + H + U + S | AutoSum | ||
| Alt + H + U + A | Auto-calculate the average using the AVERAGE function | |||
| Alt + H + U + C | Auto-count numbers using the COUNT function | |||
| Alt + H + U + I | Auto-calculate the minimum value within a range using the MIN function | |||
| Alt + H + U + M | Auto-calculate the maximum value within a range using the MAX function | |||
| Alt + M + A + A | Remove Arrows from Formula Auditing | |||
| Alt + M + D | Trace Dependents | |||
| Alt + M + P | Trace Precedents | |||
| Alt + Shift + F10 | Display menu or message generated by error background checking | |||
| Ctrl + A | Display the Function Arguments dialog box and insert function arguments | Function name must have already been typed and insertion point must be to the right of the function name Ctrl + A is also under the Navigation and Cell Selection category |
||
| Ctrl + Alt + F9 | Calculate all worksheets in all open workbooks | Applies regardless of whether the worksheets/workbooks have/haven't been modified since the last calculation | ||
| Ctrl + F3 | Display the Name Manager dialog box | |||
| Ctrl + Shift + A | Insert function arguments | Function name must have already been typed and insertion point must be to the right of the function name | ||
| Ctrl + Shift + Enter | Enter formula as array formula | |||
| Ctrl + Shift + F3 | Display the Create Names from Selection dialog box | |||
| F3 | Display the Paste Name dialog box | There must be defined names in the workbook for command to be available | ||
| F4 | Toggles between available combinations of absolute and relative references | |||
| F9 | Calculate all worksheets in all open workbooks | |||
| Shift + F3 | Alt + H + U + F | Display the Insert Function dialog box | ||
| Shift + F9 | Calculate the current active worksheet | |||
| Shift + Tab | (1) Complete formula and move one cell to the left in a worksheet or to previous unlocked cell in a protected sheet; (2) Select suggestion from autocomplete to complete formula and move one cell to the left or to previous unlocked cell | Shift + Tab is also under the Navigation and Selection and Data categories | ||
| Tab | (1) Complete formula and move one cell to the right in a worksheet or to next unlocked cell in a protected sheet; (2) Select suggestion from autocomplete to complete formula and move one cell to the right or to next unlocked cell | Tab is also under the Navigation and Selection and Data categories |
Excel Keyboard Shortcuts: General
| Shortcut #1 | Shortcut #2 | Shortcut #3 | Basic Description | Additional Comments |
|---|---|---|---|---|
| Alt + F4 | Close current active Excel window | |||
| Alt + Space | Display Control menu | |||
| Alt + T + O | Display Excel Options dialog box | |||
| Ctrl + Y | Redo/repeat last action or command | |||
| Ctrl + Z | Undo/reverse last action or command |
Excel Keyboard Shortcuts: Grid
| Shortcut #1 | Shortcut #2 | Shortcut #3 | Basic Description | Additional Comments |
|---|---|---|---|---|
| Alt + A + G + G | Shift + Alt + Right Arrow | (1) If several rows/columns are selected, group rows/columns; or (2) Otherwise, display Group dialog box | ||
| Alt + A + H | Hide grouped rows/columns | |||
| Alt + A + J | Show grouped rows/columns | |||
| Alt + A + U + U | Shift + Alt + Left Arrow | (1) If grouped rows/columns are selected, ungroup rows/columns; or (2) Otherwise, display Ungroup dialog box | ||
| Alt + H + M + C | Merge & Center cells | |||
| Alt + H + W | Wrap Text | |||
| Ctrl + - | Alt + H + D + D | (1) Delete selected rows/columns; or (2) Display the Delete dialog box to delete cells/rows/columns | ||
| Alt + H + D + R | Delete worksheet rows | |||
| Alt + H + D + C | Delete worksheet columns | |||
| Alt + H + D + L | Delete table rows | Command is only available when active cell is within a table | ||
| Alt + H + D + M | Delete table columns | |||
| Alt + H + O + H | Display the Row Height dialog box | |||
| Alt + H + O + A | AutoFit row height | |||
| Alt + H + O + W | Display the Column Width dialog box | |||
| Alt + H + O + I | AutoFit column width | |||
| Alt + H + O + D | Display the Standard Width dialog box to change the default column width | |||
| Alt + H + O + L | Lock active cell(s) | |||
| Ctrl + 0 | Alt + H + O + U + C | Hide active column(s) | ||
| Ctrl + 8 | Alternate between hiding and displaying outline symbols | Applies if there are rows/columns grouped | ||
| Ctrl + 9 | Alt + H + O + U + R | Hide active row(s) | ||
| Ctrl + Shift + + | Alt + H + I + E | (1) Insert rows/columns above/to the left of the selected row/column; or (2) Display the Insert dialog box to insert cells/rows/columns | ||
| Alt + H + I + A | Insert table rows above of the active cell | Command is only available when active cell is within a table | ||
| Alt + H + I + L | Insert table columns to the left of the active cell | Command is only available when active cell is within a table | ||
| Alt + H + I + R | Insert worksheet rows above of the active cell | |||
| Alt + H + I + C | Insert worksheet columns to the left of the active cell | |||
| Ctrl + Shift + 0 | Alt + H + O + U + L | Unhide any hidden columns within selection | May not work in certain (particularly newer versions) of Excel by default. In those cases, you can usually enable the shortcut by modifying the language bar hotkey settings and changing the setting (e.g. selecting "Not Assigned") for the key sequence to switch input keyboard layout | |
| Ctrl + Shift + 9 | Alt + H + O + U + O | Unhide any hidden rows within selection |
Excel Keyboard Shortcuts: Navigation And Selection
| Shortcut #1 | Shortcut #2 | Shortcut #3 | Basic Description | Additional Comments |
|---|---|---|---|---|
| (Ctrl + Home) + (Ctrl + Shift + End) | Select entire used range of worksheet, from first to last cell | |||
| Alt | (1) Within cells with AutoFilter lists, close AutoFilter list; or (2) Within dialog boxes, close the expanded drop-down list box | |||
| Alt + ; | F5 + (Alt + S) + Y | Select visible cells | ||
| Alt + A to Alt + Z | Within a dialog box: (1) Select an option; or (2) Select/clear a checkbox | Specific letter is underlined in the label of the relevant option/checkbox | ||
| Alt + Down Arrow | (1) Within cells with AutoComplete lists or AutoFilter lists, display the AutoComplete list or AutoFilter list; or (2) Within dialog boxes, expand the selected drop-down list box | |||
| Alt + F | Go to Backstage View | |||
| Alt + Page Down / Alt + Page Up | Go one screen to the right within active sheet / Go one screen to the left within active sheet | |||
| Alt + Tab | Switch windows and go to next workbook | |||
| Alt + Up Arrow | Close AutoComplete list | |||
| Arrow Keys | (1) Within a worksheet, go to cell to the right, left, up or down of current active cell; (2) Within the Ribbon, move to the option to the next (right) or previous (left) option or tab; (3) Within a menu or sub-menu, switch between the main menu and the sub-menu; (4) Within a drop-down list, move between items; (5) Within a group of options, move between options; or (6) When Extend Selection mode is on, extend selection | |||
| Ctrl + Shift + * | F5 + (Alt + S) + R | When in a cell, select data area around active cell | ||
| Ctrl + . | When in a cell selection, move active cell clockwise to next corner (top-right > bottom-right > bottom-left > top-left) | |||
| Ctrl + [ | F5 + (Alt + S) + P | Go to direct precedents within active worksheet | ||
| Ctrl + ] | F5 + (Alt + S) + D | Go to direct dependents within active worksheet | ||
| Ctrl + A | Ctrl + Shift + Spacebar | (1) When in a cell, select data area around active cell (press shortcut a second or third time to select entire worksheet) or select entire worksheet; or (2) When an object is selected, select all such objects in worksheet | Ctrl + A is also under the Formulas and Functions category | |
| Ctrl + Arrow Keys |