| To repeat the last action | F4 |
| To calculate the worksheet in all open workbook | Ctrl+Alt+F9 |
| To rechecks dependent formula | Ctrl+Alt+Shift+F9 |
| To define the name | Ctrl+F3 |
| To create the names in row and column | Ctrl+Shift+F3 |
| Sum Function | Alt+= |
| To display formula | Ctrl+` |
| To insert the argument names into formula | Ctrl+Shift+A |
| To copy the formula from cell above | Ctrl+’ |
| To paste the name into formula | F3 |
| To evaluate the part of formula | F9 |
| To paste function into formula | Shift+F3 |
| To go to last position | Ctrl+Shift+F2 |
| To step out | Ctrl+Shift+F8 |
| To clear all breakpoints | Ctrl+Shift+F9 |
| To Enter the Formula as an Array formula | Ctrl+Shift+Enter |
| Toggle Expand or Collapse formula bar | Ctrl+Shift+U |
Basic shortcuts in excel
