| Tab | Autocomplete the function name. Example: Enter = and start typing vl, press Tab and you will get =vlookup |
| F4 | Cycle through various combinations of formula reference types. Place the cursor within a cell and hit F4 to get the needed reference type: absolute, relative or mixed (relative column and absolute row, absolute column and relative row). |
| Ctrl + ` | Toggle between displaying cell values and formulas. |
| Ctrl + ‘ | Insert the formula of the above cell into the currently selected cell or the Formula Bar. |
