Work with Formulas

• Jun 20, 2018

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.