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 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.
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.
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:
Excel Main Jaws keystrokes – 4:
Excel Main Jaws keystrokes – 5:
Verdict:
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.
