Useful Microsoft Excel Shortcut keys | Excel shortcuts:
Microsoft office software has been widely used by all us now a day. Most of the corporate companies use MS office tools for their operations. In this Microsoft Excel has plays a vital role in everyone life. It was used to maintain data, data entry purposes, accounting, and much more. We can insert formulas between the cells and find the answer easily.
Every Excel users should know excel shortcut keys in order to fasten their works, these shortcut keys will make you perform much better than before.
Microsoft Excel Shortcut keys:
Keys
|
Functions
|
F2
|
To Edit the selected cell.
|
F3
|
To paste names after creating name
|
F4
|
To repeat action
|
F5
|
To go to specific cell
|
F7
|
To check the spelling for selected text
|
F11
|
To create the chart for the selected data
|
Ctrl + ;
|
To enter the current date
|
Ctrl + Shift + ;
|
To enter the current Time
|
Ctrl + 1
|
To open the format cell window
|
Ctrl + A
|
To select all the content
|
Ctrl + B
|
To make the selected content Bold
|
Ctrl + I
|
To make the selected content Italic
|
Ctrl + K
|
To insert link
|
Ctrl + S
|
To save the worksheet
|
Ctrl + U
|
To underline the selected content
|
Ctrl + 5
|
To Strikethrough the selected selection
|
Ctrl + P
|
To open the print window
|
Ctrl + Z
|
To undo the action
|
Ctrl + F3
|
To open the Excel name manager
|
Ctrl + F9
|
To minimize the current window
|
Ctrl + F10
|
To maximize the current window
|
Ctrl + F6
|
To switch between two opened workbooks.
|
Ctrl + Page up
|
To move between the two opened work sheets
|
Ctrl + Page Down
|
To move between the two opened work sheets
|
Ctrl + Tab
|
To move between two or more opened excel files
|
Ctrl + ‘
|
To insert the value of the above cell into the current selected cell
|
Ctrl + Shift + !
|
To format number in comma format
|
Ctrl + Shift + $
|
To format number in currency format
|
Ctrl + Shift + #
|
To change the number format to date format
|
Ctrl + Shift + %
|
To change the number format to percentage format
|
Ctrl + Shift + ^
|
To change the number format to scientific format
|
Ctrl + Shift + @
|
To change the number format to time format
|
Ctrl + Shift + =
|
To insert the selected column or row
|
Ctrl + -
|
To delete the selected column or row
|
Ctrl + Home
|
To move the cell A1
|
Ctrl + ~
|
To switch between the showing excel formulas or values in the cell
|
Alt + Shift + F1
|
To add new work sheet
|
Alt + =
|
To create formula to sum the above cells
|
Alt + Enter
|
To allow multiple lines in single cell
|
Shift + F3
|
To open the excel formula window
|
Shift + F5
|
To open the search box.
|
These are the most useful excel keyboard shortcut keys, that will be more helpful in your day today life.
More Shortcut tips:
0 comments:
Post a Comment