Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.