100+ Microsoft Excel Keyboard Shortcut keys- {Keyboard Shortcuts}

Microsoft Excel: Microsoft Excel helps to create, view, and edit files. With Excel, you can create charts, spreadsheets, and so on. To make your work easier there are certain shortcut keys, using those keys you can finish your work in a trice. If you are looking for Microsoft Excel Keyboard Shortcut keys-{100+Keyboard Shortcuts}, you have come to the right place. Read further to know more.

Microsoft Excel Keyboard Shortcut keys
Microsoft Excel Keyboard

Microsoft Excel Keyboard Shortcut keys-{100+Keyboard Shortcuts}

General Keyboard Shortcuts:

Shortcut keys Action
Ctrl+N To open a new file, use this key.
Ctrl+O This key is to open a file.
Ctrl+S Save file shortcut key.
Ctrl+F6 Key to move between open workbooks.
Ctrl+F4 This key is to close the file.
F12  Save as shortcut key.
Ctrl+P  For to display the print menu use this shortcut key.
Ctrl+A  To select a whole worksheet use this shortcut key.
Ctrl+Space To select a column, use this key.
Shift+Space Use this shortcut key to select a row.
Ctrl+Z  Undo shortcut key.
Ctrl+Y Redo shortcut key.
= To start a formula, use this key.
Alt+F4 In order to exit excel, use this shortcut key.

Microsoft Excel Keyboard Navigating shortcuts:

Shortcut keys Action
Tab Use this key to move to the next cell in a row.
Shift+Tab Use this key to move to the previous cell in the row.
Page Up This shortcut key is to up one screen.
Page Down Use this key to Down one screen.
Ctrl+Page Down It will move to the next worksheet.
Ctrl+Page Up This key is to move to the previous worksheet.
Ctrl+Home Use this key to go to the first cell in the data region.
Ctrl+End To Go to the last cell in the data region, use this key.

Formatting Text Shortcut key:

Shortcut key Function
Ctrl+B This key is to Bold toggle for selection.
Ctrl+I Shortcut key for Italic toggle for selection.
Ctrl+U Underline toggle for selection.
Ctrl+5 This shortcut key is to strike through for selection.
Ctrl+Shift+F To change the font, use this key.
Ctrl+Shift+P Use this key to change the font size.
Ctrl+Shift+7 To Apply outline borders, use this key.
Ctrl+Shift+Underline For to remove all borders, use this key.
Alt+Enter This key is to wrap text in the same cell.

Microsoft Excel Keyboard Shortcut keys for formatting cells :

Shortcut keys Action
Ctrl+1 Format cell shortcut key.
Ctrl+Shift+F Shortcut key to select a font.
Ctrl+Shift+P To select a point, size, use this key.
Ctrl+Shift+4  This shortcut key is to format as currency.
Ctrl+Shift+# To Format as general for to remove formatting use this shortcut key.
Ctrl+Shift+5 Use this key to format as a percentage.
Ctrl+Shift+1 To Format as a number, use this key.

Microsoft Excel Keyboard Shortcut keys for editing and deleting:

Shortcut key Used to
Delete Use this key to delete one character to the right.
Backspace Use this key to delete one character to left.
F2 To Edit active cells, use this key.

Escape Key
This key is to cancel cell entry.

Microsoft Excel Keyboard Shortcut keys for highlighting cells:

Shortcut keys Function
Ctrl+E To select the entire worksheet, use this key.
Shift+Spacebar Use this key to select the entire row.
Ctrl+Spacebar For to select the entire column, use this key
Shift+←↑→↓ To Manually select, use this key.

Shortcut key for copying and moving:

Shortcut key Function
Ctrl+C Copy shortcut key.
Ctrl+X To cut the selected text, use this shortcut key
Ctrl+V Paste shortcut key.

Shortcut keys for inserting text automatically:

Shortcut keys Action
Alt+= Use this key to Auto sum a range of cells.
Ctrl+; To insert the date, use this shortcut key.
Ctrl+Shift+; To insert the time, use this shortcut key.
Ctrl+Shift++ Shortcut key to insert columns/rows.
Shift+F11 Shortcut key to insert a new worksheet.

Microsoft Excel Keyboard Misc Shortcut key:

Shortcut key Action
Ctrl+F Find text shortcut key.
Ctrl+H To replace a text dialog, use this key.
F11 Use this key to create a chart automatically on a new sheet.
Shift+F2 Shortcut key to edit a cell comment.

Excel Main Jaws keystrokes – 1:

