Create From Selection Excel Technique: Name Multiple Cells Quickly

If you follow my blog or have read my ebook, you know that I’m a big fan of using Named Cells to make cell formulas easier to write and read. Usually, this is done by selecting the cell, clicking in the name box, and typing the cell name. This can be a slow process, but it’s really quick when you use “Create from Selection” in Excel.

Create From Selection in Excel: Quickly Create Named Cells

To ease the pain of creating cell names one-by-one, you can create cell names from a selection, instead, using the “Create from Selection” tool.

The tool is located in the Formulas menu in the “Defined Names” group.

create from selection excel ribbon

Are you struggling to the find the right solutions to your engineering problems in Excel?

In Engineering with Excel, you’ll learn Excel for advanced engineering calculations through a step-by-step system that helps engineers solve difficult problems quickly and accurately.

Naming Individual Cells

To use this tool, first enter the names of the cells in a column next to the cells themselves:

create from selection excel table

Next, select both the cells containing the names and the cells to be named, and open the tool from the Formulas tab.

create from selection excel

Finally, choose the appropriate position for the cells containing the names, and click OK. In my case, the names were to the left of my cells, but you could also choose top row, bottom row, or right column depending on how you’ve laid out your spreadsheet.

excel named cell

This way of adding names to cells has a couple of advantages. In addition to being more efficient, it also provides good visibility to the names of the cells for future reference.

Naming Arrays with Create from Selection

This method also works for arrays too.

If the values are arranged in a vertical array, add the name to the cell just above all of the values.

create from selection array excel

Then select the cell containing the name and all of the cells in the array of values. Finally, in the “Create from Selection” tool, choose “Top Row” instead.

Of course, if your data is in a horizontal array, add the name to the left cell and choose “left column” instead.

Are you struggling to the find the right solutions to your engineering problems in Excel?

In Engineering with Excel, you’ll learn Excel for advanced engineering calculations through a step-by-step system that helps engineers solve difficult problems quickly and accurately.

Scroll to Top
Complete... 50%
Please enter your name and email address below to receive a link to the ebook.

You’ll also receive regular tips to help you master Excel for engineering.

Complete... 50%

SIGN UP BELOW TO GET STARTED!

You’re almost there! Please enter your email address below to get started with your free training:

FREE EBOOK:

10 SMARTER WAYS TO USE EXCEL FOR ENGINEERING

By Charlie Young, P.E.

Take your engineering to the next level with advanced Excel skills.

EXCEL TRAINING FOR ENGINEERS

Learn advanced engineering techniques in Excel with this limited time free video training.

Click the button below to get started today.