| Shortcut | Description |
| Ctrl + 1 | Open the “Format Cells” dialog. |
| Ctrl + T | “Convert selected cells to a table. You can also select any cell in a range of related data, and pressing Ctrl + T will make it a table. Find more about Excel tables and their features. |
| Shortcut | Description |
| 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. |
