Advanced microsoft excel hortcut keys and formulas
The following is the shortcut key for the Excel sheet to speed up your work. Which will be useful to you. Watch the end with thought and finish your work faster.
 |
| Microsoft excel |
F2 âž Edit the selected cell.
F5 âž Go to a specific cell. For example C6.
F7 âž Spell check selected text and document.
F11 âž Create chart.
Ctrl + Shift + ; âž Enter the current time.
Ctrl + ; âž Enter the current date.
Ctrl + Shift + F1 âž Inser 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 workbooks / window.
Ctrl + F6 âž Switch between open workbooks / window.
Ctrl + Page up âž Move between excel worksheet in the same excel document.
Ctrl + Page down âž Move between excel workheet in the same excel document.
Ctrl + Tab âž Move between two or more open excel file.
Ctrl + = âž 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 formet.
Ctrl + Space âž Select entire column.
