Saturday, August 8, 2020

MS Excel Shortcut Key

1.Navigate Worksheets

Sr.No.Shortcut KeyUse of Key
01Arrow KeysMove One Cell up, Down, Left, or Right In a Worksheet
02Page Down/Page UpMove One Screen Down / One Screen up In a Worksheet
03Alt+Page Down/Alt+Page UpMove One Screen To The Right / to The Left in a Worksheet
04Tab/Shift+TabMove One Cell to The Right / To The Left in a Worksheet
05Ctrl+Arrow KeysMove to The Edge of Next Data Region (Cells That Contains Data)
06HomeMove To The Beginning of a Row in a Worksheet
07Ctrl+HomeMove To The Beginning Of a Worksheet
08Ctrl+EndMove To The Last Cell With Content on a Worksheet
09Ctrl+FDisplay The Find and Replace Dialog Box (With Find Selected)
10Ctrl+HDisplay The Find and Replace Dialog Box (With Replace Selected)
11Shift+F4Repeat Last Find
12Ctrl+G or F5Display The ‘Go To’ Dialog Box
13Ctrl+Arrow Left/Ctrl+Arrow RightInside a Cell:Move One Word To The Left / To The Right
14Home/EndInside a Cell:Move To The Beginning / To The End Of a Cell entry
15Alt+Arrow DownDisplay The AutoComplete List eg in Cell With Dropdowns or Autofilter
16EndTurn ‘End’ Mode on In End Mode, Press Arrow Keys to Move To The Next Nonblank Cell in The Same Column or Row as The Active Cell From Here Use Arrow keys to move by blocks of data, home to Move to Last Cell, or Enter to Move to The Last Cell To The Right

2.Basic and Advanced Cell Selections

Sr.No.Shortcut KeyDescription
01Shift+SpaceSelect the entire row
02Ctrl+SpaceSelect the entire column
03Shift+Arrow KeysExtend the selection by one cell
04Shift+Page Down/Shift+Page UpExtend the selection down one screen /up one screen
05Shift+HomeExtend the selection to the beginning of the row There is no Shift+End equivalent
06Ctrl+Shift+Arrow KeyExtend the selection to the last cell with content in row or column
07Ctrl+ASelect the entire worksheet or the data-containing area Pressing ctrl+a a second time then selects entire worksheet
08Ctrl+Shift+HomeExtend the selection to the first cell of the worksheet
09F5+ column or row referenceF5, then eg type d:g selects columns D-G, or 1:5 selects rows 1-5 etc
10F2Edit Cell
11Shift+Home/EndInside a cell: Select from the insertion point to the beginning / to the end of the cell
12Shift+Arrow Left/Arrow RightInside a cell: Select or unselect one character to the left / to the right
13Ctrl+Shift+Arrow Left/Arrow RightInside a cell: Select or unselect one word to the left / to the right

3.Navigate Inside Selected Text Blocks

Sr.No.Shortcut KeyDescription
01Tab/Shift+TabMove active cell right / left in a selection
02Shift+F8Lock Selection which allows to add another (adjacent or non-adjacent) range of cells to the selection Use arrow keys and shift+arrow keys to add to selection
03F8Turn on extension of selection with arrow keys without having to keep pressing shift
04Enter/Shift+EnterMove active cell down / up in a selection
05Shift+BackspaceSelect only the active cell when multiple cells are selected
06Ctrl+BackspaceShow active cell within selection
07Ctrl+. (period)Move clockwise to the next corner of the selection
08Ctrl+Alt+Arrow Right/Ctrl+Alt+Arrow LeftMove to the right / to the left between non-adjacent selections (with multiple ranges selected)
09EscCancel Selection

4.Edit Complete Cells

