Define Names with the Create from Selection Tool in Excel (2 Examples)

There are a lot of built-in tools in Excel which make our work easier and increase the work speed. If we use names, we can make your formulas much easier to understand and maintain. We can define a name for a cell range, function, constant, or table. If you get used to the practice of using names in your workbook then you can easily update and manage these names. In this article, I’ll introduce you to the Create from Selection tool of Excel to define names.


Download Practice Book

You can download the free Excel template from here and practice on your own.


What is Create from Selection Tool in Excel?

Create from Selection tool is used to define the names of a data range. We can create a name for a cell or a range of cells in Excel manually. But if our range of cells has headers then we can easily set the name using Create from Selection tool from the Formula ribbon and the defined name will be the header name. Let’s see how to do it. For that, I have made a dataset that represents some salespersons’ sales of two consecutive months.

For a column:

Step 1: 

➥ Select the data range of the column including the header.

➥ Then click as follows: Formulas > Defined Names > Create from Selection

Create from Selection Tool in Excel

A dialog box will appear and it will tell you to select the option from where it will pick the name. Basically, Excel detects it automatically.

Step 2:

➥ Now just press OK as our header is in the top row which is marked already.

Create from Selection Tool in Excel

Step 3:

➥ Later, press the drop-down sign from the cell name box.

Create from Selection Tool in Excel

Take a look that it is showing the name for the column.

Create from Selection Tool in Excel

To do it for a row is like the same just select a row instead of selecting a column and the rest of the steps are quite the same.

For a whole dataset:

Step 1:

➥ Select the dataset B4:D12

➥ Again click: Formulas > Defined Names > Create from Selection

Create from Selection Tool in Excel

Step 2:

➥ Mark on the options which you want to select as names.

Step 3:

➥ Then click the drop-down icon and it will show all the defined names.


Examples of Using Create from Selection Tool in Excel

After creating the name of a data range using Create from Selection tool we can use the defined names directly to a formula rather than using cell references which will save a lot of time.

Example 1:

In the first example, I’ll calculate the average sales of March with the AVERAGE function using the defined names created by the Create from Selection tool. The AVERAGE function is used to evaluate the average value of a data range.

Steps:

➥ By activating Cell D14 type the formula given below-

=AVERAGE(March)

➥ Then hit the Enter button to get the result.

Examples of Using Create from Selection Tool

 

Here’s the calculated average-

 


Example 2:

Now let’s find the sum with the SUM function for Ron using the defined name. The SUM function is used to calculate the sum for a data range.

Steps:

➥ Activate Cell D14

➥ Type the formula given below-

=SUM(Ron)

➥ Finally, just hit the Enter button.

Examples of Using Create from Selection Tool

 

Soon after you will see the sum of Rons’ total sales is calculated.

 


Conclusion

I hope all of the methods described above will be good enough to use create from selection tool in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo