| Create a New workbook | Ctrl N | | General Shortcuts |
| Open an existing workbook | Ctrl O | | General Shortcuts |
| Open a recent existing workbook | Alt F R | | General Shortcuts |
| Save current workbook | Ctrl S | | General Shortcuts |
| Close current workbook | Ctrl W | | General Shortcuts |
| Print (Preview) | Ctrl P | | General Shortcuts |
| Insert new worksheet | Shift F11 | Alt I W | General Shortcuts |
| Display the Find dialog box to find text in formulas or in cell values | Ctrl F | | General Shortcuts |
| Display the Find & Replace dialog box to find text in formulas or in cell values | Ctrl H | | General Shortcuts |
| Find next match (after running a Find search) | Shift F4 | | General Shortcuts |
| Find previous match (after running a Find search) | Ctrl Shift F4 | | General Shortcuts |
| Hide selected columns | Ctrl 0 | | General Shortcuts |
| Unhide selected columns | Ctrl Shift 0 | | General Shortcuts |
| Hide selected rows | Ctrl 9 | | General Shortcuts |
| Unhide selected rows | Ctrl Shift 9 | | General Shortcuts |
| Clear cell content (without moving cells or being set up to add a new formula) | Delete | | General Shortcuts |
| Clear cell content (and get set up to start a new formula) | Backspace | | General Shortcuts |
| Undo last action (can press multiple times to undo multiple last actions) | Ctrl Z | | General Shortcuts |
| Repeat last action or reverses Undo if applicable (when not editing formulas) | Ctrl Y | F4 | General Shortcuts |
| Freeze Panes to lock rows above and columns to left of selected cell, press again to unfreeze | Alt W F F | | General Shortcuts |
| Zoom in (towards selected cell(s)) | Ctrl Alt + | | General Shortcuts |
| Zoom out (away from selected cell(s)) | Ctrl Alt – | | General Shortcuts |
| Toggle Maximize/Non-minimised workbook | Ctrl F10 | | General Shortcuts |
| Open the Data Validation Dialog Box | Alt A V V | Alt D L | General Shortcuts |
| Open dropdown list for Data Validation list | Alt ↓ | | General Shortcuts |
| Open dropdown list for in any table or list to select from previously entered items in that column | Alt ↓ | | General Shortcuts |
| Circle all cells with values that don’t match the Data Validation options | Alt A V I | | General Shortcuts |
| Clear the circles on cells with values that don’t match the Data Validation options | Alt A V R | | General Shortcuts |
| Open the Data Sorting Dialog Box | Alt A S S | Alt D S | General Shortcuts |
| Sort data A to Z (low to high numbers) | Alt A S A | | General Shortcuts |
| Sort data Z to A (high to low numbers) | Alt A S D | | General Shortcuts |
| Add / Remove Toggle on filter headings with dropdowns | Alt A T | | General Shortcuts |
| Clear all applied filters | Alt A C | | General Shortcuts |
| Reapply applied filters after changes to data | Alt A Y1 | | General Shortcuts |
| Split text in selected cells to multiple columns with fixed widths or split by delimiters like spaces | Alt A E | | General Shortcuts |
| Remove Exact Duplicates from selected cells | Alt A M | | General Shortcuts |
| Apply Goal Seek (have Excel change an input value until the final calculation matches your desired value) | Alt A W G | | General Shortcuts |
| Close an open menu or dialog or formula editor | Esc | | General Shortcuts |
| Delete one character to the left while editing a formula | Backspace | | General Shortcuts |
| Delete one character to the right while editing a formula | Delete | | General Shortcuts |
| Insert new paragraph line inside the formula bar (to make a multi-line cell) | Alt Enter | | General Shortcuts |
| Set selected cells to be unchangeable once sheet is protected (using Locked setting on the Protection tab) | Ctrl 1 | | General Shortcuts |
| Protect the current worksheet from changes (according to each cells locker property), with optional password | Alt R P S | Alt T P P | General Shortcuts |
| Protect the current workbook from structural changes of sheet layouts, with optional password | Alt R P W | | General Shortcuts |
| Allow just the selected cells to be edited by someone with a password | Alt R U T | | General Shortcuts |
| Move to the next unlocked cells in a protected worksheet | Tab | | General Shortcuts |
| Insert Table or convert an existing range to a table | Ctrl T | | General Shortcuts |
| Toggle adding a total row on an existing table | Ctrl Shift T | | General Shortcuts |
| Expand / collapse the ribbon | Ctrl F1 | | Ribbon Menus |
| Select active tab and activate access keys | Alt | F10 | Ribbon Menus |
| Open File page | Alt F | | Ribbon Menus |
| Open Home tab | Alt H | | Ribbon Menus |
| Open Insert tab | Alt N | | Ribbon Menus |
| Open Page Layout tab | Alt P | | Ribbon Menus |
| Open Formulas tab | Alt M | | Ribbon Menus |
| Open Data tab | Alt A | | Ribbon Menus |
| Open Review tab | Alt R | | Ribbon Menus |
| Open View tab | Alt W | | Ribbon Menus |
| Open Developer tab (if option is showing) | Alt L | | Ribbon Menus |
| Go to Ribbon Search field | Alt Q | | Ribbon Menus |
| Move to the next right command | Tab | | Ribbon Menus |
| Move to the next left command | Shift Tab | | Ribbon Menus |
| Move to submenu when a main menu is open | ↓ | | Ribbon Menus |
| Move to the next command in open menu | ↓ | | Ribbon Menus |
| Open context menu (instead of right clicking) | Shift F10 | | Ribbon Menus |
| Open the list for selected command | ↓ | | Ribbon Menus |
| Open the menu for selected button | Alt ↓ | | Ribbon Menus |
| Show list of files which are linked to from the open file (if any) | Alt F I Q L | | Ribbon Menus |
| Show Advanced Options for display/calculation/data/proofing/saving/etc | Alt F T | | Ribbon Menus |
| Activate selected button / command / dropdown item | Space | | Ribbon Menus |
| Move to next cell down (unless modified in advanced options) | Enter | | Navigating Cells |
| Move to next cell to the right (unless modified in advanced options) | Tab | | Navigating Cells |
| Move to the previous cell | Shift Tab | | Navigating Cells |
| Move one cell up | ↑ | | Navigating Cells |
| Move one cell down | ↓ | | Navigating Cells |
| Move one cell left | ← | | Navigating Cells |
| Move one cell right | → | | Navigating Cells |
| Move one screen down in worksheet | PgDn | | Navigating Cells |
| Move one screen up in a worksheet | PgUp | | Navigating Cells |
| Move to next sheet in workbook (can be used when writing formulas) | Ctrl PgDn | | Navigating Cells |
| Move to previous sheet in workbook (can be used when writing formulas) | Ctrl PgUp | | Navigating Cells |
| Move one screen left in worksheet | Alt PgUp | | Navigating Cells |
| Move one screen right in worksheet | Alt PgDn | | Navigating Cells |
| Move to beginning of a worksheet (or leftmost cell of Freeze Pane) | Ctrl Home | | Navigating Cells |
| Move to the last cell (ever used) on a worksheet | Ctrl End | | Navigating Cells |
| Move to bottom edge of data region or next non-blank cell downwards | Ctrl ↓ | | Navigating Cells |
| Move to left edge of data region or next non-blank cell left | Ctrl ← | | Navigating Cells |
| Move to right edge of data region or next non-blank cell right | Ctrl → | | Navigating Cells |
| Move to top edge of data region or next non-blank cell upwards | Ctrl ↑ | | Navigating Cells |
| Enter/Toggle End mode | End | | Navigating Cells |
| In End Mode, move to bottom cell in column | ↓ | | Navigating Cells |
| In End Mode, move to left cell in row | ← | | Navigating Cells |
| In End Mode, move to right cell in row | → | | Navigating Cells |
| In End Mode, move to top cell in column | ↑ | | Navigating Cells |
| Open list of choices on a data validation dropdown list (select with up and down then space/enter) | Alt ↓ | | Navigating Cells |
| Show Go To Dialog (go jump to specific cells or to select special cells eg blanks, non-blanks, just formulas, just values) | Ctrl G | | Navigating Cells |
| Show Go To Dialog, Special (to select special cells eg blanks, non-blanks, just formulas, just values) | Ctrl G Alt S | | Navigating Cells |
| Move to cell in the upper left corner of visible cells | ScrLk Home ScrLk | | Navigating Cells |
| Cycle through text boxes / images | Ctrl Alt 5 | | Navigating Cells |
| Exit navigation of text boxes / images and return to cell navigation | Esc | | Navigating Cells |
| Open Format Cells dialog (the master dialog boxes for applying any formatting) | Ctrl 1 | | Formatting |
| Copy selected cells | Ctrl C | | Formatting |
| Cut selected cells | Ctrl X | | Formatting |
| Paste copied or cut selection/object at current selected location | Ctrl V | | Formatting |
| Open Paste Special dialog (eg to paste just values, formulas or formats) | Ctrl Alt V | | Formatting |
| Open Paste Special charts dialog (eg to paste chart formats to selected graph) | Ctrl Alt V | | Formatting |
| Apply Word Wrap to cell contents | Alt H W | | Formatting |
| Center align cell contents | Alt H A C | | Formatting |
| Left align cell contents | Alt H A L | | Formatting |
| Right align cell contents | Alt H A R | | Formatting |
| Choose a fill color (then use arrows and Enter to select) | Alt H H | | Formatting |
| Apply or remove bold formatting | Ctrl B | | Formatting |
| Apply or remove italic formatting | Ctrl I | | Formatting |
| Apply or remove underline | Ctrl U | | Formatting |
| Apply or remove strikethrough formatting | Ctrl 5 | | Formatting |
| Open the Insert hyperlink dialog | Ctrl K | | Formatting |
| Apply General format | Ctrl Shift ~ | | Formatting |
| Apply Number format | Ctrl Shift ! | | Formatting |
| Apply Currency format | Ctrl Shift $ | | Formatting |
| Apply Percentage format | Ctrl Shift % | | Formatting |
| Apply Scientific format | Ctrl Shift ^ | | Formatting |
| Apply Time format | Ctrl Shift @ | | Formatting |
| Apply Date format | Ctrl Shift # | | Formatting |
| Enter current (today’s) date | Ctrl ; | | Formatting |
| Open Conditional Formatting Manager Dialog Box | Alt O D | | Formatting |
| Enter current time of pressing these buttons | Ctrl Shift ; | | Formatting |
| Toggle formulas on and off | Ctrl ` (just left of the “1” button) | | Formatting |
| Open Delete dialog to delete cells (automatically deletes row or column if already selected) | Ctrl – (minus sign) | | Formatting |
| Open Insert dialog to insert cells (automatically inserts row or column if already selected) | Ctrl Shift – (minus sign) | | Formatting |
| Format fonts in Format Cells dialog | Ctrl Shift F | | Formatting |
| Apply single outline border to selected cells | Ctrl Shift & | | Formatting |
| Add border bottom in Format Cells | Alt B | | Formatting |
| Add border downard diagonal in Format Cells | Alt D | | Formatting |
| Add border horizontal interior in Format Cells | Alt H | | Formatting |
| Add border left in Format Cells | Alt L | | Formatting |
| Add border right in Format Cells | Alt R | | Formatting |
| Add border top in Format Cells | Alt T | | Formatting |
| Add border upward diagonal in Format Cells | Alt U | | Formatting |
| Add border vertical interior in Format Cells | Alt V | | Formatting |
| Insert threaded comment | Ctrl Shift F2 | | Formatting |
| Open and reply to threaded comment | Ctrl Shift F2 | | Formatting |
| Insert Table | Ctrl T | | Formatting |
| Insert a note | Shift F2 | | Formatting |
| Open and edit a note | Shift F2 | | Formatting |
| Show or hide objects | Ctrl 6 | | Formatting |
| Show or hide outline symbols | Ctrl 8 | | Formatting |
| Fill down from cell above | Ctrl D | | Formatting |
| Display the Quick Analysis options | Ctrl Q | | Formatting |
| Fill right from cell left | Ctrl R | | Formatting |
| Copy formula from above cell | Ctrl ‘ | | Formatting |
| Remove outline border to selected cells | Ctrl Shift _ | | Formatting |
| Open Insert dialog to insert cells | Ctrl Shift + | | Formatting |
| Check spelling | F7 | | Formatting |
| Extend cell selection one cell up | Shift ↑ | | Selecting Cells |
| Extend cell selection one cell down | Shift ↓ | | Selecting Cells |
| Extend cell selection one cell left | Shift ← | | Selecting Cells |
| Extend cell selection one cell right | Shift → | | Selecting Cells |
| Extend cell selection one screen down in worksheet | Shift PgDn | | Selecting Cells |
| Extend cell selection one screen up in a worksheet | Shift PgUp | | Selecting Cells |
| Extend cell selection one screen left in worksheet | Alt Shift PgUp | | Selecting Cells |
| Extend cell selection one screen right in worksheet | Alt Shift PgDn | | Selecting Cells |
| Extend sheet selection one sheet to the right (for multiple sheet selection) ie current and next worksheet | Ctrl Shift PgDn | | Selecting Cells |
| Extend sheet selection one sheet to the left (for multiple sheet selection) ie current and previous worksheet | Ctrl Shift PgUp | | Selecting Cells |
| Extend selection of cells to beginning of a worksheet (or leftmost cell of Freeze Pane) | Ctrl Shift Home | | Selecting Cells |
| Extend selection of cells to last used cell | Ctrl Shift End | | Selecting Cells |
| Fill selected cell range with the current entry (and don’t move to another cell) | Ctrl Enter | | Selecting Cells |
| Complete cell entry and select above cell | Shift Enter | | Selecting Cells |
| Extend selection downwards toggling between the next empty cell, or to the next non-empty cell | Ctrl Shift ↓ | | Selecting Cells |
| Extend selection leftwards toggling between the next empty cell, or to the next non-empty cell | Ctrl Shift ← | | Selecting Cells |
| Extend selection rightwards toggling between the next empty cell, or to the next non-empty cell | Ctrl Shift → | | Selecting Cells |
| Extend selection upwards toggling between the next empty cell, or to the next non-empty cell | Ctrl Shift ↑ | | Selecting Cells |
| Extend selection from the current cell in a continuous rectangle to the cell clicked on with a mouse | Shift Click | | Selecting Cells |
| Extend selection with a non-joined rectangle of the cells selected with a mouse | Ctrl Click | | Selecting Cells |
| Select all objects when an object is selected | Ctrl Shift Space | Cntrl A | Selecting Cells |
| Select current array | Ctrl / | | Selecting Cells |
| Select current region around the cell | Ctrl Shift * | Cntrl A | Selecting Cells |
| Select entire column | Ctrl Space | | Selecting Cells |
| Select entire row | Shift Space | | Selecting Cells |
| Select current block of data (press twice to select entire worksheet) or entire worksheet if not | Ctrl A | | Selecting Cells |
| Select first command on dropdown menu | Home | | Selecting Cells |
| Select all visible cells | Alt ; | | Selecting Cells |
| Start a new line | Alt Enter | | Selecting Cells |
| Toggle add to selection mode | Shift F8 | | Selecting Cells |
| Toggle extend mode | F8 | | Selecting Cells |
| Undo last action | Ctrl Z | | Selecting Cells |
| Edit active cell | F2 | | Writing Formulas |
| Toggle Formula Edit Mode between moving round the formula for manual editing and cell selection within the formula bar | F2 | | Writing Formulas |
| Toggle absolute or relative references (A1 -> $A$1 -> A$1 -> $A1 -> A1) to formula at curser position. Applies to the whole immediately selected range when in Formula bar’s Selection Edit Mode. | F4 | | Writing Formulas |
| Complete entry in formula bar | Enter | | Writing Formulas |
| Complete entry in formula bar and apply to every selected cell | Ctrl Enter | | Writing Formulas |
| Autosum selection of cells | Alt = | | Writing Formulas |
| Cancel entry in formula bar | Esc | | Writing Formulas |
| Check your formula (highlight a section of the formula to calculate just that part) when in the formula bar | F9 | | Writing Formulas |
| Show the Insert function Dialog box (inside the formula bar or from the selected cell) | Shift F3 | | Writing Formulas |
| Paste a named range name into a formula | F3 | | Writing Formulas |
| Open Name Manager Dialog box | Ctrl F3 | | Writing Formulas |
| Select highlighted formula including the first bracket when manually typing in formula | Tab | | Writing Formulas |
| Select cells where the formulas don’t match the one in the selected cell in the current column | Ctrl Shift | (‘upper case’ backslash) | | Writing Formulas |
| Select cells where the formulas don’t match the one in the selected cell in the current row | Ctrl Shift \ (backslash) | | Writing Formulas |
| Calculate / recalculate active worksheet | Shift F9 | | Writing Formulas |
| Force Calculate all worksheets | F9 | | Writing Formulas |
| Copy the value from the cell above (doesn’t copy the formula) | Ctrl Shift “ | | Writing Formulas |
| Display message for error checking button | Alt Shift F10 | | Writing Formulas |
| Expand or collapse the height of the formula bar | Ctrl Shift U | | Writing Formulas |
| Input array formula | Ctrl Shift Enter | | Writing Formulas |
| Invoke Flash Fill (where Excel guesses what you’re trying to fill in) | Ctrl E | | Writing Formulas |
| Move to end of text when in the formula bar | Ctrl End | | Writing Formulas |
| Select text in formula bar to end | Ctrl Shift End | | Writing Formulas |
| Open Excel Help | F1 | | Function Keys |
| Edit the active cell (also alternates between editing mode within the formula) | F2 | | Function Keys |
| Open Paste Name dialog (to add a Named Range variable to a formula) | F3 | | Function Keys |
| Open Go To dialog | F5 | Cntrl G | Function Keys |
| Switch panes | F6 | | Function Keys |
| Open Spelling dialog | F7 | | Function Keys |
| Toggle extend mode (for making multiple cell selections using the keyboard) | F8 | | Function Keys |
| Calculate all worksheets | F9 | | Function Keys |
| Toggle key tips (ribbon menu shortcut keys) | F10 | | Function Keys |
| Create chart of the selected range on a new sheet | F11 | | Function Keys |
| Create chart of the selected range on the same sheet | Alt F1 | | Function Keys |
| Open Save As dialog | F12 | | Function Keys |
| Show or hide ribbon | Ctrl F1 | | Function Keys |
| Open print preview | Ctrl F2 | | Function Keys |
| Open Name Manager Dialog | Ctrl F3 | | Function Keys |
| Close workbook window | Ctrl F4 | | Function Keys |
| Close Excel | Alt F4 | | Function Keys |
| Restore window size of workbook | Ctrl F5 | | Function Keys |
| Switch to next workbook | Ctrl F6 | | Function Keys |
| Switch to previous workbook | Ctrl Shift F6 | | Function Keys |
| Perform moving of window | Ctrl F7 | | Function Keys |
| Perform resizing of window | Ctrl F8 | | Function Keys |
| Open Macro dialog (to run a macro or assign a shortcut key to one) | Alt F8 | | Function Keys |
| Minimize workbook | Ctrl F9 | | Function Keys |
| Calculates active worksheet | Shift F9 | | Function Keys |
| Force calculate all worksheets | Ctrl Alt F9 | | Function Keys |
| Display full “!” option box when selecting a cell with an error | Alt Shift F10 | | Function Keys |
| Display full Series filling option box after having dragged a fill handle | Alt Shift F10 | | Function Keys |
| Open VBA Editor | Alt F11 | | Function Keys |
| Drag and copy cell formulas/values using the fill handle | Drag | | Drag and Drop |
| Drag and cut a cell to another place using the cell outline (overwriting the new location) | Drag Cell Outline | | Drag and Drop |
| Drag and insert cell outline (re-organises column/row to shuffle them around into the new order) | Shift Drag Cell Outline | | Drag and Drop |
| Drag and insert copy cell outline (re-organises column/row to shuffle them around into the new order) | Ctrl Shift Drag Cell Outline | | Drag and Drop |
| Drag cell selection to another worksheet using cell outline | Alt Drag Cell Outline | | Drag and Drop |
| Drag and copy a cell using the fill handle to fill in a series | Ctrl Drag | | Drag and Drop |
| Drag worksheet tab to move the worksheet | Drag Tab | | Drag and Drop |
| Drag worksheet tab to duplicate the worksheet | Ctrl Drag Tab | | Drag and Drop |
| Create Pivot Table | Alt N V | Alt N V T (old Excel) | Pivot Tables and Charts |
| Refresh Pivot Table with the selected cell on the Pivot Table | Alt F5 | | Pivot Tables and Charts |
| Refresh all Pivot Tables in workbook | Ctrl Alt F5 | | Pivot Tables and Charts |
| Select whole Pivot Table including filters | Alt J T W T | | Pivot Tables and Charts |
| Select whole Pivot Table excluding filters with any cell in the main pivot table selected | Ctrl A | | Pivot Tables and Charts |
| Group selected items | Alt Shift → | Alt A G G | Pivot Tables and Charts |
| Ungroup selected items | Alt Shift ← | Alt A G U | Pivot Tables and Charts |
| Hide selected item or field | Ctrl – | | Pivot Tables and Charts |
| Open Calculated Field/Item dialog depending which field is selected | Shift Ctrl = | | Pivot Tables and Charts |
| Open field list for cell (when on the cells with dropdowns) | Alt ↓ | | Pivot Tables and Charts |
| Open old PivotTable Wizard | Alt D P | | Pivot Tables and Charts |
| Select entire table | Ctrl Shift * | | Pivot Tables and Charts |
| Select first item in Field List | Home | | Pivot Tables and Charts |
| Select last item in Field List | End | | Pivot Tables and Charts |
| Select next item in Field List | ↓ | | Pivot Tables and Charts |
| Select previous item in Field List | ↑ | | Pivot Tables and Charts |
| Select or clear a check box in the Field List | Space | | Pivot Tables and Charts |
| Add Selected Item in Field List to one of the field areas | Right Click then arrows and Enter | | Pivot Tables and Charts |
| Change Field Settings (in Field List or selected cell on Pivot Table | Right Click then Field Settings | | Pivot Tables and Charts |
| Expand Field (when pointing to heading) instead of using the + button | Shift and scroll Up with mouse wheel | | Pivot Tables and Charts |
| Collapse Field (when pointing to heading) instead of using the – button | Shift and scroll Down with mouse wheel | | Pivot Tables and Charts |
| Insert Slicer (with Pivot Table selected) | Alt JT SF | | Pivot Tables and Charts |
| Change the Source Data used to create the Pivot Table | Alt JT ID | | Pivot Tables and Charts |
| Create linked Pivot Chart (while Pivot Table selected) on new worksheet | F11 | Alt JT C | Pivot Tables and Charts |
| Create linked Pivot Chart (while Pivot Table selected) on same worksheet | Alt F1 | | Pivot Tables and Charts |
| Clear slicer filter | Alt C | | Pivot Tables and Charts |
| Toggle formulas on and off (Show Formulas) | Ctrl ` (just left of the “1” button) | Alt M H | Auditing Formulas |
| Select cells where the formulas don’t match the one in the selected cell in the current column | Ctrl Shift | (‘upper case’ backslash) | | Auditing Formulas |
| Select cells where the formulas don’t match the one in the selected cell in the current row | Ctrl Shift \ (backslash) | | Auditing Formulas |
| Trace Precedents = select cells on the same sheet whose values are used in the formula of selected cell | Ctrl [ | | Auditing Formulas |
| Trace Dependents = select cells on the same sheet whose formulas use the selected cell in their own calculations | Ctrl ] | | Auditing Formulas |
| Trace Precedents = show arrows to find cells whose values are used in the formula of selected cell | Alt M P | | Auditing Formulas |
| Trace Dependents = show arrows to find cells whose formulas use the selected cell in their own calculations | Alt M D | | Auditing Formulas |
| Remove Precedent/Dependent arrows | Alt M A | | Auditing Formulas |
| Evaulate Formula (works through the formula step by step showing the results of the calculation at all stages) | Alt M V | | Auditing Formulas |
| Circular Reference Checker – find formulas that link to each other in a never ending circular loop | Alt M K C | | Auditing Formulas |
| Check for Errors in the file/sheet | Alt M K K | | Auditing Formulas |
| Trace Errors – show arrows to find cells causing the errors | Alt M K E | | Auditing Formulas |
| Open Visual Basic For Applications (VBA) Editor | Alt F11 | | VBA and Macros |
| Open Developer tab (if option is showing) | Alt L | | VBA and Macros |
| Close VBA Editor | Alt Q | | VBA and Macros |
| Record/Stop Recording a macro (with developer tab showing) | Alt L R | Alt T M R | VBA and Macros |
| Toggle between using Relative References when Recording a macro (with developer tab showing) | Alt L U | | VBA and Macros |
| Run current subroutine | F5 | | VBA and Macros |
| Step through code | F8 | | VBA and Macros |
| Toggle Breakpoint (to stop at row of code for debugging) | F9 | | VBA and Macros |
| Open Intellisense Dropdown to view object properties | Ctrl J | | VBA and Macros |
| Select from dropdown of object properties (Intellisense) | ↓ | ↑ | VBA and Macros |
| Choose selected dropdown object property (Intellisense) | Space | | VBA and Macros |
| Autocomplete code | Ctrl Space | | VBA and Macros |
| Stop code (while running and if possible) | Ctrl Break | | VBA and Macros |
| View “Immediate” Window for running test code and viewing outputs | Ctrl G | | VBA and Macros |
| Go to Code window | F7 | | VBA and Macros |
| Go to Project Explorer Window | Ctrl R | | VBA and Macros |
| Go to Properties Window | F4 | | VBA and Macros |
| Delete line of code | Ctrl Y | | VBA and Macros |
| Redo last action | Alt E R | | VBA and Macros |
| Compile VBA project to check for errors | Alt D L | | VBA and Macros |
| View/Hide Toolbox (when on a Form) | Alt V X | | VBA and Macros |
| View VBA Project Properties (to add password to protect and hide code) | Alt T E | | VBA and Macros |
| Cancel process or close dialog | Ctrl Esc | | Power Pivots |
| Copy selected data | Ctrl C | | Power Pivots |
| Delete table | Ctrl D | | Power Pivots |
| Move table | Ctrl M | | Power Pivots |
| Move to first cell in table | Ctrl Home | | Power Pivots |
| Move to first cell of row | Ctrl ← | | Power Pivots |
| Move to last cell in table | Ctrl End | | Power Pivots |
| Move to last cell of row | Ctrl → | | Power Pivots |
| Move to next table | Ctrl PgDn | | Power Pivots |
| Move to previous table | Ctrl PgUp | | Power Pivots |
| Move to the first cell of column | Ctrl ↑ | | Power Pivots |
| Move to the last cell of column | Ctrl ↓ | | Power Pivots |
| Open AutoFilter Menu dialog | Alt ↓ | | Power Pivots |
| Select cells to first column cell | Shift PgDn | | Power Pivots |
| Select cells to first row cell | Shift Home | | Power Pivots |
| Select cells to last column cell | Shift PgUp | | Power Pivots |
| Select cells to last row cell | Shift End | | Power Pivots |
| Select current column | Ctrl Space | | Power Pivots |
| Select current row | Shift Space | | Power Pivots |
| Select entire table | Ctrl A | | Power Pivots |
| Activate Selection pane | F6 | | Power BI |
| Collapse a table | ← | | Power BI |
| Comment lines in DAX | Ctrl / | | Power BI |
| Comment multiple lines in DAX | Ctrl K C | | Power BI |
| Copy line down in DAX | Alt Shift ↓ | | Power BI |
| Copy line up in DAX | Alt Shift ↑ | | Power BI |
| Create line break with auto-indent | Shift Enter | | Power BI |
| Delete a word in DAX | Ctrl Delete | | Power BI |
| Delete multiple lines in DAX | Ctrl Shift K | | Power BI |
| Enter lines of code in DAX | Ctrl Alt ↓ | | Power BI |
| Enter lines of code in DAX | Ctrl Alt ↑ | | Power BI |
| Expand a table | → | | Power BI |
| Find the highlighted word | Ctrl D | | Power BI |
| Go to line number in DAX | Ctrl G | | Power BI |
| Indent line in DAX | Ctrl ] | | Power BI |
| Insert cursor in DAX | Alt Click | | Power BI |
| Insert line above in DAX | Ctrl Shift Enter | | Power BI |
| Insert line below in DAX | Ctrl Enter | | Power BI |
| Interact with a Slicer | Ctrl → | | Power BI |
| Jump to matching bracket in DAX | Ctrl Shift \ | | Power BI |
| Move an object down in layering | Ctrl Shift B | | Power BI |
| Move an object up in layering | Ctrl Shift F | | Power BI |
| Move focus backward in section | Shift Tab | | Power BI |
| Move focus between sections | Ctrl F6 | | Power BI |
| Move focus forward in section | Tab | | Power BI |
| Move focus to Visual menu | Alt Shift F10 | | Power BI |
| Move line down in DAX | Alt ↓ | | Power BI |
| Move line up in DAX | Alt ↑ | | Power BI |
| Multi-select | Ctrl Shift | | Power BI |
| Multi-select objects | Ctrl Space | | Power BI |
| New line in DAX | Alt Enter | | Power BI |
| Open context menu (instead of right clicking) | Shift F10 | | Power BI |
| Outdent line in DAX | Ctrl [ | | Power BI |
| Restart Intellisense | Alt I | | Power BI |
| Select all occurrences of current selection | Ctrl Shift L | Alt A T | Power BI |
| Select all occurrences of current word | Ctrl F2 | | Power BI |
| Select an object | Space | | Power BI |
| Select current line in DAX | Ctrl I | | Power BI |
| Select nearest word in DAX | Alt Shift → | | Power BI |
| Select object | Enter | | Power BI |
| Show data | Alt Shift F11 | | Power BI |
| Show keyboard shortcuts | Shift ? | | Power BI |
| Toggle commenting of code | Alt Shift A | | Power BI |
| Toggle commenting of lines that has a word | Ctrl + | | Power BI |
| Toggle object visibility | Ctrl Shift S | | Power BI |
| Uncomment lines in DAX | Ctrl \ | | Power BI |
| Uncomment multiple lines in DAX | Ctrl K U | | Power BI |
| Activate the Quick Access Toolbar Item 1 (if one exists) | Alt 1 | | Extras |
| Activate the Quick Access Toolbar Item 2 (if one exists) | Alt 2 | | Extras |
| Activate the Quick Access Toolbar Item 3 (if one exists) | Alt 3 | | Extras |
| Activate the Quick Access Toolbar Item 4 (if one exists) | Alt 4 | | Extras |
| Activate the Quick Access Toolbar Item 5 (if one exists) | Alt 5 | | Extras |
| Activate the Quick Access Toolbar Item 6 (if one exists) | Alt 6 | | Extras |
| Activate the Quick Access Toolbar Item 7 (if one exists) | Alt 7 | | Extras |
| Activate the Quick Access Toolbar Item 8 (if one exists) | Alt 8 | | Extras |
| Activate the Quick Access Toolbar Item 9 (if one exists) | Alt 9 | | Extras |
| Delete to the end of line while editing a formula | Ctrl Delete | | Extras |
| Display control menu for Excel window | Alt Space | | Extras |
| Select or clear a check box | Space | | Extras |
| Selects the entire worksheet / region | Ctrl Shift Space | Ctrl A | Extras |
| Switch to next tab in a dialog box | Ctrl Tab | | Extras |
| Switch to previous tab in a dialog box | Ctrl shift Tab | | Extras |
| Switch to Normal view | Alt W L | | Extras |
| Switch to Page Break Preview view | Alt W I | | Extras |
| Add Page Break while in Page Break Preview view | Right-Click Alt B | | Extras |
| Switch to Page Layout view | Alt W P | | Extras |
| Open Print Options Dialog Box | Alt P I | | Extras |
| Set Print Area to current selection | Alt P R S | | Extras |
| Toggle hiding and showing Excel grid lines | Alt W V G | | Extras |
| Toggle hiding and showing the Formula Bar | Alt W V F | | Extras |
| Toggle hiding and showing Excel Headings | Alt W V H | | Extras |
| Toggle full screen | Ctrl Shift F1 | | Extras |
