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.
