खाटू श्याम जी की, कृपा से
We all use Excel for work, study, or office tasks. But most people still click everything with the mouse… and that takes a lot of time! 😓
What if you could finish your Excel work 3x faster, just by using some simple keyboard shortcuts?
In this page, we’ve shared a complete list of 396+ Excel keyboard shortcuts — easy to remember, powerful to use. All shortcuts are organized clearly, with simple explanations.
📌 What You’ll Find Here
- Shortcut keys for charts, formatting, formulas, navigation, selection, paste special, and more
- Clean and scrollable table (mobile-friendly too!)
- Perfect for students, office workers, job seekers, and teachers
💡 How to Use This?
Don’t try to remember everything at once. Just pick 5 new shortcuts every week and start using them. You’ll become faster and smarter in no time!
🎁 Want a Free PDF Version?
If you want a printable PDF of these Excel shortcuts, just comment below or send us a message on Instagram saying “Excel Shortcut PDF”. We’ll send it to you for free!
Powered by SeekheIndia — India’s Free Learning Platform ❤️
| Shortcut Key | Description |
|---|---|
| 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 |
| (Ctrl + Alt + V) + B | Paste special, skipping blanks |
| (Ctrl + Alt + V) + C | Paste cell comments |
| (Ctrl + Alt + V) + D | Paste special, performing an addition |
| (Ctrl + Alt + V) + E | Transpose when pasting |
| (Ctrl + Alt + V) + H | Paste all, keeping source formatting |
| (Ctrl + Alt + V) + I | Paste special, performing a division |
| (Ctrl + Alt + V) + M | Paste special, performing a multiplication |
| (Ctrl + Alt + V) + N | Paste data validation |
| (Ctrl + Alt + V) + S | Paste special, performing a subtraction |
| (Ctrl + Alt + V) + U | Paste values and number formatting |
| (Ctrl + Alt + V) + V | Paste values |
| (Ctrl + Alt + V) + X | 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 |
| 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 + ‘ | 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 | Display the Paste Special dialog box |
| Ctrl + C | Copy |
| Ctrl + 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 | 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 | 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 | Paste |
| Ctrl + X | Cut |
| Delete | 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 |
| Esc | Within cell of Formula Bar, cancel entry |
| F2 | Edit active cell |
| 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 |
| 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 |
| Alt | Turn key tips (Ribbon keyboard shortcuts) On or Off |
| 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 |
| (Ctrl + Alt + V) + G | Paste merging conditional formatting of the destination and source ranges |
| (Ctrl + Alt + V) + T | Paste format |
| (Ctrl + Alt + 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 | No Border |
| Alt + H + B + O | Bottom Border |
| Alt + H + B + P | Top Border |
| Alt + H + B + R | Right Border |
| Alt + H + B + S | 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 | 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 |
| Alt + H + L + C + S | Clear conditional formatting rules from selected cells |
| Alt + H + L + C + T | Clear conditional formatting rules from selected 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 | 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 |
| 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 | Display Format Cells dialog box |
| Ctrl + 5 | Apply or remove strikethrough formatting |
| Ctrl + B | Apply or remove bold formatting |
| Ctrl + I | Apply or remove italic formatting |
| Ctrl + Shift + ! | Apply number format |
| Ctrl + Shift + # | Apply date format |
| Ctrl + Shift + $ | Apply currency format |
| Ctrl + Shift + % | Apply percentage format |
| Ctrl + Shift + & | Add outside borders to selected cell(s) |
| Ctrl + Shift + @ | Apply time format |
| Ctrl + Shift + ^ | Apply scientific format |
| Ctrl + Shift + _ | Remove outside borders |
| Ctrl + Shift + ~ | Apply general format |
| Ctrl + Shift + F | Display the Format Cells dialog box with the Font tab selected |
| Ctrl + T | Display the Create Table dialog box |
| Ctrl + U | Apply or remove underlining |
| F4 | Repeat last command or action, when possible |
| (Ctrl + Alt + V) + F | Paste formulas |
| (Ctrl + Alt + V) + L | Paste link to source data |
| (Ctrl + Alt + V) + R | Paste formulas and number formatting |
| = | Start/enter a formula |
| Alt + = | 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 |
| Ctrl + Alt + F9 | Calculate all worksheets in all open workbooks |
| Ctrl + F3 | Display the Name Manager dialog box |
| Ctrl + Shift + A | Insert function arguments |
| 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 |
| F4 | Toggles between available combinations of absolute and relative references |
| F9 | Calculate all worksheets in all open workbooks |
| Shift + F3 | 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 |
| 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 |
| 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 |
| Alt + A + G + G | (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 | (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 + – | (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 |
| 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 | Hide active column(s) |
| Ctrl + 8 | Alternate between hiding and displaying outline symbols |
| Ctrl + 9 | Hide active row(s) |
| Ctrl + Shift + + | (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 |
| Alt + H + I + L | Insert table columns to the left of the active cell |
| 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 | Unhide any hidden columns within selection |
| Ctrl + Shift + 9 | Unhide any hidden rows within selection |
| (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 + ; | Select visible cells |
| Alt + A to Alt + Z | Within a dialog box: (1) Select an option; or (2) Select/clear a 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 + * | 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 + [ | Go to direct precedents within active worksheet |
| Ctrl + ] | Go to direct dependents within active worksheet |
| Ctrl + A | (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 + Arrow Keys | (1) Go to edge of current data area; or (2) Within a cell, skip a word to the left or to the right |
| Ctrl + Backspace | Go to active cell in worksheet |
| Ctrl + End | Go to last cell (cell in lowest used row and right-most used column) of worksheet |
| Ctrl + End | Within a cell, go to end of cell contents |
| Ctrl + F | Display the Find and Replace dialog with the Find tab selected |
| Ctrl + F6 | Alternate between current active workbook window and next workbook window |
| Ctrl + G | Display the Go To dialog box |
| Ctrl + H | Display the Find and Replace dialog with the Replace tab selected |
| Ctrl + Home | (1) Go to first cell of worksheet; or (2) Within a cell, go to beginning of cell contents |
| Ctrl + Left-Mouse-Button Click | Add non-adjacent (1) Cells to current cell selection; or (2) Sheets to current sheet selection |
| Ctrl + Page Down / Ctrl + Page Up | Go to next sheet to the right / Go to prior sheet to the left |
| Ctrl + Shift + { | Go to all precedents (direct and indirect) within active worksheet |
| Ctrl + Shift + } | Go to all dependents (direct and indirect) within active worksheet |
| Ctrl + Shift + Arrow Keys | (1) Extend selection to edge of current data area; or (2) Within a cell, select (or add to selection) the word to the left or to the right of the current selection/insertion point |
| Ctrl + Shift + End | (1) Extend selection to last cell (cell in lowest used row and right-most used column) of worksheet; or (2) Within a cell or the Formula Bar, select (or add to selection) all the words from the current selection/insertion point to the end of contents of cell or Formula Bar |
| Ctrl + Shift + F4 | Find previous match |
| Ctrl + Shift + Home | (1) Extend selection to first cell of worksheet; or (2) Within a cell or the Formula Bar, select (or add to selection) all the words from the current selection/insertion point to the beginning of contents of cell or Formula Bar |
| Ctrl + Shift + O | Go to cells with comments |
| Ctrl + Shift + Page Down / Ctrl + Shift + Page Up | Select current active and next sheet to the right / Select current active and prior sheet to the left |
| Ctrl + Shift + Tab | (1) Go to previous workbook; or (2) Within a dialog box, go to previous tab |
| Ctrl + Space | Select active column |
| Ctrl + Tab | (1) Go to next workbook; or (2) Within a dialog box, go to next tab |
| End | (1) Turn End mode on; (2) Within a cell, go to end of current line; (3) When Scroll Lock is turned on, go to cell in lower-right corner of the window; or (4) When a menu or sub-menu is visible, select last command of the menu or sub-menu |
| Enter | (1) Within Ribbon, display selected tab or execute selected command; (2) Within a dialog box, perform action for default command button in dialog box; (3) Within cell selection, move active cell to next cell (usually right or down); or (4) Within Data Form, go to first field in next record |
| Enter | Within cell selection, move active cell to previous cell (usually left or up) |
| Esc | (1) Within menu, submenu, dialog box or message window, cancel the command and close the menu, submenu, dialog box or message window; (2) When object is selected, cancel selection |
| F1 | Display the Help Task pane |
| F5 + (Alt + S) | Display the Go To Special dialog box |
| F5 + (Alt + S) + A | Select the current array |
| F5 + (Alt + S) + B | Select all objects in worksheet |
| Alt + H + FD + P | Display/hide the Selection task pane |
| F5 + (Alt + S) + D + L | Go to all dependents |
| F5 + (Alt + S) + F | Go to cells with formulas |
| F5 + (Alt + S) + K | Go to blank cells |
| F5 + (Alt + S) + M | Select column differences |
| F5 + (Alt + S) + O | Go to cells with constants |
| F5 + (Alt + S) + P + L | Go to all precedents |
| F5 + (Alt + S) + T | Select cells with conditional formatting |
| F5 + (Alt + S) + T + E | Select cells with same conditional formatting |
| F5 + (Alt + S) + V | Select cells with data validation |
| F5 + (Alt + S) + V + E | Select cells with same data validation |
| F5 + (Alt + S) + W | Select row differences |
| F6 | Switch between panes in the following order: worksheet, Ribbon, Task pane, Zoom controls |
| F8 | Turn Extend Selection mode on or off |
| Home | (1) Go to beginning of a row in a worksheet; (2) Within a cell, go to beginning of current line; (3) When Scroll Lock is turned on, go to cell in upper-left corner of the window; or (4) When a menu or sub-menu is visible, select first command of the menu or sub-menu |
| Left Mouse Button + Shift | Add adjacent cells or worksheets to current selection |
| Page Down / Page Up | Move 1 screen down / 1 screen up |
| Shift + Arrow Keys | (1) Extend selection by 1 cell; or (2) Within a cell, select (or add to selection) the character to the left or to the right of the current selection/insertion point |
| Shift + Backspace | When multiple cells are selected, select only the active cell |
| Shift + End | Within a cell, select to the end of the current row |
| Shift + F10 | Display the Context/Shortcut menu for the selected item |
| Shift + F4 | Repeat last find action/Find next match |
| Shift + F6 | Switch between panes in the following order: worksheet, Zoom controls, Task pane, Ribbon |
| Shift + F8 | Add non-adjacent range to current selection |
| Shift + Home | (1) Select to the beginning of the current row or (2) Within a cell, select to the beginning of the current row |
| Shift + Page Down / Shift + Page Up | Extend selection 1 screen down / 1 screen up |
| Shift + Space | Select active row |
| Shift + Tab | (1) Move one cell to the left in a worksheet or to previous unlocked cell in a protected worksheet; (2) Within a selection, move active cell to the left; (3) Within a dialog box or the Ribbon, move to previous option or option group |
| Spacebar | (1) Within a dialog box, perform the action that corresponds to the selected button, or select or clear a checkbox; (2) Within the Ribbon, activate the selected command or control or open the selected menu or gallery |
| Tab | (1) Move one cell to the right in a worksheet or to next unlocked cell in a protected worksheet; (2) Within a selection, move active cell to the right; (3) Within a dialog box or the Ribbon, move to next option or option group |
| Alt + N + V | PivotTable |
| Alt + P + R + S | Set Print Area |
| Alt + P + S + P | Display the Page Setup dialog box |
| Ctrl + F2 | Display Print Preview area on Print tab of Backstage View |
| Ctrl + P | Display Print tab of Backstage View (print) |
| Alt + A + Q | Advanced Filter |
| Alt + A + SA | Sort smallest to largest |
| Alt + A + SD | Sort largest to smallest |
| Alt + A + SS | Displays the Sort dialog box |
| Alt + A + V + V | Display the Data Validation dialog box |
| Alt + H + S + C | Clear filter |
| Ctrl + Alt + L | Reapply filter and sort on current range |
| Ctrl + Shift + L | Turn filter on or off |
| Right Mouse Button + E + V | Filter by the selected cell’s value |
| Alt + A + E | Display the Convert Text to Columns Wizard |
| Alt + A + FT | Display the Import Text File dialog box |
| F5 | Within the Visual Basic Editor, execute macro |
| Alt + F11 | (1) If Visual Basic Editor is closed, open Visual Basic Editor; or (2) If Visual Basic Editor is open, toggle between Excel and Visual Basic Editor |
| Alt + F8 | Display the Macro dialog box |
| Alt + L + I | Expand the Insert Form Controls and ActiveX Controls drop-down menu |
| Alt + W + M + R | Record Macro |
| Alt + W + M + U | Use Relative References |
| Ctrl + G | Display the Immediate Window in the Visual Basic Editor |
| F2 | Within the Visual Basic Editor, display the Object Browser |
| Alt + H + D + S | Delete current active sheet |
| Alt + H + D + S | Delete active worksheet |
| Alt + H + O + M | Display the Move or Copy sheet dialog |
| Alt + H + O + M | Display the Move or Copy dialog box to move or copy the active worksheet |
| Alt + H + O + P | Display the Protect Sheet dialog box |
| Alt + H + O + R | Rename current active sheet |
| Alt + H + O + R | Rename active worksheet |
| Alt + H + O + T | Expand the sheet Tab Color drop-down menu |
| Alt + H + O + T | Expand the Tab Color drop-down menu |
| Alt + H + O + T + N | Set current worksheet tab to have no color |
| Alt + H + O + U + H | Display the Unhide sheet dialog box |
| Alt + H + O + U + H | Display the Unhide dialog box to unhide a worksheet |
| Alt + H + O + U + S | Hide current active sheet |
| Alt + H + O + U + S | Hide active worksheet |
| Alt + Shift + F1 | Insert new worksheet |
| Ctrl + F11 | New Macro sheet |
| Ctrl + F12 | Display the Open dialog box |
| Ctrl + F4 | Close current selected workbook window |
| Ctrl + F7 | Apply Move command on active workbook window (when not maximized) |
| Ctrl + F8 | Apply Resize command on active workbook window (when not maximized) |
| Ctrl + F9 | Minimize current selected workbook window |
| Ctrl + N | Create a new blank workbook |
| Ctrl + O | Display Open tab of Backstage View (open a workbook) |
| Ctrl + S | Save active file (1) using current file name and format, and (2) in current file location |
| Ctrl + W | Close the selected workbook |
| F12 | Display the Save As dialog box |
| Shift + F11 | Insert a new worksheet in the current workbook |
