Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Spreadsheet > Keyboard Shortcuts > Work with Formulas
All docs
V23.2
WinForms Controls
.NET/.NET Core Support
Prerequisites
What's Installed
Build an Application
Controls and Libraries
Forms and User Controls
Messages, Notifications, and Dialogs
Editors and Simple Controls
Ribbon, Bars and Menu
Application UI Manager
Docking Library
Data Grid
Vertical Grid
Property Grid
Pivot Grid
Tree List
Gantt Control
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Product Information
Spreadsheet Control API
Get Started
Spreadsheet Document
Supported Formats
Cell Basics
Formulas
Defined Names
Data Binding
Data Validation
Data Presentation
Data Grouping
Tables
Pivot Tables
Charts and Graphics
Form Controls
Printing
Events
Mail Merge
Protection
Operation Restrictions
Find and Replace
Visual Elements
Services
Keyboard Shortcuts
File Operations
Navigation inside Worksheets
Work with Selections
Copy, Paste and Edit the Cell Content
Cell Formatting
Work with Columns and Rows
Sort and Filter
Work with Formulas
Examples
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Office File API
Snap
TreeMap Control
Sunburst Control
Sankey Diagram Control
Heatmap Control
Common Features
Security Considerations
UI Templates
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

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.