Shortcut key Function
Ctrl+Shift+V This key is to Show the Version of Excel.
Ctrl+Page Down Use this key to Move to Next Sheet.
Ctrl+Page Up To Move to Prior Sheet.
Ctrl+G For to Go to a cell command, use this key.
Shift+Backspace To Collapse Selection To Active Cell.
Insert+C This key is to Show Active Cell Coordinates.
Alt+= Auto Sum shortcut key.
= Formula Mode shortcut key.
Ctrl+; To Insert Date In the Current Cell, use this key.
Ctrl+Shift+; To Insert Time In Current Cell, use this key.
Alt+1 This key is showing the Current Column, First Cell From Top.
Alt+2 This key shows the Current Column, Second Cell From Top.
Alt+3 Key shows the Current Column, Third Cell From Top.
Alt+4 Key shows the Current Column, fourth Cell From Top.

Excel Main Jaws keystrokes – 2:

Shortcut keys Action
Ctrl+ Data Region Left shortcut key.
Ctrl+ Data Region, Right shortcut key.
Ctrl+ This key is to move to the data Region Down.
Ctrl+ Data Region Up shortcut key.
Ctrl+Shift+8 Use this key to Select the Whole Data Region.
Ctrl+F2 This key shows the formula.
F7 Spell Check shortcut key.
Alt+Shift+G Key to Report Gridline Status.
Insert+Delete This key reads Row Total.
Insert+Enter This key reads Column Total.
Alt+Shift+C To know the column tile, use this key.
Alt+Shift+R Use this key to know the row title.
Alt+Shift+V For to show Visible Range Coordinates.
Tab To Cycle Through Controls in a Dialog Box, use this key.
Shift+Tab Tab Backwards shortcut key.
Ctrl+Shift+ This key List Cells With Comments.

Excel Main Jaws keystrokes – 3:

Shortcut keys Action
Alt+Ctrl+2 This key shows the Row Second Cell From Left.
Alt+Ctrl+1 Key to show the Row First Cell From Left.
Alt+Ctrl+3 This key shows the Row Third Cell From the Left.
Alt+Ctrl+4 Key to show the Row Fourth Cell From Left.
Alt+Shift+B Describes the Cell Border.
Alt+Shift+ To Read Cell Comment, use this shortcut key.
Alt+Shift+A Auto Filter shortcut key.
Alt+Shift+H To Read Cell, Hyperlink us this key.
Ctrl+Insert+F4 Close Office Assistant.
Alt+Ctrl+Shift+1 Key sets Monitor Cell One.
Alt+Ctrl+Shift+2 This key Sets Monitor Cell Two.
Alt+Ctrl+Shift+3 Key Set Monitor Cell three.
Alt+Ctrl+Shift+4 This key Sets Monitor Cell Four.
Alt+Ctrl+Shift+5 Key Sets Monitor Cell Five.

Excel Main Jaws keystrokes – 4:

Alt+Ctrl+Shift+6 Set Monitor Cell Six shortcut key.
Alt+Ctrl+Shift+7 Set Monitor Cell Seven shortcut key.
Alt+Ctrl+Shift+8 This key Sets Monitor Cell Eight.
Alt+Ctrl+Shift+9 Set Monitor Cell Nine shortcut key.
Alt+Ctrl+Shift+0 This key Sets Monitor Cell ten.
Alt+Shift+1 Shortcut key to read Monitor Cell One.
Alt+Shift+2 Read Monitor Cell Two.
Alt+Shift+3 Shortcut key to read Cell Three.
Alt+Shift+4 Shortcut key to read Cell Four.
Alt+Shift+5 Read Monitor Cell Five.
Alt+Shift+6 Shortcut key to Cell Six.
Alt+Shift+7 Read Monitor Cell Seven.
Alt+Shift+8 Read Monitor Cell Eight.

Excel Main Jaws keystrokes – 5:

Alt+Shift+9 Shortcut key to read Cell Nine.
Alt+Shift+0 Read Monitor Cell Ten.
Ctrl+Shift+D To list Visible Cells With Data, use this key.
Ctrl+Shift+C Use this shortcut key to List Data In the Current Column.
Ctrl+Shift+R To List Data in the Current Row, use this shortcut key.
Ctrl+Shift+H Select Hyperlink shortcut key.
Ctrl+Shift+S To Move To the Worksheet List box, use this shortcut key.
Ctrl+Shift+M To Move To Monitor Cell, use this shortcut key
Ctrl+Shift+O  For to Select Worksheet Objects.
Ctrl+Shift+B This key is to List Cells At Page Breaks.
Insert+V Options List box Shortcut key.


In this guide, we have listed the Microsoft Excel Keyboard Shortcut keys-{100+Keyboard Shortcuts} with their function in detail. To know more, read further. If you have any suggestions or questions regarding this article, let us know in the comment section, we will update it to you shortly.

Leave a Comment