Excel Spreadsheet Resources – 397 Categorised Excel Shortcut keys for Windows

Shortcut Description of Excel Shortcut KeysShortcut KeysAlternative ShortcutCategory
Create a New workbookCtrl NGeneral Shortcuts
Open an existing workbookCtrl OGeneral Shortcuts
Open a recent existing workbookAlt F RGeneral Shortcuts
Save current workbookCtrl SGeneral Shortcuts
Close current workbookCtrl WGeneral Shortcuts
Print (Preview)Ctrl PGeneral Shortcuts
Insert new worksheetShift F11Alt I WGeneral Shortcuts
Display the Find dialog box to find text in formulas or in cell valuesCtrl FGeneral Shortcuts
Display the Find & Replace dialog box to find text in formulas or in cell valuesCtrl HGeneral Shortcuts
Find next match (after running a Find search)Shift F4General Shortcuts
Find previous match (after running a Find search)Ctrl Shift F4General Shortcuts
Hide selected columnsCtrl 0General Shortcuts
Unhide selected columnsCtrl Shift 0General Shortcuts
Hide selected rowsCtrl 9General Shortcuts
Unhide selected rowsCtrl Shift 9General Shortcuts
Clear cell content (without moving cells or being set up to add a new formula)DeleteGeneral Shortcuts
Clear cell content (and get set up to start a new formula)BackspaceGeneral Shortcuts
Undo last action (can press multiple times to undo multiple last actions)Ctrl ZGeneral Shortcuts
Repeat last action or reverses Undo if applicable (when not editing formulas)Ctrl YF4General Shortcuts
Freeze Panes to lock rows above and columns to left of selected cell, press again to unfreezeAlt W F FGeneral 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 workbookCtrl F10General Shortcuts
Open the Data Validation Dialog BoxAlt A V VAlt D LGeneral Shortcuts
Open dropdown list for Data Validation listAlt ↓General Shortcuts
Open dropdown list for in any table or list to select from previously entered items in that columnAlt ↓General Shortcuts
Circle all cells with values that don’t match the Data Validation optionsAlt A V IGeneral Shortcuts
Clear the circles on cells with values that don’t match the Data Validation optionsAlt A V RGeneral Shortcuts
Open the Data Sorting Dialog BoxAlt A S SAlt D SGeneral Shortcuts
Sort data A to Z (low to high numbers)Alt A S AGeneral Shortcuts
Sort data Z to A (high to low numbers)Alt A S DGeneral Shortcuts
Add / Remove Toggle on filter headings with dropdownsAlt A TGeneral Shortcuts
Clear all applied filtersAlt A CGeneral Shortcuts
Reapply applied filters after changes to dataAlt A Y1General Shortcuts
Split text in selected cells to multiple columns with fixed widths or split by delimiters like spacesAlt A EGeneral Shortcuts
Remove Exact Duplicates from selected cellsAlt A MGeneral Shortcuts
Apply Goal Seek (have Excel change an input value until the final calculation matches your desired value)Alt A W GGeneral Shortcuts
Close an open menu or dialog or formula editorEscGeneral Shortcuts
Delete one character to the left while editing a formulaBackspaceGeneral Shortcuts
Delete one character to the right while editing a formulaDeleteGeneral Shortcuts
Insert new paragraph line inside the formula bar (to make a multi-line cell)Alt EnterGeneral Shortcuts
Set selected cells to be unchangeable once sheet is protected (using Locked setting on the Protection tab)Ctrl 1General Shortcuts
Protect the current worksheet from changes (according to each cells locker property), with optional passwordAlt R P SAlt T P PGeneral Shortcuts
Protect the current workbook from structural changes of sheet layouts, with optional passwordAlt R P WGeneral Shortcuts
Allow just the selected cells to be edited by someone with a passwordAlt R U TGeneral Shortcuts
Move to the next unlocked cells in a protected worksheetTabGeneral Shortcuts
Insert Table or convert an existing range to a tableCtrl TGeneral Shortcuts
Toggle adding a total row on an existing tableCtrl Shift TGeneral Shortcuts
Expand / collapse the ribbonCtrl F1Ribbon Menus
Select active tab and activate access keysAltF10Ribbon Menus
Open File pageAlt FRibbon Menus
Open Home tabAlt HRibbon Menus
Open Insert tabAlt NRibbon Menus
Open Page Layout tabAlt PRibbon Menus
Open Formulas tabAlt MRibbon Menus
Open Data tabAlt ARibbon Menus
Open Review tabAlt RRibbon Menus
Open View tabAlt WRibbon Menus
Open Developer tab (if option is showing)Alt LRibbon Menus
Go to Ribbon Search fieldAlt QRibbon Menus
Move to the next right commandTabRibbon Menus
Move to the next left commandShift TabRibbon Menus
Move to submenu when a main menu is openRibbon Menus
Move to the next command in open menuRibbon Menus
Open context menu (instead of right clicking)Shift F10Ribbon Menus
Open the list for selected commandRibbon Menus
Open the menu for selected buttonAlt ↓Ribbon Menus
Show list of files which are linked to from the open file (if any)Alt F I Q LRibbon Menus
Show Advanced Options for display/calculation/data/proofing/saving/etcAlt F TRibbon Menus
Activate selected button / command / dropdown itemSpaceRibbon Menus
Move to next cell down (unless modified in advanced options)EnterNavigating Cells
Move to next cell to the right (unless modified in advanced options)TabNavigating Cells
Move to the previous cellShift TabNavigating Cells
Move one cell upNavigating Cells
Move one cell downNavigating Cells
Move one cell leftNavigating Cells
Move one cell rightNavigating Cells
Move one screen down in worksheetPgDnNavigating Cells
Move one screen up in a worksheetPgUpNavigating Cells
Move to next sheet in workbook (can be used when writing formulas)Ctrl PgDnNavigating Cells
Move to previous sheet in workbook (can be used when writing formulas)Ctrl PgUpNavigating Cells
Move one screen left in worksheetAlt PgUpNavigating Cells
Move one screen right in worksheetAlt PgDnNavigating Cells
Move to beginning of a worksheet (or leftmost cell of Freeze Pane)Ctrl HomeNavigating Cells
Move to the last cell (ever used) on a worksheetCtrl EndNavigating Cells
Move to bottom edge of data region or next non-blank cell downwardsCtrl ↓Navigating Cells
Move to left edge of data region or next non-blank cell leftCtrl ←Navigating Cells
Move to right edge of data region or next non-blank cell rightCtrl →Navigating Cells
Move to top edge of data region or next non-blank cell upwardsCtrl ↑Navigating Cells
Enter/Toggle End modeEndNavigating Cells
In End Mode, move to bottom cell in columnNavigating Cells
In End Mode, move to left cell in rowNavigating Cells
In End Mode, move to right cell in rowNavigating Cells
In End Mode, move to top cell in columnNavigating 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 GNavigating Cells
Show Go To Dialog, Special (to select special cells eg blanks, non-blanks, just formulas, just values)Ctrl G Alt SNavigating Cells
Move to cell in the upper left corner of visible cellsScrLk Home ScrLkNavigating Cells
Cycle through text boxes / imagesCtrl Alt 5Navigating Cells
Exit navigation of text boxes / images and return to cell navigationEscNavigating Cells
Open Format Cells dialog (the master dialog boxes for applying any formatting)Ctrl 1Formatting
Copy selected cellsCtrl CFormatting
Cut selected cellsCtrl XFormatting
Paste copied or cut selection/object at current selected locationCtrl VFormatting
Open Paste Special dialog (eg to paste just values, formulas or formats)Ctrl Alt VFormatting
Open Paste Special charts dialog (eg to paste chart formats to selected graph)Ctrl Alt VFormatting
Apply Word Wrap to cell contentsAlt H WFormatting
Center align cell contentsAlt H A CFormatting
Left align cell contentsAlt H A LFormatting
Right align cell contentsAlt H A RFormatting
Choose a fill color (then use arrows and Enter to select)Alt H HFormatting
Apply or remove bold formattingCtrl BFormatting
Apply or remove italic formattingCtrl IFormatting
Apply or remove underlineCtrl UFormatting
Apply or remove strikethrough formattingCtrl 5Formatting
Open the Insert hyperlink dialogCtrl KFormatting
Apply General formatCtrl Shift ~Formatting
Apply Number formatCtrl Shift !Formatting
Apply Currency formatCtrl Shift $Formatting
Apply Percentage formatCtrl Shift %Formatting
Apply Scientific formatCtrl Shift ^Formatting
Apply Time formatCtrl Shift @Formatting
Apply Date formatCtrl Shift #Formatting
Enter current (today’s) dateCtrl ;Formatting
Open Conditional Formatting Manager Dialog BoxAlt O DFormatting
Enter current time of pressing these buttonsCtrl Shift ;Formatting
Toggle formulas on and offCtrl ` (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 dialogCtrl Shift FFormatting
Apply single outline border to selected cellsCtrl Shift &Formatting
Add border bottom in Format CellsAlt BFormatting
Add border downard diagonal in Format CellsAlt DFormatting
Add border horizontal interior in Format CellsAlt HFormatting
Add border left in Format CellsAlt LFormatting
Add border right in Format CellsAlt RFormatting
Add border top in Format CellsAlt TFormatting
Add border upward diagonal in Format CellsAlt UFormatting
Add border vertical interior in Format CellsAlt VFormatting
Insert threaded commentCtrl Shift F2Formatting
Open and reply to threaded commentCtrl Shift F2Formatting
Insert TableCtrl TFormatting
Insert a noteShift F2Formatting
Open and edit a noteShift F2Formatting
Show or hide objectsCtrl 6Formatting
Show or hide outline symbolsCtrl 8Formatting
Fill down from cell aboveCtrl DFormatting
Display the Quick Analysis optionsCtrl QFormatting
Fill right from cell leftCtrl RFormatting
Copy formula from above cellCtrl ‘Formatting
Remove outline border to selected cellsCtrl Shift _Formatting
Open Insert dialog to insert cellsCtrl Shift +Formatting
Check spellingF7Formatting
Extend cell selection one cell upShift ↑Selecting Cells
Extend cell selection one cell downShift ↓Selecting Cells
Extend cell selection one cell leftShift ←Selecting Cells
Extend cell selection one cell rightShift →Selecting Cells
Extend cell selection one screen down in worksheetShift PgDnSelecting Cells
Extend cell selection one screen up in a worksheetShift PgUpSelecting Cells
Extend cell selection one screen left in worksheetAlt Shift PgUpSelecting Cells
Extend cell selection one screen right in worksheetAlt Shift PgDnSelecting Cells
Extend sheet selection one sheet to the right (for multiple sheet selection) ie current and next worksheetCtrl Shift PgDnSelecting Cells
Extend sheet selection one sheet to the left (for multiple sheet selection) ie current and previous worksheetCtrl Shift PgUpSelecting Cells
Extend selection of cells to beginning of a worksheet (or leftmost cell of Freeze Pane)Ctrl Shift HomeSelecting Cells
Extend selection of cells to last used cellCtrl Shift EndSelecting Cells
Fill selected cell range with the current entry (and don’t move to another cell)Ctrl EnterSelecting Cells
Complete cell entry and select above cellShift EnterSelecting Cells
Extend selection downwards toggling between the next empty cell, or to the next non-empty cellCtrl Shift ↓Selecting Cells
Extend selection leftwards toggling between the next empty cell, or to the next non-empty cellCtrl Shift ←Selecting Cells
Extend selection rightwards toggling between the next empty cell, or to the next non-empty cellCtrl Shift →Selecting Cells
Extend selection upwards toggling between the next empty cell, or to the next non-empty cellCtrl Shift ↑Selecting Cells
Extend selection from the current cell in a continuous rectangle to the cell clicked on with a mouseShift ClickSelecting Cells
Extend selection with a non-joined rectangle of the cells selected with a mouseCtrl ClickSelecting Cells
Select all objects when an object is selectedCtrl Shift SpaceCntrl ASelecting Cells
Select current arrayCtrl /Selecting Cells
Select current region around the cellCtrl Shift *Cntrl ASelecting Cells
Select entire columnCtrl SpaceSelecting Cells
Select entire rowShift SpaceSelecting Cells
Select current block of data (press twice to select entire worksheet) or entire worksheet if notCtrl ASelecting Cells
Select first command on dropdown menuHomeSelecting Cells
Select all visible cellsAlt ;Selecting Cells
Start a new lineAlt EnterSelecting Cells
Toggle add to selection modeShift F8Selecting Cells
Toggle extend modeF8Selecting Cells
Undo last actionCtrl ZSelecting Cells
Edit active cellF2Writing Formulas
Toggle Formula Edit Mode between moving round the formula for manual editing and cell selection within the formula barF2Writing 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.F4Writing Formulas
Complete entry in formula barEnterWriting Formulas
Complete entry in formula bar and apply to every selected cellCtrl EnterWriting Formulas
Autosum selection of cellsAlt =Writing Formulas
Cancel entry in formula barEscWriting Formulas
Check your formula (highlight a section of the formula to calculate just that part) when in the formula barF9Writing Formulas
Show the Insert function Dialog box (inside the formula bar or from the selected cell)Shift F3Writing Formulas
Paste a named range name into a formulaF3Writing Formulas
Open Name Manager Dialog boxCtrl F3Writing Formulas
Select highlighted formula including the first bracket when manually typing in formulaTabWriting Formulas
Select cells where the formulas don’t match the one in the selected cell in the current columnCtrl Shift | (‘upper case’ backslash)Writing Formulas
Select cells where the formulas don’t match the one in the selected cell in the current rowCtrl Shift \ (backslash)Writing Formulas
Calculate / recalculate active worksheetShift F9Writing Formulas
Force Calculate all worksheetsF9Writing Formulas
Copy the value from the cell above (doesn’t copy the formula)Ctrl Shift “Writing Formulas
Display message for error checking buttonAlt Shift F10Writing Formulas
Expand or collapse the height of the formula bar Ctrl Shift UWriting Formulas
Input array formulaCtrl Shift EnterWriting Formulas
Invoke Flash Fill (where Excel guesses what you’re trying to fill in)Ctrl EWriting Formulas
Move to end of text when in the formula barCtrl EndWriting Formulas
Select text in formula bar to endCtrl Shift EndWriting Formulas
Open Excel HelpF1Function Keys
Edit the active cell (also alternates between editing mode within the formula)F2Function Keys
Open Paste Name dialog (to add a Named Range variable to a formula)F3Function Keys
Open Go To dialogF5Cntrl GFunction Keys
Switch panesF6Function Keys
Open Spelling dialogF7Function Keys
Toggle extend mode (for making multiple cell selections using the keyboard)F8Function Keys
Calculate all worksheetsF9Function Keys
Toggle key tips (ribbon menu shortcut keys)F10Function Keys
Create chart of the selected range on a new sheetF11Function Keys
Create chart of the selected range on the same sheetAlt  F1Function Keys
Open Save As dialogF12Function Keys
Show or hide ribbonCtrl F1Function Keys
Open print previewCtrl F2Function Keys
Open Name Manager DialogCtrl F3Function Keys
Close workbook windowCtrl F4Function Keys
Close ExcelAlt F4Function Keys
Restore window size of workbookCtrl F5Function Keys
Switch to next workbookCtrl F6Function Keys
Switch to previous workbookCtrl Shift F6Function Keys
Perform moving of windowCtrl F7Function Keys
Perform resizing of windowCtrl F8Function Keys
Open Macro dialog (to run a macro or assign a shortcut key to one)Alt F8Function Keys
Minimize workbookCtrl F9Function Keys
Calculates active worksheetShift F9Function Keys
Force calculate all worksheetsCtrl Alt F9Function Keys
Display full “!” option box when selecting a cell with an errorAlt Shift F10Function Keys
Display full Series filling option box after having dragged a fill handleAlt Shift F10Function Keys
Open VBA EditorAlt F11Function Keys
Drag and copy cell formulas/values using the fill handleDragDrag and Drop
Drag and cut a cell to another place using the cell outline (overwriting the new location)Drag Cell OutlineDrag and Drop
Drag and insert cell outline (re-organises column/row to shuffle them around into the new order)Shift Drag Cell OutlineDrag and Drop
Drag and insert copy cell outline (re-organises column/row to shuffle them around into the new order)Ctrl Shift Drag Cell OutlineDrag and Drop
Drag cell selection to another worksheet using cell outlineAlt Drag Cell OutlineDrag and Drop
Drag and copy a cell using the fill handle to fill in a seriesCtrl DragDrag and Drop
Drag worksheet tab to move the worksheetDrag TabDrag and Drop
Drag worksheet tab to duplicate the worksheetCtrl Drag TabDrag and Drop
Create Pivot TableAlt N VAlt N V T (old Excel)Pivot Tables and Charts
Refresh Pivot Table with the selected cell on the Pivot TableAlt F5Pivot Tables and Charts
Refresh all Pivot Tables in workbookCtrl Alt F5Pivot Tables and Charts
Select whole Pivot Table including filtersAlt J T W TPivot Tables and Charts
Select whole Pivot Table excluding filters with any cell in the main pivot table selectedCtrl APivot Tables and Charts
Group selected itemsAlt Shift →Alt A G GPivot Tables and Charts
Ungroup selected itemsAlt Shift ←Alt A G UPivot Tables and Charts
Hide selected item or fieldCtrl –Pivot Tables and Charts
Open Calculated Field/Item dialog depending which field is selectedShift Ctrl =Pivot Tables and Charts
Open field list for cell (when on the cells with dropdowns)Alt ↓Pivot Tables and Charts
Open old PivotTable WizardAlt D PPivot Tables and Charts
Select entire tableCtrl Shift *Pivot Tables and Charts
Select first item in Field ListHomePivot Tables and Charts
Select last item in Field ListEndPivot Tables and Charts
Select next item in Field ListPivot Tables and Charts
Select previous item in Field ListPivot Tables and Charts
Select or clear a check box in the Field ListSpacePivot Tables and Charts
Add Selected Item in Field List to one of the field areasRight Click then arrows and EnterPivot Tables and Charts
Change Field Settings (in Field List or selected cell on Pivot TableRight Click then Field SettingsPivot Tables and Charts
Expand Field (when pointing to heading) instead of using the + buttonShift and scroll Up with mouse wheelPivot Tables and Charts
Collapse Field (when pointing to heading) instead of using the – buttonShift and scroll Down with mouse wheelPivot Tables and Charts
Insert Slicer (with Pivot Table selected)Alt JT SFPivot Tables and Charts
Change the Source Data used to create the Pivot TableAlt JT IDPivot Tables and Charts
Create linked Pivot Chart (while Pivot Table selected) on new worksheetF11Alt JT CPivot Tables and Charts
Create linked Pivot Chart (while Pivot Table selected) on same worksheetAlt F1Pivot Tables and Charts
Clear slicer filterAlt CPivot Tables and Charts
Toggle formulas on and off (Show Formulas)Ctrl ` (just left of the “1” button)Alt M HAuditing Formulas
Select cells where the formulas don’t match the one in the selected cell in the current columnCtrl Shift | (‘upper case’ backslash)Auditing Formulas
Select cells where the formulas don’t match the one in the selected cell in the current rowCtrl Shift \ (backslash)Auditing Formulas
Trace Precedents = select cells on the same sheet whose values are used in the formula of selected cellCtrl [Auditing Formulas
Trace Dependents = select cells on the same sheet whose formulas use the selected cell in their own calculationsCtrl ]Auditing Formulas
Trace Precedents = show arrows to find cells whose values are used in the formula of selected cellAlt M PAuditing Formulas
Trace Dependents = show arrows to find cells whose formulas use the selected cell in their own calculationsAlt M DAuditing Formulas
Remove Precedent/Dependent arrowsAlt M AAuditing Formulas
Evaulate Formula (works through the formula step by step showing the results of the calculation at all stages)Alt M VAuditing Formulas
Circular Reference Checker – find formulas that link to each other in a never ending circular loopAlt M K CAuditing Formulas
Check for Errors in the file/sheetAlt M K KAuditing Formulas
Trace Errors – show arrows to find cells causing the errorsAlt M K EAuditing Formulas
Open Visual Basic For Applications (VBA) EditorAlt F11VBA and Macros
Open Developer tab (if option is showing)Alt LVBA and Macros
Close VBA EditorAlt QVBA and Macros
Record/Stop Recording a macro (with developer tab showing)Alt L RAlt T M RVBA and Macros
Toggle between using Relative References when Recording a macro (with developer tab showing)Alt L UVBA and Macros
Run current subroutineF5VBA and Macros
Step through codeF8VBA and Macros
Toggle Breakpoint (to stop at row of code for debugging)F9VBA and Macros
Open Intellisense Dropdown to view object propertiesCtrl JVBA and Macros
Select from dropdown of object properties (Intellisense)VBA and Macros
Choose selected dropdown object property (Intellisense)SpaceVBA and Macros
Autocomplete codeCtrl SpaceVBA and Macros
Stop code (while running and if possible)Ctrl BreakVBA and Macros
View “Immediate” Window for running test code and viewing outputsCtrl GVBA and Macros
Go to Code windowF7VBA and Macros
Go to Project Explorer WindowCtrl RVBA and Macros
Go to Properties WindowF4VBA and Macros
Delete line of codeCtrl YVBA and Macros
Redo last actionAlt E RVBA and Macros
Compile VBA project to check for errorsAlt D LVBA and Macros
View/Hide Toolbox (when on a Form)Alt V XVBA and Macros
View VBA Project Properties (to add password to protect and hide code)Alt T EVBA and Macros
Cancel process or close dialogCtrl EscPower Pivots
Copy selected dataCtrl CPower Pivots
Delete tableCtrl DPower Pivots
Move tableCtrl MPower Pivots
Move to first cell in tableCtrl HomePower Pivots
Move to first cell of rowCtrl ←Power Pivots
Move to last cell in tableCtrl EndPower Pivots
Move to last cell of rowCtrl →Power Pivots
Move to next tableCtrl PgDnPower Pivots
Move to previous tableCtrl PgUpPower Pivots
Move to the first cell of columnCtrl ↑Power Pivots
Move to the last cell of columnCtrl ↓Power Pivots
Open AutoFilter Menu dialogAlt ↓Power Pivots
Select cells to first column cellShift PgDnPower Pivots
Select cells to first row cellShift HomePower Pivots
Select cells to last column cellShift PgUpPower Pivots
Select cells to last row cellShift EndPower Pivots
Select current columnCtrl SpacePower Pivots
Select current rowShift SpacePower Pivots
Select entire tableCtrl APower Pivots
Activate Selection paneF6Power BI
Collapse a tablePower BI
Comment lines in DAXCtrl /Power BI
Comment multiple lines in DAXCtrl K CPower BI
Copy line down in DAXAlt Shift ↓Power BI
Copy line up in DAXAlt Shift ↑Power BI
Create line break with auto-indentShift EnterPower BI
Delete a word in DAXCtrl DeletePower BI
Delete multiple lines in DAXCtrl Shift KPower BI
Enter lines of code in DAXCtrl Alt ↓Power BI
Enter lines of code in DAXCtrl Alt ↑Power BI
Expand a tablePower BI
Find the highlighted wordCtrl DPower BI
Go to line number in DAXCtrl GPower BI
Indent line in DAXCtrl ]Power BI
Insert cursor in DAXAlt ClickPower BI
Insert line above in DAXCtrl Shift EnterPower BI
Insert line below in DAXCtrl EnterPower BI
Interact with a SlicerCtrl →Power BI
Jump to matching bracket in DAXCtrl Shift \Power BI
Move an object down in layeringCtrl Shift BPower BI
Move an object up in layeringCtrl Shift FPower BI
Move focus backward in sectionShift TabPower BI
Move focus between sectionsCtrl F6Power BI
Move focus forward in sectionTabPower BI
Move focus to Visual menuAlt Shift F10Power BI
Move line down in DAXAlt ↓Power BI
Move line up in DAXAlt ↑Power BI
Multi-selectCtrl ShiftPower BI
Multi-select objectsCtrl SpacePower BI
New line in DAXAlt EnterPower BI
Open context menu (instead of right clicking)Shift F10Power BI
Outdent line in DAXCtrl [Power BI
Restart IntellisenseAlt IPower BI
Select all occurrences of current selectionCtrl Shift LAlt A TPower BI
Select all occurrences of current wordCtrl F2Power BI
Select an objectSpacePower BI
Select current line in DAXCtrl IPower BI
Select nearest word in DAXAlt Shift →Power BI
Select objectEnterPower BI
Show dataAlt Shift F11Power BI
Show keyboard shortcutsShift ?Power BI
Toggle commenting of codeAlt Shift APower BI
Toggle commenting of lines that has a wordCtrl +Power BI
Toggle object visibilityCtrl Shift SPower BI
Uncomment lines in DAXCtrl \Power BI
Uncomment multiple lines in DAXCtrl K UPower BI
Activate the Quick Access Toolbar Item 1 (if one exists)Alt 1Extras
Activate the Quick Access Toolbar Item 2 (if one exists)Alt 2Extras
Activate the Quick Access Toolbar Item 3 (if one exists)Alt 3Extras
Activate the Quick Access Toolbar Item 4 (if one exists)Alt 4Extras
Activate the Quick Access Toolbar Item 5 (if one exists)Alt 5Extras
Activate the Quick Access Toolbar Item 6 (if one exists)Alt 6Extras
Activate the Quick Access Toolbar Item 7 (if one exists)Alt 7Extras
Activate the Quick Access Toolbar Item 8 (if one exists)Alt 8Extras
Activate the Quick Access Toolbar Item 9 (if one exists)Alt 9Extras
Delete to the end of line while editing a formulaCtrl DeleteExtras
Display control menu for Excel windowAlt SpaceExtras
Select or clear a check boxSpaceExtras
Selects the entire worksheet / regionCtrl Shift SpaceCtrl AExtras
Switch to next tab in a dialog boxCtrl TabExtras
Switch to previous tab in a dialog boxCtrl shift TabExtras
Switch to Normal viewAlt W LExtras
Switch to Page Break Preview viewAlt W IExtras
Add Page Break while in Page Break Preview viewRight-Click Alt BExtras
Switch to Page Layout viewAlt W PExtras
Open Print Options Dialog BoxAlt P IExtras
Set Print Area to current selectionAlt P R SExtras
Toggle hiding and showing Excel grid linesAlt W V GExtras
Toggle hiding and showing the Formula BarAlt W V FExtras
Toggle hiding and showing Excel HeadingsAlt W V HExtras
Toggle full screenCtrl Shift F1Extras
Scroll to Top