Keyboard Shortcuts for Microsoft Excel

Are you finding the Keyboard shortcuts for Microsoft Excel? Microsoft Excel provides shortcuts to help you quickly work on documents. Here is the list of all shortcuts that you can use. This post will help you to check and make your work faster with the most used.

Excel Shortcuts for selecting Rows Columns and Cells 

Keyboard Shortcuts (Windows)Menu Description
1.1 Navigation Basics 
Arrow KeysNavigate one cell at a time in any direction
Ctrl+Arrow KeysMove to the edge of data region (cells that contains data)
Page Down/Page UpMove one screen down/ up
Alt+Page Down/Page UpMove one screen right/ left
Tab/Shift+TabMove one cell to the next/ previous cell in worksheet
HomeMove to beginning of row
Ctrl+HomeMove to the beginning of worksheet
Ctrl+EndMove to the last cell with content of worksheet
Ctrl+GDisplay the GoTo dialog box
Ctrl+G then type e.g. A50Go to line 50, Column A
Ctrl+G then type e.g. G1Go to column G, Line 1 in Excel
Ctrl+BackspaceSet focus back to active cell after e.g. scrolling away from it
1.2 Select Basics 
Shift+Arrow KeysExtend selection by one cell
Shift+Page Down/Page UpExtend selection one screen down/ up
Ctrl+Shift+Arrow KeysExtend selection to next non-blank cell
Shift+HomeExtend selection to beginning of the row (unfortunately, there is no Shift+End equivalent)
Ctrl+A with empty cells around current cellSelect all
Ctrl+A with filled cells around current cellSelect all cells in data-containing area. Press twice to select everything
Ctrl+Shift+HomeExtend selection to first cell of the worksheet
Ctrl+Shift+EndExtend selection from current cell to all cells with data on the worksheet
Ctrl+GManual selection by row/ column via GoTo menu.
 A:B selects column A thru C,
 1:3 selects row 1 thru 3 ,
 A1:B3 select cells A1 thru B3, etc
