When using the 'Create from Selection' feature, what is typically used to name the new cells?

When using the 'Create from Selection' feature in Excel, the new named cells are typically derived from the titles in the first row or column of the selection. This feature automatically assigns names to the selected ranges based on the labels found in adjacent cells.

For instance, if a user has a set of data where the first row contains headings like "Sales," "Revenue," and "Profit," using 'Create from Selection' will leverage these titles to name the corresponding ranges. This makes the created names intuitive and meaningful, enhancing usability when referencing those ranges in formulas or functions.

In contrast, cell values from the data would not provide meaningful names for the ranges and could lead to confusion. Specific user-defined ranges could create inconsistent naming within the worksheet, and an automated numbering system would not convey the context of the data, making it less practical for data analysis and reporting tasks. Thus, utilizing the first row or column titles provides clarity and context to the named ranges.