Short Cut key of MS.Excel

Short Cut of Excel
Ctrl + N
New spreadsheet
Ctrl + W
Close a spreadsheet
Ctrl + O
Open a spreadsheet
Ctrl + S
Save a spreadsheet
Ctrl + C
Copy
Ctrl + V
Paste
Ctrl + X
Cut or Move
Ctrl + B
Bold
Ctrl + 1
Change the format of selected cells
Ctrl + 5
Strike through highlighted
Ctrl + P
Bring up the print dialog box
Ctrl + A
Select all contents
Ctrl + I
Italic
Ctrl + K
Insert link
Ctrl + U
Underline
Ctrl + Z
Undo
Ctrl + F6
Switch between open workbooks
Ctrl + F10
Maximize currently window
Ctrl + F3
Open excel name manager
Ctrl + F9
Minimize currently window
Ctrl + Shift + ;
Enter the current time
Ctrl + ;
Enter the current date
Ctrl + Page up
Move between work sheet in the same documents
Ctrl + Page down
Move between work sheet in the same documents
Ctrl + Tab
Move between Two or more open excel files
Ctrl + Space
Select entire column
Ctrl + -
Delete the selected column or row
Ctrl + Shift + =
Insert a new column or row
Ctrl +
Home move to cell A1
Ctrl + Shift + 1
Format number in comma format
Ctrl + Shift + 2
Format number in time format
Ctrl + Shift + 3
Format number in date format
Ctrl + Shift + 4
Format number in currency format
Ctrl + Shift + 5
Format number in percentage format
Ctrl + Shift + 6
Format number in scientific format
Ctrl + Arrow key
Move to next section of text
 Alt + H
Go to the Home
Alt + N
Go to insert tab
Alt + A
Go to Date tab
Alt + W
Go to View tab
Alt + =
Create a formula to sum a;; of the above cells
Alt + Shift + F1
Insert new worksheet
Alt + Enter
Will move to the next line. allowing for multiple lines of text in one cell.
F1
For Help from Internet
F2
Edit the select cell
F3
Paste names
F4
Repeat last action
F5
Go to the specific cell
F7
Spell Check
Shift + F3
Open the excel formula window
Shift + F5
Search box
Shift + Space
Select entire row
More Information=>Email-mskhan6120@gmail.com
Don’t Call me, Only What’s app Massage .8533048733

Comments