ms Excel shortcut keys | All advanced Excel shortcuts 2020

We have assembled a rundown of some ms Excel  shortcut keys .In spite of the fact that you can do these moves physically, realizing these stunts will help spare you time so you can concentrate on the stuff that truly matters.

The table contains a list of some commonly used ms Excel  shortcut keys that work with your computers and software. It is highly recommended that all users should use these keys and try to remember them.

 

 
Shortcut Keys Description
Ctrl + * Move to next section of text
Ctrl + ; Enter the current date
Ctrl + ‘ Insert value of above cell into current cell
Ctrl + 5 Strikethrough highlighted selection
Ctrl + A Select all contents of worksheet
Ctrl + B Bold highlighted selection
Ctrl + C Copy selected text
Ctrl + D Fill
Ctrl + F Open find and replace options
Ctrl + F10 Maximize currently selected window
Ctrl + F6 Switch between open workbooks/windows
Ctrl + F9 Minimize current window
Ctrl + G Open go-to options
Ctrl + H Open find and replace options
Ctrl + I Italicize highlighted selection
Ctrl + K Insert link
Ctrl + N Open new document
Ctrl + O Open options
Ctrl + P Open print dialog box
Ctrl + Page up & Page Down Move between Excel® worksheets in the same document
Ctrl + S Save
Ctrl + Shift + ! Format number in comma format
Ctrl + Shift + # Format number in date format
Ctrl + Shift + $ Format number in currency format
Ctrl + Shift + % Format number in percentage format
Ctrl + Shift + ; Enter the current time
Ctrl + Shift + @ Format number in time format
Ctrl + Shift + ^ Format number in scientific format
Ctrl + Space Select entire column
Ctrl + Tab Move between two or more open Excel® files
Ctrl + U Underline highlighted selection
Ctrl + V Paste
Ctrl + W Close document
Ctrl + Y Underline selected text
Ctrl + Z Undo last action
Alt + = Create formula to sum all of above cells
Alt + Shift + F1 Insert new worksheet
Shift + F3 Open the Excel® formula window
Shift + F5 Bring up search box
Shift + Space Select entire row
F11 Create chart
F2 Edit the selected cell
F5 Go to a specific cell
F7 Spell check selected text and/or document

 

Read Also:

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here