Set multiple named ranges feature image

Set Multiple Named Ranges in Excel

Setting named ranges in Excel is a very handy feature. However, if you have many names to set from a worksheet, this can take a considerable amount of time. You may think to automat this with some VBA code, but before you do, you should check out a feature from Excel that allows you to set multiple named ranges at the same time. This is a very handy feature and can save you a lot of time.

Check out the video below to see how this works.

Video Summary

Setting multiple named ranges is fast and straight-forward. You begin by having data like this:

Set Multiple Named Ranges - Table

And say you wanted to set the Value column to have the names of the Data column as their named range? For example, B2 could be named “Item_1”, B3 could be named “Item_2”, etc. How would you go about doing that?

Set Multiple Named Ranges at the Same Time

The simple solution to this is to use a built-in feature by Excel called “Create from Selection” under the Formulas tab within the Named Ranges group.

Simply select the data that has the names along with the values you want to apply those names to, then click on the Formulas tab, then “Create From Selection.” Excel will automatically figure out what names you’d like to apply. Here is a gif illustrating this:


Set Multiple Named Ranges at the Same Time

You’ll see that the named ranges have been applied to the values in the table. This is a nice way to set a bunch of named ranges quickly in Excel.

Are you ready to master Excel Dashboards?

Learn Excel Dashboard Course Power BI Webinar

Still not convinced? Check out my review of the course!

  • Eric Lacroix

    Great function that I never knew about it. I’ always amaze that as good as I am there’s always something to learn from Excel.

    • Joseph

      I’m right there with ya. Once-in-a-while I find a button on the ribbon I haven’t tried before and learn something new. Funny how it seems to hide in plain site 🙂