Here is a list of most useful and common shortcuts used in microsoft excel.These shortcut or hotkeys will help you to work in excel at lightning speed .
|
Shortcut Key |
Functions |
|
F2 |
Edit the selected cell |
|
F5 |
Goto a specific cell. For example, C6. |
|
F7 |
Spell check selected text and/or document |
|
F11 |
Create chart |
|
Ctrl + Shift + ; |
Enter the current time |
|
Ctrl + ; |
Enter the current date |
|
Alt + Shift + F1 |
Insert New Worksheet |
|
Shift + F3 |
Open the Excel formula window |
|
Shift + F5 |
Bring up search box |
|
Ctrl + A |
Select all contents of the worksheet |
|
Ctrl + B |
Bold highlighted selection |
|
Ctrl + I |
Italic highlighted selection |
|
Ctrl + K |
Insert link |
|
Ctrl + U |
Underline highlighted selection |
|
Ctrl + 5 |
Strikethrough highlighted selection |
|
Ctrl + P |
Bring up the print dialog box to begin printing |
|
Ctrl + Z |
Undo last action |
|
Ctrl + F9 |
Minimize current window |
|
Ctrl + F10 |
Maximize currently selected window |
|
Ctrl + F6 |
Switch between open workbooks / windows |
|
Ctrl + Page up |
Move between Excel work sheets in the same Excel document |
|
Ctrl + Page down |
Move between Excel work sheets in the same Excel document |
|
Ctrl + Tab |
Move between Two or more open Excel files |
|
Alt + = |
Create a formula to sum all of the above cells |
|
Ctrl + ‘ |
Insert the value of the above cell into cell currently selected |
|
Ctrl + Shift + ! |
Format number in comma format |
|
Ctrl + Shift + $ |
Format number in currency format |
|
Ctrl + Shift + # |
Format number in date format |
|
Ctrl + Shift + % |
Format number in percentage format |
|
Ctrl + Shift + ^ |
Format number in scientific format |
|
Ctrl + Shift + @ |
Format number in time format |
|
Ctrl + Arrow key |
Move to next section of text |
|
Ctrl + Space |
Select entire column |
|
Shift + Space |
Select entire row |
Make some difference learn all the hotkeys of other Softwares also…Â