1.3 Select Columns and Rows 
Shift+SpaceSelect current row
Shift+Space, then Shift+Arrow Down/Arrow UpSelect current row, then expand selection by one row down/ up
Shift+Space, then Shift+Page Down/Page UpSelect current row, then expand selection by one page down/ up
Ctrl+SpaceSelect current column
Shift+Space, then Shift+Arrow Right/Arrow LeftSelect current column, then expand selection by one column right/ left
Shift+Space, then Shift+Alt+Page Down/Page UpSelect current column, then expand selection by one screen right/ left
1.4 Insert Rows, Columns and Duplicate Content 
Shift+Space, then Ctrl+-Select single row; then delete
Shift+Space, then Shift+Arrow Up/Arrow Down, then Ctrl+-Select multiple rows; then delete
Shift+Space, thenCtrl+Shift++Select single row; then insert one row above
Shift+Space, then Shift+Arrow Up/Arrow Down, then Ctrl+Shift++Select multiple rows; then insert the same number rows below
Shift+Space, then Ctrl+-Select single (or multiple) columns, then delete
Shift+Space, then Ctrl+Shift++Select single row, then insert row below. Select multiple rows to insert multiple rows
Ctrl+Shift++ with row(s) in clipboard and a row selectedPaste Insert – paste row(s) from clipboard and shift existing content downward
Ctrl+Shift++ with column(s) in clipboard and column selectedPaste Insert – paste column(s) from clipboard and shift existing content to the right
Ctrl+Shift++With cells that are not complete rows/columns – Open insert cell/ row/ column menu
Ctrl+-With cells that are not complete rows/columns – Open delete cell/ row/ column menu
Shift+Arrow Down, F2, then Ctrl+EnterFill single cell content down to all cells selected with Shift+Arrow Down
Shift+Arrow Up, F2, then Ctrl+EnterFill single cell content up to all cells selected with Shift+Arrow Down
1.5 Duplicate Content 
Ctrl+DDuplicate cell or line above (Duplicate Down)
Ctrl+RDuplicate cell or line above (Duplicate Right)
Shift+Space, then Ctrl+DDuplicate content from row above of selection
Ctrl+Space, then Ctrl+RDuplicate column content from column to the left of selection
Ctrl+’Duplicate single cell from above during editing a Cell. Similar to Ctrl+D, but on single cell only and applies to when editing. This also allows e.g. amend text from above to the current cell content.
1.6 Extend Selection Mode and select non-adjacent Cells 
Press and hold Ctrl, then click or click and dragAdd non-adjacent cells to a selection. While continue to hold Ctrl, click on selected cells or drag ranges to de-select.
F8Extend selection from current cell; same effect as pressing and holding Shift. There is an ‘Extend Selection’ texts at in Excel Status Bar. Press Escape to exit Extend Selection Mode
Shift+F8Enter Locked Selection Extend Mode. Now you can add non-adjacent cells to a selection. There is an ‘Add or Remove Selection’ text at bottom of Excel Window
Shift+F8, then click on cells or click+drag cell rangesAdd non-adjacent cells or ranges to locked selection
Shift+F8, then Arrow Keys, then 2x Shift+F8 on a single cellAdd non-adjacent single cells to locked selection
Shift+F8, then Arrow Keys, then Shift+Arrow Keys, then 1x Shift+F8 selected range.Add non-adjacent cell ranges to locked selection
1.7 Shortcuts for Editing Cells 
These assume you are inside a cell, typically after pressing F2 
F2Edit cell. Press Escape to cancel
F2, then Shift+HomeSelect Cell Content. Selects from current end of cursor to beginning
Home/EndJump to beginning/ end of cell
Arrow KeysNavigate by one character left/ right or one line up/ down
Ctrl+Arrow Left/Arrow RightNavigate by one word left/ right
Shift+Arrow KeysSelect one character to the left/ right (or one line up/down)
Shift+Home/EndSelect from the insertion point to beginning/ end of cell
Ctrl+Shift+Arrow Left/Arrow RightSelect or unselect one word to the left/ right
Delete/BackspaceDelete one character to the right/ left of cursor
Ctrl+DeleteDelete from cursor to end of cell
Alt+EnterStart a new line inside cell
Enter/Shift+EnterComplete cell entry and move one cell down/ up
Tab/Shift+TabComplete cell entry and move one cell right/ left
Ctrl+EnterComplete cell entry and don’t move selection
Ctrl+’Duplicate value from Cell above into current cell at cursor position
Ctrl+;Insert current date at cursor position
Ctrl+Shift+;Insert current time at cursor position
1.8 Edit Cells with Multiple Cells Selected 
All these shortcuts assume multiple cells have been selected. Try with at least 2-3 columns and rows. 
Tab/Shift+TabMove active cell right/ left in selection
Enter/Shift+EnterMove active cell down/ up in selection
Shift+BackspaceSelect only the active cell when multiple cells are selected
Ctrl+BackspaceShow active cell within selection; helps with large selections when active cell is off screen
Ctrl+.Move clockwise between the four corners of a selection
Ctrl+Alt+Arrow Right/Arrow LeftMove to the right/ to the left between non-adjacent selections (with multiple ranges selected)
Arrow Keys with active SelectionCancel Selection

Shortcuts for Excel Workbooks, Worksheets, and Tabs 

Keyboard Shortcuts (Windows)Menu Description
2.1 Open and Save Workbooks 
Ctrl+OOpen Workbook via ‘new’ open box to access additional locations
Ctrl+Alt+F2Open file via classic open dialog window
Alt+F, OFile Open via Excel file manager
Alt+F, O + 1…9Open recent file (1 thru 9)
Alt+F, O, Y1…ZOpen recent file (10 upwards)
Alt+F, O, KFile Open from OneDrive Link
Ctrl+SSave File with current file name
F12Save file as via standard save dialog box
Alt+F, AFile Save as via Excel file manager
Alt+F, A, KFile Save to OneDrive Link
EscExit open/ save menu
2.2 Print Workbooks 
Ctrl+PPrint. This won’t offer Key Tips/ Options. To continue with shortcuts, use the new Key Options below.
Alt+F, POpen File Print menu
I in Print MenuSelect printer
Alt+P if Key Tips disappearReturn Print key tips/ options
V in Print MenuFocus on View pane; use arrow keys to forward/ backward preview pages
G in Print MenuPage setup
N in Print MenuSet Number of copies
2.3 Manage Worksheet Tabs 
Ctrl+Page Down/Page UpMove to the next/ previous worksheet in current workbook
Alt+H, ISInsert worksheet (Home – Insert Sheet)
Alt+H, DSDelete worksheet Home – Delete Sheet
Alt+H, ORRename worksheet (Home – Format – Rename worksheet)
Alt+H, OMMove worksheet (Home – Format – Move worksheet)
Alt+H, OTWorksheet tab color, continue with mouse or arrow keys (Home – Format – Tab color)
2.4 Freeze, Split, and Hide Windows 
Alt+W+FFView – Freeze or unfreeze; unfreeze works for any Freeze Setting
Alt+W+RView – Freeze first visible Row on screen
Alt+W+CView – Freeze first Column on screen
Ctrl+9Hide selected rows
Ctrl+Shift+9Unhide hidden rows within the selection
Ctrl+0Hide selected columns
Shift+F10, then UUnhide selected columns (Ctrl+Shift+0 not working in Excel 2010, 2013, or 2016)
Alt+W SSplit or unsplit Worksheet at current position

