Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Spreadsheet > Visual Elements > Dialogs > Create Names from Selection Dialog
A newer version of this page is available. .
All docs
V18.2
WinForms Controls
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
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Product Information
Product Structure
Getting Started
Spreadsheet Document
Supported Formats
Cell Basics
Formulas
Defined Names
Data Binding
Data Validation
Data Presentation
Data Grouping
Pivot Tables
Charts and Graphics
Printing
Events
Mail Merge
Protection
Find and Replace
Visual Elements
Workbook
Worksheet
Cells
Rows and Columns
Formulas
Name Box
Pop-up Menus
Dialogs
Format Cells Dialog
Paste Special Dialog
Edit Hyperlink Dialog
Symbol Dialog
Create Table Dialog
Change Chart Type Dialog
Find and Replace Dialog
Encrypt Document Dialog
Password Dialog
Protect Workbook Dialog
Protect Sheet Dialog
User Permissions Dialog
Insert Function Dialog
Function Arguments Dialog
Name Manager
New Name Dialog
Create Names from Selection Dialog
Subtotal Dialog
Data Validation Dialog
Properties Dialog
Page Setup Dialog
Header and Footer Dialog
Create PivotTable Dialog
Move PivotTable Dialog
Change PivotTable Data Source Dialog
PivotTable Field List
PivotTable Field Settings Dialog
PivotTable Value Field Settings Dialog
PivotTable Sort Dialog
Insert Calculated Field Dialog
Insert Calculated Item Dialog
PivotTable Solve Order Dialog
PivotTable Options Dialog
New Formatting Rule Dialog
Conditional Formatting Rules Manager
Services
Keyboard Shortcuts
Examples
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Snap
TreeMap
Sunburst Control
Common Features
Get More Help
API Reference
Download CHM

Create Names from Selection Dialog

The Create Names from Selection dialog allows end-users to automatically create names for rows or columns in the selected range from values in the specified column (top or bottom) or row (left or right) in this range.

This approach requires the following steps.

  • Select a range of cells to be named, including a row or column that contains values to be used for generating names.

  • Press CTRL+SHIFT+F3 or click the Create from Selection button on the Formulas tab in the Ribbon UI.

    SpreadsheetControl_Formulas_DefinedNames

  • In the invoked Create Names from Selection dialog, select a row or column to use its cell values for creating names, and click OK.

    A name for each row or column in the selected range is generated from the corresponding cell value in the column or row specified in the Create Names from Selection dialog. Cells of the specified column or row are not included in named rows or columns.

SpreadsheetControl_DefinedNames_CreateNamesFromSelection

For an example on how to provide your spreadsheet application with a Ribbon UI, see the Getting Started topic.