Creating Names From A Selection In Excel

Here is how to create named cells or named ranges by using the Create from Selection option in Excel:

(Note: Video version above, text version below)

Text version (note: click on an image for a better view):

Named ranges are very useful in Excel in formulas. It eliminates having to worry about selecting the correct cell or cells, or ensuring you have created absolute cell references rather than relative ones. If you have a group of cells that you need to name based on the labels for those cells, you can use the Name Manager and enter each one individually, or you can select each one and type the name in the Name Box. But to do a group all at once, you can use the option on the Formulas tab in the Defined Names group called Create from Selection:


Just highlight the range (in our case G2:H4), click on Create from Selection, and in the dialog box, select “Left Column” then click OK:


You’ll now see that these names are individually listed in the Name Manager:


The same would be the case for a list of items. For instance, we want to create a name for our Sales team. Just highlight the column of data including the header, and click on “Create from Selection”:


And Voila! There you have it:


Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

One Response to Creating Names From A Selection In Excel

  1. Aniruddh November 12, 2013 at 11:31 am #

    I know, how to create named ranges. But I was not aware that, we can create named ranges from selection. Thanks a lot. It saves a lot of time when we need to create named ranges.

Leave a Reply