Excel Cell Borders Shortcuts 

Keyboard Shortcuts (Windows)Menu Description
3.1 Basic Cell Borders 
Ctrl+Shift+7Apply border on all sides of cell
Ctrl+Shift+-Remove all borders from selection
3.2 Cell Borders via Border Menu 
Ctrl+1, then Ctrl+TabOpen Border Menu
Alt+HB, them MOpen Border Menu
Alt+TToggle Top border (in border menu)
Alt+BToggle Bottom border (in border menu)
Alt+RToggle Right border (in border menu)
Alt+LToggle Left border (in border menu)
Alt+OToggle Outline order (in border menu)
Alt+IToggle Inside border (in border menu)
Alt+HToggle Horizontal interior border (in border menu)
Alt+VToggle Vertical interior border (in border menu)
Alt+UToggle Upwards diagonal border (in border menu)
Alt+DToggle Downwards diagonal border (in border menu)
Alt+NRemove/ Neutralize all borders (in border menu)
3.3 Cell Borders via Ribbon Shortcuts 
Alt+HB then OBottom border
Alt+HB then PTop border
Alt+HB then LLeft border
Alt+HB then RRight border
Alt+HB then NNo borders
Alt+HB then AAll borders
Alt+HB then AOutside borders
Alt+HB then TThick outside borders
Alt+HB then BBottom double borders
Alt+HB then HThick bottom borders
Alt+HB then CTop and thick bottom border
Alt+HB then UTop and double bottom border

Excel Date and Time Shortcuts 

Keyboard Shortcuts (Windows)Menu Description
4.1 Insert and Format Date and Time 
Ctrl+;Insert static date
Ctrl+Shift+;Insert static time
Ctrl+;, then Space, then Ctrl+Shift+;Insert static date followed by time
2021-07-11Insert todays date as formula
2021-07-11 21:08Insert todays date and time as formula
Ctrl+Shift+3Apply date format to selection as dd-mmm-yy
Ctrl+Shift+2Apply time format to selection as h:mm AM/PM
4.2 Custom Date Formats 
Ctrl+1Access Format Number menu (press Ctrl+Tab if tab Is not in focus, press Tab or Ctrl+T for Type to access number format)
MMonth as single digit (e.g. 1/23/2020)
mmMonth as double digits (e.g. 01/23/2020)
mmmMonth abbreviated 3-letter (e.g. Jan/23/2020)
mmmmMonth as full name (e.g. January/23/2020)
mmmmmMonth as abbreviated 1 letter (e.g. J/23/2020)
DDay as 1 digit number (e.g. 1/1/2020)
ddDay as 2 digit number (e.g. 1/01/2020)
dddDay as 3-digit abbreviation (e.g. 1/Wed/2020)
ddddDay as full name (e.g. 1/Wednesday/2020)
YYear as 2 digit number (e.g. 1/1/20)
yyYear as 4 digit number (e.g. 1/1/2020)
4.3 Custom Time Formats 
Ctrl+1Access Format Number menu (press Ctrl+Tab if tab Is not in focus, press Tab or Ctrl+T for Type to access number format)
HHours without leading zero
hhHours with leading zero
MMinutes without leading zero
mmMinutes with leading zero
SSeconds without leading zero
ssSeconds with leading zero
AM/PMDisplay AM or PM
HTime elapsed in hours (Hours in 24-hour format)
MTime elapsed in minutes
MTime elapsed in minutes
mmmMonth abbreviated 3-letter (e.g. Jan/23/2020)
mmmmMonth as full name (e.g. January/23/2020)
mmmmmMonth as abbreviated 1 letter (e.g. J/23/2020)
DDay as 1-digit number (e.g. 1/1/2020)
ddDay as 2-digit number (e.g. 1/01/2020)
dddDay as 3-digit abbrevation (e.g. 1/Wed/2020)
ddddDay as full name (e.g. 1/Wednesday/2020)
YYear as 2-digit number (e.g. 1/1/20)
yyYear as 4-digit number (e.g. 1/1/2020)

