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 |