Friday, March 17, 2023

Excel keyboard shortcuts

Shortcut keyActionMenu equivalent commentsVersion
Ctrl+ASelect AllNoneAll
Ctrl+BBoldFormat, Cells, Font, Font Style, BoldAll
Ctrl+CCopyEdit, CopyAll
Ctrl+DFill DownEdit, Fill, DownAll
Ctrl+EFlash FillData, Flash FillExcel 2019+/365
Ctrl+FFindEdit, FindAll
Ctrl+GGotoEdit, GotoAll
Ctrl+HReplaceEdit, ReplaceAll
Ctrl+IItalicFormat, Cells, Font, Font Style, ItalicAll
Ctrl+KInsert HyperlinkInsert, HyperlinkExcel 97/2000+
Ctrl+NNew WorkbookFile, NewAll
Ctrl+OOpenFile, OpenAll
Ctrl+PPrintFile, PrintAll
Ctrl+RFill RightEdit, Fill RightAll
Ctrl+SSaveFile, SaveAll
Ctrl+UUnderlineFormat, Cells, Font, Underline, SingleAll
Ctrl+VPasteEdit, PasteAll
Ctrl WCloseFile, CloseExcel 97/2000+
Ctrl+XCutEdit, CutAll
Ctrl+YRepeatEdit, RepeatAll
Ctrl+ZUndoEdit, UndoAll
F1HelpHelp, Contents and IndexAll
F2EditNoneAll
F3Paste NameInsert, Name, PasteAll
F4Repeat last actionEdit, Repeat. Works while not in Edit mode.All
F4While typing a formula, switch between absolute/relative refsNoneAll
F5GotoEdit, GotoAll
F6Next PaneNoneAll
F7Spell checkTools, SpellingAll
F8Extend modeNoneAll
F9Recalculate all workbooksTools, Options, Calculation, Calc NowAll
F10Activate MenubarN/AAll
F11New ChartInsert, ChartAll
F12Save AsFile, Save AsAll
Ctrl+:Insert Current TimeNoneAll
Ctrl+;Insert Current DateNoneAll
Ctrl+"Copy Value from Cell AboveEdit, Paste Special, ValueAll
Ctrl+Copy Formula from Cell AboveEdit, CopyAll
ShiftHold down shift for additional functions in Excel’s menunoneExcel 97/2000+
Shift+F1What’s This?Help, What’s This?All
Shift+F2Edit cell commentInsert, Edit CommentsAll
Shift+F3Paste function into formulaInsert, FunctionAll
Shift+F4Find NextEdit, Find, Find NextAll
Shift+F5FindEdit, Find, Find NextAll
Shift+F6Previous PaneNoneAll
Shift+F8Add to selectionNoneAll
Shift+F9Calculate active worksheetTools, Options, Calculation, Calc SheetAll
Ctrl+Alt+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.NoneExcel 97/2000+
Ctrl+Alt+Shift+F9Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.NoneExcel 97/2000+
Shift+F10Display shortcut menuNoneAll
Shift+F11New worksheetInsert, WorksheetAll
Shift+F12SaveFile, SaveAll
Ctrl+F3Define nameInsert, Names, DefineAll
Ctrl+F4CloseFile, CloseAll
Ctrl+F5XL, Restore window sizeRestoreAll
Ctrl+F6Next workbook windowWindow, ...All
Shift+Ctrl+F6Previous workbook windowWindow, ...All
Ctrl+F7Move windowXL, MoveAll
Ctrl+F8Resize windowXL, SizeAll
Ctrl+F9Minimize workbookXL, MinimizeAll
Ctrl+F10Maximize or restore windowXL, MaximizeAll
Ctrl+F11Inset 4.0 Macro sheetNone in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 MacroAll
Ctrl+F12File OpenFile, OpenAll
Alt+F1Insert ChartInsert, Chart...All
Alt+F2Save AsFile, Save AsAll
Alt+F4ExitFile, ExitAll
Alt+F8Macro dialog boxTools, Macro, Macros in Excel 97 Tools,Macros - in earlier versionsExcel 97/2000+
Alt+F11Visual Basic EditorTools, Macro, Visual Basic EditorExcel 97/2000+
Ctrl+Shift+F3Create name by using names of row and column labelsInsert, Name, CreateAll
Ctrl+Shift+F6Previous WindowWindow, ...All
Ctrl+Shift+F12PrintFile, PrintAll
Alt+Shift+F1New worksheetInsert, WorksheetAll
Alt+Shift+F2SaveFile, SaveAll
Alt+=AutoSumNo direct equivalentAll
Ctrl+`Toggle Value/Formula displayTools, Options, View, FormulasAll
Ctrl+Shift+AInsert argument names into formulaNo direct equivalentAll
Alt+Down arrowDisplay AutoComplete listNoneExcel 95
Alt+Format Style dialog boxFormat, StyleAll
Ctrl+Shift+~General formatFormat, Cells, Number, Category, GeneralAll
Ctrl+Shift+!Comma formatFormat, Cells, Number, Category, NumberAll
Ctrl+Shift+@Time formatFormat, Cells, Number, Category, TimeAll
Ctrl+Shift+#Date formatFormat, Cells, Number, Category, DateAll
Ctrl+Shift+$Currency formatFormat, Cells, Number, Category, CurrencyAll
Ctrl+Shift+%Percent formatFormat, Cells, Number, Category, PercentageAll
Ctrl+Shift+^Exponential formatFormat, Cells, Number, Category,All
Ctrl+Shift+&Place outline border around selected cellsFormat, Cells, BorderAll
Ctrl+Shift+_Remove outline borderFormat, Cells, BorderAll
Ctrl+Shift+*Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report.Edit, Goto, Special, Current RegionAll
Ctrl++InsertInsert, (Rows, Columns, or Cells) Depends on selectionAll
Ctrl+-DeleteDelete, (Rows, Columns, or Cells) Depends on selectionAll
Ctrl+1Format cells dialog boxFormat, CellsAll
Ctrl+2BoldFormat, Cells, Font, Font Style, BoldAll
Ctrl+3ItalicFormat, Cells, Font, Font Style, ItalicAll
Ctrl+4UnderlineFormat, Cells, Font, Font Style, UnderlineAll
Ctrl+5StrikethroughFormat, Cells, Font, Effects, StrikethroughAll
Ctrl+6Show/Hide objectsTools, Options, View, Objects, Show All/HideAll
Ctrl+7Show/Hide Standard toolbarView, Toolbars, StardardAll
Ctrl+8Toggle Outline symbolsNoneAll
Ctrl+9Hide rowsFormat, Row, HideAll
Ctrl+0Hide columnsFormat, Column, HideAll
Ctrl+Shift+(Unhide rowsFormat, Row, UnhideAll
Ctrl+Shift+)Unhide columnsFormat, Column, UnhideAll
Alt or F10Activate the menuNoneAll
Ctrl+TabIn toolbar: next toolbar
In a workbook: activate next workbook
NoneExcel 97/2000+
Shift+Ctrl+TabIn toolbar: previous toolbar
In a workbook: activate previous workbook
NoneExcel 97/2000+
TabNext toolNoneExcel 97/2000+
Shift+TabPrevious toolNoneExcel 97/2000+
EnterDo the commandNoneExcel 97/2000+
Alt+EnterStart a new line in the same cell.NoneExcel 97/2000+
Ctrl+EnterFill the selected cell range with the current entry.NoneExcel 97/2000+
Shift+Ctrl+FFont Drop Down ListFormat, Cells, FontAll
Shift+Ctrl+F+FFont tab of Format Cell Dialog boxFormat, Cells, FontBefore 97/2000
Shift+Ctrl+PPoint size Drop Down ListFormat, Cells, FontAll
Ctrl+SpacebarSelect the entire columnNoneExcel 97/2000+
Shift+SpacebarSelect the entire rowNoneExcel 97/2000+
CTRL+BackspaceJump back to the active cell and bring it into view  
CTRL+/Select the array containing the active cell.  
CTRL+SHIFT+OSelect all cells that contain comments.  
CTRL+\In a selected row, select the cells that don’t match the formula or static value in the active cell.  
CTRL+SHIFT+|In a selected column, select the cells that don’t match the formula or static value in the active cell.  
CTRL+[Select all cells directly referenced by formulas in the selection.  
CTRL+SHIFT+{Select all cells directly or indirectly referenced by formulas in the selection.  
CTRL+]Select cells that contain formulas that directly reference the active cell.  
CTRL+SHIFT+}Select cells that contain formulas that directly or indirectly reference the active cell.  
ALT+;Select the visible cells in the current selection.  
SHIFT+BACKSPACEWith multiple cells selected, select only the active cell.  
CTRL+SHIFT+SPACEBARSelects the entire worksheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet
  
Ctrl+Alt+LReapply the filter and sort on the current range so that changes you've made are includedData, ReapplyExcel 2007+
Ctrl+Alt+VDisplays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.Home, Paste, Paste Special...Excel 2007+
A special thanks goes out to Shane Devenshire who provided most of the shortcuts in this list!

References:

Shortcuts for the Visual Basic Editor

Shortcut keyActionMenu equivalent comments
F1HelpHelp
F2View Object BrowserView, Object Browser
F3Find Next 
F4Properies WindowView, Properties Window
F5Run Sub/Form or Run MacroRun, Run Macro
F6Switch Split Windows 
F7View Code WindowView, Code
F8Step IntoDebug, Step Into
F9Toggle BreakpointDebug, Toggle Breakpoint
F10Activate Menu Bar 
Shift+F2View definitionView, Definition
Shift+F3Find Previous 
Shift+F7View ObjectView, Object
Shift+F8Step OverDebug, Step Over
Shift+F9Quick WatchDebug, Quick Watch
Shift+F10Show Right Click Menu 
Ctrl+F2Focus To Object Box 
Ctrl+F4Close Window 
Ctrl+F8Run To CursorDebug, Run To Cursor
Ctrl+F10Activate Menu Bar 
Alt+F4Close VBEFile, Close and Return to Microsoft Excel
Alt+F6Switch Between Last 2 Windows 
Alt+F11Return To Application 
Ctrl+Shift+F2Go to last positionView, Last Position
Ctrl+Shift+F8Step OutDebug, Step Out
Ctrl+Shift+F9Clear All BreakpointsDebug, Clear All Breakpoints
InsertToggle Insert Mode 
DeleteDeleteEdit, Clear
HomeMove to beginning of line 
EndMove to end of line 
Page UpPage Up 
Page DownPage Down 
Left ArrowLeft 
Right ArrowRight 
Up ArrowUp 
Down ArrowDown 
TabIndentEdit, Indent
EnterNew Line 
BackSpaceDelete Prev Char 
Shift+InsertPasteEdit, Paste
Shift+HomeSelect To Start Of Line 
Shift+EndSelect To End Of Line 
Shift+Page UpSelect To Top Of Module 
Shift+Page DownSelect To End Of Module 
Shift+Left ArrowExtend Selection Left 1 Char 
Shift+Right ArrowExtend Selection Right 1 Char 
Shift+Up ArrowExtend Selection Up 
Shift+Down ArrowExtend Selection Down 
Shift+TabOutdentEdit, Outdent
Alt+SpacebarSystem Menu 
Alt+TabCycle Applications 
Alt+BackSpaceUndo 
Ctrl+A Select AllEdit, Select All
Ctrl+C CopyEdit, Copy
Ctrl+E Export ModuleFile, Export File
Ctrl+F FindEdit, Find...
Ctrl+G Immediate WindowView, Immediate Window
Ctrl+H ReplaceEdit, Replace...
Ctrl+I Turn On Quick InfoEdit, Quikc Info
Ctrl+J List Properties/MethodsEdit, List Properties/Methods
Ctrl+L Show Call Stack 
Ctrl+M Import FileFile, Import File
Ctrl+N New Line 
Ctrl+P PrintFile, Print
Ctrl+R Project ExplorerView, Project Explorer
Ctrl+S SaveFile, Save
Ctrl+T Show Available ComponentsInsert, Components...
Ctrl+V PasteEdit, Paste
Ctrl+X CutEdit, Cut
Ctrl+Y Cut Entire Line 
Ctrl+Z UndoEdit, Undo
Ctrl+InsertCopyEdit, Copy
Ctrl+DeleteDelete To End Of Word 
Ctrl+HomeTop Of Module 
Ctrl+EndEnd Of Module 
Ctrl+Page UpTop Of Current Procedure 
Ctrl+Page DownEnd Of Current Procedure 
Ctrl+Left ArrowMove one word to left 
Ctrl+Right ArrowMove one word to right 
Ctrl+Up ArrowPrevious Procedure 
Ctrl+Down ArrowNext Procedure 
Ctrl+SpacebarComplete WordEdit, Complete Word
Ctrl+TabCycle Windows 
Ctrl+BackSpaceDelete To Start Of Word 
Ctrl+Break/PauseBreakRun, Break
Ctrl+Shift+I Parameter InfoEdit, Parameter Info
Ctrl+Shift+J List ConstantsEdit, List Constants

No comments:

Post a Comment

Understanding Wire vs Imperative Apex Method Calls in Salesforce Lightning Web Components (LWC)

Understanding Wire vs Imperative Apex Method Calls in Salesforce Lightning Web Components (LWC) Introduction: Salesforce Lightning Web ...