Excel Format Shortcuts

Keyboard Shortcuts (Windows)Menu Description
5.1 General Cell Format 
Ctrl+Alt+V, then T and EnterCopy a cell via Ctrl+C, then via Paste Special, paste format of that cell to current cell
Alt+EnterRepeat a previous cell format action on current cell
Ctrl+1Open Format Cells dialog with last selection active
Ctrl+Shift+FOpen Format Cells dialog with Font Tab active
5.2 Font Face, Font Decoration, and Cell Color 
Ctrl+BApply/ remove bold format
Ctrl+IApply/ remove italic format
Ctrl+UApply/ remove underline format
Ctrl+5Apply/ remove strikethrough formatting
Alt+H, FFHome select Font Face; type font name supported by auto-complete or use Arrow Down to select.
Alt+H, FSHome select Font Size; use Arrow Key, then Enter to change size
Alt+H, FC, Escape, EnterAssign current font color to selection via Home Font Color. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color.
Alt+HH, Escape, EnterAssign current fill color to selected cell color via Home Higlight Cell. While escaping the highlight drop-down, the focus stays on the icon; simply press Enter to assign the current color.
Alt+HH, then NSet to No fill color
5.3 Number Formats 
Ctrl+Shift+~Apply the general number format (e.g. 1000)
Ctrl+Shift+1Apply the number format with two decimal places, thousands separator (e.g. 1,000.00)
Ctrl+Shift+2Apply the time format with the hour and minute, and indicate AM or PM
Ctrl+Shift+3Apply the date format with the day, month, and year
Ctrl+Shift+4Apply the currency format with two decimal places (e.g. $1,000.00)
Ctrl+Shift+5Apply the percentage format with no decimal places (e.g. 10%)
Ctrl+Shift+6Apply the scientific number format
5.4 Alignments 
Alt+H, ALAlign Left
Alt+H, ARAlign Right
Alt+H, ACAlign Center
Alt+H, ATAlign Top
Alt+H, AMAlign Middle
Alt+H, ABAlign Bottom
5.5 Wrap and Merge 
Alt+H, WWrap or unwrap text (Home – Wrap Text)
Alt+H, MMMerge cells – Merge
Alt+H, MUMerge – Unmerge
Alt+H, MCMerge and Center
Alt+H, MAMerge Across (merge all columns, but not rows in selection)

Excel Formula Shortcuts 

Keyboard Shortcuts (Windows)Menu Description
6.1 Basic Formula Usage 
Ctrl+`Toggle show formulas on/off
=Start a formula
Alt+=Insert the AutoSum formula
Ctrl+A with formula presentEdit formula in formula Bar
Ctrl+Shift+UExpand/ collapse formula bar
F4After typing cell reference (eg =E4) makes reference absolute (=$E$4). Repeat if you want to toggle from absolute reference to partial or complete removal ($E$4 -> E$4 -> $E4 -> returning to E4.
Shift+F3 with empty cellDisplay the ‘insert function; dialog box
Shift+F3 with formula presentEdit arguments of formula at cursor position
Alt+H,FD, USelect all Formulas (Home – Find – Formulas
Ctrl+Shift+Enter with array formulaEnter a formula as an array formula. Formula bar will show this as e.g. {=SUM(A1:A3*B1:B3)} which is the sum of A1*B2+A2*B2+A3+B3. This is an easy and concise method. Remember that each time editing the formula will require the Ctrl+Shift+Enter. Some keyboards seem to distinguish between left and right Shift key
Ctrl+`Show/ hide all formulas. This will automatically extend all column widths which reverses when pressed again
Ctr+’Duplicate formula from cell above
F3Paste named range in formula
6.2 Common Text Functions 
#NAME?Return X number of chars of text from left
#NAME?Return X number of chars of text from right
#NAME?Return X number of chars of text from middle
#NAME?Returns length of text
=CONCATENATE (text, text2, …)Concatenates/ combines multiple cells or text fragments
#NAME?Case-sensitive search of text within provided text. Add optional start position as optional parameters.
#NAME?Case-insensitive search of text within provided text. Add optional start position as optional parameters.
#NAME?Remove extra spaces from beginning and end of text
#NAME?Convert text to all upper case
#NAME?Convert text to all lower case
#NAME?Convert text to all proper case (first letter capital, rest lower case)
6.3 Common Calculation Functions 
#NAME?Sum values
#NAME?Count cells
#NAME?Count cells with content
=MAX (number1, number2, …)Maximum value
=MIN (number1, number2, …)Minimum value
6.4 Auditing Formulas 
Ctrl+[Select direct precedents
Ctrl+Shift+[Select all precedents
Ctrl+]Select direct dependents
Ctrl+Shift+]Select all dependents
Alt+M+PFormulas – Trace Precedents
Alt+M+DFormulas – Trace Dependents
Alt+M+AAFormulas – Remove all Arrow Traces
6.5 Shortcuts for Force Calculation 
F9Calculate all worksheets in all open workbooks
Shift+F9Calculate the active worksheet
Ctrl+Alt+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
Ctrl+Alt+Shift+F9Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated

