Work with Formulas
The key combinations used to create formulas and names quickly are listed in the table below.
| Shortcut | Description |
|---|---|
| CTRL+SHIFT+ENTER | Creates an array formula. |
| CTRL+ENTER | Creates a shared formula. |
| ALT+PLUS (+) | Inserts the SUM function in the active cell. |
| SHIFT+F3 | Invokes the Insert Function dialog. |
| CTRL+ ` | Toggles between displaying cell values and formulas on a worksheet. |
| CTRL+SHIFT+U | Toggles between expanding and collapsing the Formula Bar. |
| F4 | Cycles through all the various types of cell references, when a cell reference is selected or edited in the Formula Bar or cell in-place editor. |
| F9 | Calculates the entire workbook. |
| SHIFT+F9 | Calculates the active worksheet. |
| CTRL+ALT+F9 | Calculates the entire workbook, regardless of whether its data has changed since the last calculation. |
| CTRL+ALT+SHIFT+F9 | Calculates the entire workbook, regardless of whether its data has changed since the last calculation, and rebuilds the dependencies. |
| CTRL+F3 | Invokes the Name Manager dialog to define a name. |
| CTRL+SHIFT+F3 | Creates names from row and column labels. |