Sr.No.Shortcut KeyDescription
01Ctrl+DFill Down Select cells with value in first row Ctrl+D fills the value of that first cell in selection to all cells in selection downwards
02Ctrl+RFill Right: Select cell with value in first cell Ctrl+E fills value of that first cell in selection to all cells rightwards
03Ctrl+-Delete Cell/Row/Column Menu
04Ctrl+- with row / column selectedDelete row / delete column
05Ctrl+Shift++Insert Cell/Row/Column Menu
06Ctrl+Shift++ with row / column selectedInsert row/ insert column
07Shift+F2Insert / Edit a cell comment
08Shift+F10, then MDelete comment
09Ctrl+KInsert a HyperlinK (for complete cell only)
10Ctrl+9Hide the selected rows
11Ctrl+Shift+9Unhide any hidden rows within the selection
12Ctrl+0 (zero)Hide the selected columns Since Excel 2010, there is no more shortcut to unhide columns
13Ctrl+` (Accent Grave)Alternate between displaying cell values and displaying cell formulas This is Accent Grave on top left of keyboard, not a quotation mark

5.Edit Content of Cells

Sr.No.Shortcut KeyDescription
01F2Edit the active cell with cursor at end of the line
02Alt+EnterStart a new line in the same cell
03EnterComplete a cell entry and move down in the selection With multiple cells selected: fill cell range with current cell
04Shift+EnterComplete a cell entry and move up in the selection
05Tab/Shift+TabComplete a cell entry and move to the right / to the left in the selection
06EscCancel a cell entry
07BackspaceDelete the character to the left of the insertion point, or delete the selection
08DeleteDelete the character to the right of the insertion point, or delete the selection
09Ctrl+DeleteDelete text to the end of the line
10Ctrl+;Insert current date
11Ctrl+Shift+:Insert current time
12Ctrl+’Duplicate value from Cell above into current Cell

6. Excel Basics

Sr.No.Shortcut KeyDescription
01Shift+F10Display the shortcut menu for the selected command (simulates right mouse button)
02Ctrl+ZUndo last action (multiple levels)
03Ctrl+YRedo last action (multiple levels)
04Ctrl+CCopy contents of selected cells
05Ctrl+XCut contents of selected cells
06Ctrl+VPaste content from clipboard into selected cell
07Ctrl+Alt+vIf data exists in clipboard: Display the Paste Special dialog box

7.Format Cells

Sr.No.Shortcut KeyDescription
01Ctrl+1Open Format Cells dialog with last selection active
02Ctrl+Shift+FOpen Format Cells dialog with Font Tab active
03Ctrl+BApply or remove bold formatting
04Ctrl+IApply or remove italic formatting
05Ctrl+UApply or remove an underline
06Ctrl+5Apply or remove strikethrough formatting
07Ctrl+Shift+~Apply the General number format
08Ctrl+Shift+1Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values
09Ctrl+Shift+2Apply the Time format with the hour and minute, and indicate AM or PM
10Ctrl+Shift+3Apply the Date format with the day, month, and year
11Ctrl+Shift+4Apply the Currency format with two decimal places
12Ctrl+Shift+5Apply the Percentage format with no decimal places
13Ctrl+Shift+6Apply the Scientific number format with two decimal places
14F4Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell
15Alt+H, ALAlign Left
16Alt+H, ARAlign Right
17Alt+H- ACAlign Cight
18Alt+H, ATAlign Top
19Alt+H, AMAlign Middle
20Alt+H- ABAlign Bottom
21Alt+H, WWrap or unwrap text (Home – Wrap Text)
21Alt+H, HHighlight Cell (change cell backgroudn color)
22Alt+H, FCFont Color
23Alt+H, FSFont Size
24Alt+H, MMMerge Cells – Merge
25Alt+H, MUMerge Cells – Unmerge
26Alt+H, MCMerge Cells – Merge and Center
27Alt+H, MAMerge Cells – Merge Across

8.Apply Basic Borders to Cells

Sr.No.Shortcut KeyDescription
01Ctrl+Shift+7Apply outline border from cell or selection
02Ctrl+Shift+_Remove outline borders from cell or selection
03Alt+HB, OBottom Border
04Alt+HB, PTop Border
05Alt+HB, RRight Border
06Alt+HB, LLeft Border
07Alt+HB, AAll Borders
08Alt+HB, AOutside Borders
09Alt+HB, NNo Border


Sr.No.Shortcut KeyDescription
01=Start a formula
02Alt+=Insert the AutoSum formula
03Shift+F3Display the Insert Function dialog box
04Ctrl+ADisplay Formula Window after typing formula name
05Ctrl+Shift+AInsert Arguments in formula after typing formula name
06Shift+F3Insert a function into a formula
07Ctrl+Shift+EnterEnter a formula as an array formula
08F4After typing cell reference (eg =E4) makes reference absolute (=$E$4). Repeat if you want to toogle from absolute reference to parcial or complete removal ($E$4 -> E$4 -> $E4 -> returning to E4.

10.Manage Multipe Worksheets

Sr.No.Shortcut KeyDescription
01Ctrl+Page Down/Page UpMove to the next / previous worksheet in current workbook
02Shift+F11/Alt+Shift+F1Insert a new worksheet in current workbook
03Ctrl+Shift+Page Up / Page DownSelect the current and previous sheet / and next sheet in a workbook
04Alt+O then H RRename current worksheet (format, sheet, rename)
05Alt+E then LDelete current worksheet (Edit, delete)
06Alt+E then MMove current worksheet (Edit, move)

11.Manage Multiple Workbooks

Sr.No.Shortcut KeyDescription
01F6/Shift+F6Move to the next pane / previous pane in a workbook that has been split
02Ctrl+F4Close the selected workbook window
03Ctrl+NCreate a new blank workbook (Excel File)
05Alt+SpaceDisplay the Control menu for Main Excel window
06Ctrl+F9Minimize current workbook window to an icon Also restores (‘un-maximizes’) all workbook windows
07Ctrl+F10Maximize or restores the selected workbook window
08Ctrl+F7Move Workbook Windows which are not maximized
09Ctrl+F8Perform size command for workbook windows which are not maximzed
10Alt+F4Close Excel

12.Various Excel Features

Sr.No.Shortcut KeyDescription
01Ctrl+OOpen File
02Ctrl+SSave the active file with its current file name, location, and file format
03F12Display the Save As dialog box
04F10 (or alt)Turn key tips on or off
05Ctrl+PPrint File (Opens print menu)
06F1Display the Excel Help task pane
07F7Display the Spelling dialog box
08Shift+F7Display the Thesaurus dialog box
09Alt+F8Display the Macro dialog box
10Alt+F11Open the Visual Basic Editor to create Macros

13.Ribbon Shortcuts

Sr.No.Shortcut KeyDescription
01Ctrl+F1Minimize or restore the Ribbons
02Space/EnterActivate the selected command or control in the Ribbon, Open the selected menu or gallery in the Ribbon
03EnterFinish modifying a value in a control in the Ribbon, and move focus back to the document
04F1Get help on the selected command or control in the Ribbon (If no Help topic is associated with the selected command, the Help table of contents for that program is shown instead)

14.Pivot Tables

Sr.No.Shortcut KeyDescription
01Arrow KeysNavigate inside Pivot tables
02Home/EndSelect the first / last visible item in the list
03Alt+CMove the selected field into the Column area
04Alt+DMove the selected field into the Data area
05Alt+LDisplay the PivotTable Field dialog box
06Alt+PMove the selected field into the Page area
07Alt+RMove the selected field into the Row area
08Ctrl+Shift+*Select the entire PivotTable report
09EnterDisplay the selected item
10SpaceSelect or clear a check box in the list
11Ctrl+Tab/ Ctrl+Shift+TabSelect the PivotTable toolbar
12Enter then Arrow Down /Arrow UpOn a field button: select the area you want to move the selected field to
13Alt+Shift+Arrow RightGroup selected PivotTable items
14Alt+Shift+Arrow LeftUngroup selected PivotTable items

15.Dialog Boxes

Sr.No.Shortcut KeyDescription
01Arrow KeysMove between options in the active drop-down list box or between some options in a group of options
02Ctrl+Tab/Ctrl+Shift+TabSwitch to the next/ previous tab in dialog box
03SpaceIn a dialog box: perform the action for the selected button, or select/clear a check box
04Tab/Shift+TabMove to the next / previous option
05A..ZMove to an option in a drop-down list box starting with the letter
06Alt+A..Alt+ZSelect an option, or select or clear a check box
07Alt+Arrow DownOpen the selected drop-down list box
08EnterPerform the action assigned to the default command button in the dialog box
09EscCancel the command and close the dialog box

16.Auto Filter

Sr.No.Shortcut KeyDescription
01Alt+Arrow DownOn the field with column head, display the AutoFilter list for the current column
02Arrow Down/Arrow UpSelect the next item / previous item in the AutoFilter list
03Alt+Arrow UpClose the AutoFilter list for the current column
04Home/EndSelect the first item / last item in the AutoFilter list
05EnterFilter the list by using the selected item in the AutoFilter list
06Ctrl+Shift+LApply filter on selected column headings

17.Data Forms

Sr.No.Shortcut KeyDescription
01Tab/Shift+TabMove to the next / previous field which can be edited
02Enter/Shift+EnterMove to the first field in the next / previous record
03Page Down/Page UpMove to the same field 10 records forward / back
04Ctrl+Page DownMove to a new record
05Ctrl+Page UpMove to the first record
06Home/EndMove to the beginning / end of a field

18.Adjust Column Width and Row Height

Sr.No.Shortcut KeyDescription
01Alt+HO, AFormat – Autoheight Row
02Alt+HO, IFormat – Autowidth Column

19.Lesser Used Shortcuts

Sr.No.Shortcut KeyDescription
01Ctrl+Shift+OSelect all cells with comments
02Alt+Shift+Arrow RightGroup rows or columns
03Alt+Shift+Arrow LeftUngroup rows or columns
04Ctrl+6Alternate between hiding and displaying objects
05Ctrl+8Display or hides the outline symbols
06Ctrl+6Alternate between hiding objects, displaying objects, and displaying placeholders for objects
07Alt+’Display the Style dialog box
08Ctrl+Shift+[+]If data exists in clipboard: Display the Insert dialog box to insert blank cells
09F9Calculate all worksheets in all open workbooks
10Shift+F9Calculate the active worksheet
11Ctrl+Alt+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
12Ctrl+Alt+Shift+F9Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated
13Ctrl+Shift+UToggle expand or collapse formula bar
14Ctrl+F3Define a name or dialog
15Ctrl+Shift+F3Create names from row and column labels
16F3Paste a defined name into a formula
17Ctrl+TInsert a table (display Create Table dialog box)
18Alt+F1Create and insert chart with data in current range as embedded Chart Object
19F11Create and insert chart with data in current range in a separate Chart sheet

Powered by BetterDocs


Please enter your comment!
Please enter your name here