Excel Shortcuts for Auto Tables, Auto Filters and Pivot Tables 

Keyboard Shortcuts (Windows)Menu Description
7.1 Auto Tables 
Ctrl+TCreate auto Table from selection
Ctrl+SpaceSelect table column
Shift+SpaceSelect table row
7.2 Auto Filter 
Ctrl+Shift+LTurn Autofilter on or off. Select table as necessary but many times Excel figures out what you want.
Alt+Arrow DownOn the field with column head, display the AutoFilter list for the current column. Press Escape to cancel
Arrow Down/Arrow Up and SaceSelect the next/ previous item in the AutoFilter list
Alt+Arrow UpClose the AutoFilter list for the current column
Home/EndSelect the first item/ last item in the AutoFilter list
7.3 Pivot Tables 
Creating Pivot Tables with Shortcuts only seems to be nearly impossible; managing existing tables is doable. 
Alt+NVInsert PivotTable after selecting data range. Follow up with Alt+E for existing worksheet if desired, Tab, and type the cell reference where it should go (e.g. C1)
F10+RRefresh PivotTable
Ctrl+-Hide selected item
Alt+Arrow Down in headerUnhide item(s) by opening header drop-down and using Arrow Keys and Space to unhide item
Type over any field with the value hiddenUnhide item(s) (assume you have two fields ‘color’, and ‘size’ and you hid ‘color’. Go into ‘size’ field and type ‘color’ – this will unhide the ‘color’ field
Type over any field with another field in same tableFlip current field value with the value typed
Ctrl+Shift+*Select the entire PivotTable report
Alt+Shift+Arrow RightGroup selected PivotTable items
Alt+Shift+Arrow LeftUngroup selected PivotTable items when on group header
Alt+JTXExpand all fields
Alt+JTPCollapse all fields
Ctrl+Shift+plusInsert pivot formula/ calculated field
Alt+F1Create Pivot Chart in same Worksheet
F1Create Pivot Chart in new Worksheet

Excel Shortcuts for Advanced Undo, Redo, Repeat and Copy & Paste 

Keyboard Shortcuts (Windows)Menu Description
8.1 Undo, Redo, and Repeat Action 
Ctrl+ZUndo
Ctrl+YRedo (after undo) or Repeat (e.g. when applying formats)
Alt+3Undo list (via quick access). Use Arrow Down to extend undo range.
Alt+4Redo list (via quick access). Use Arrow Down to extend redo range.
Alt+Enter outside edit cell modeRepeat last action. E.g. try to set a cell bold with Ctrl+B, then go to a different cell and press Alt+Enter; great to cascade formatting across multiple cells
8.2 Cut, Copy, Paste, and Paste Special 
Ctrl+XCut cell(s) to clipboard
Ctrl+CCopy cell(s) to clipboard
Ctrl+VPaste cell(s) from clipboard
Ctrl+plusInsert Paste – Paste cell and push content downward or rightward. Works great for entire rows and columns.
Ctrl+Alt+VOpen Paste Special Menu (requires a prior copy to Clipboard)
Ctrl+Alt+V, then V, EnterPaste Values
Ctrl+Alt+V, then T, EnterPaste Formats
Ctrl+Alt+V, then E, EnterPaste Transposed
Ctrl+Alt+V, then W, EnterPaste Column Width
Ctrl+Alt+V, then U, EnterPaste Values and Number Formats
F3Paste a defined name into a formula

Excel Find and Replace Shortcuts 

Keyboard Shortcuts (Windows)Menu Description
Ctrl+FDisplay the Find and Replace dialog box (with find selected)
Ctrl+HDisplay the find and replace dialog box (with replace selected)
EscClose the find and replace dialog Box (with focus on dialog box)
Shift+F4Find next (with search box closed)
Ctrl+Shift+F4Find previous (with search box closed)
Alt+Tab, or Ctrl+F/H when losing focusToggle focus between find/ replace dialog box and worksheet
Alt+FFind next with find dialog box active
Alt+IFind all with find dialog box active
* in search optionUse as Asterix for searching multiple characters
? in search optionsUse as wildcard for searching any single character, Use ‘~’ before ‘?’ when searching special characters.
 ~* searches for *
 ~~ searches for ~
 ~? searches for ?

Excel Ribbon Shortcuts 

Keyboard Shortcuts (Windows)Menu Description
10.1 Ribbon Shortcuts identical for Most Office Applications 
Ctrl+F1Minimize/ restore Excel ribbons
Alt+FFile Ribbon
Alt+HHome Ribbon
Alt+NInsert Ribbon
Alt+JDDraw Ribbon
Alt+GDesign Ribbon
Alt+WView Ribbon
Alt+RReview Ribbon
Alt+YHelp Ribbon
10.2 Excel-specific Ribbon Shortcuts 
Alt+MFormula Ribbon
Alt+AData Ribbon
Alt+BAdobe Ribbon (if installed)
Alt+LDeveloper Ribbon (if activated)

Other Excel Shortcuts 

Keyboard Shortcuts (Windows)Menu Description
11.1 Shortcuts for Autofitting Rows and Columns and Column Width/ Row Height 
Shift+Alt+Right Arrow with cell or cell range selectedGroup selected cells with option to group as Row- or Columns Group
Ctrl+Space, then Shift+Alt+Arrow RightGroup columns
Shift+Space, then Shift+Alt+Arrow RightGroup rows
Shift+Alt+Arrow LeftUngroup rows or columns
Alt+A, then HHide group (Collapse) via Data – Hide group
Alt+A, then JShow group (Expand) via Data – Show group*
Ctrl+8Hide Outline Symbols
11.2 Hyperlink Shortcuts 
Shift+F10, then 2x I, then EnterOpen hyperlink
Shift+F10, then RRemove one or multiple hyperlink(s)
Ctrl+KInsert or edit hyperlinK (for complete cell only)
11.3 Excel Comment Shortcuts 
Shift+F2Insert/ edit a cell comment
1x Escape when in Comment, then Arrow KeysMove comment
2x Escape when in CommentEscape comment editing and return to cell
Ctrl+Shift+OSelect all cells with comments
Shift+F10, then MDelete single comment (or multiple with multiple comments selected)
11.4 Data Forms Shortcuts 
Tab/Shift+TabMove to the next/ previous field which can be edited
Enter/Shift+EnterMove to the first field in the next/ previous record
Page Down/Page UpMove to the same field 10 records forward/ back
Ctrl+Page DownMove to a new record
Ctrl+Page UpMove to the first record
Home/EndMove to the beginning/ end of a field
11.5 Other Excel Shortcuts 
Shift+F7Display the thesaurus dialog box
F7Display the spelling dialog box
Alt+F, IEEnable Editing for protected view (File Info Enable Editing)
Alt+F4Close Excel
F1Help
Alt+’Style dialog box
Ctrl+F3Define a name or dialog
Ctrl+Shift+F3Create names from row and column labels
Alt+F1Create and insert chart with data in current range as embedded Chart Object
F11Create and insert chart with data in current range in a separate Chart Sheet
Alt+F11Open VBA editor window
Ctrl+F6Scroll between open workbooks
Alt+F8Display macro dialog box
  Keyboard Shortcuts for Tally 9

Well, there you have it, Microsoft Excel shortcuts list. You might not have known about these shortcuts. If I’ve left important something out in this list, feedback is appreciated and welcome on the Make A Public List.

Feel free to comment below.

Was this article helpful?
YesNo

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.