Create Names from Selection Dialog

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

DXSpreadsheet_Dialogs_CreateNamesFromSelection

This approach requires the followings 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 (Refer to the Lesson 1 - Create a Simple Spreadsheet topic for details on how to provide a Ribbon UI for the SpreadsheetControl).

    DXSpreadsheet_Dialogs_CreateNamesFromSelection_Ribbon

  • In the invoked Create Names from Selection dialog, select a row or column to use its cell values for creating names, and click OK. The selected row/column cells are not included in named rows or columns.

DXSpreadsheet_Dialogs_CreateNamesFromSelection_Scheme

See Also