How To Create Named Ranges in Excel

0

Creation of named ranges are explained in deep as we have already seen in the vlookup tutorial.

Previously when we were using excel 2003 this named range was used frequently to automate the excel activities using Excel macros. In stead of ranges, we were using the named ranges as those fixed with particular range of cells, rows or columns. In order to create named range, we just need to select the required range of cells that you want to name, then go to cell address bar and give the desired name, once you give press enter tab. That’s it next if you select that range, you can see the given name for that range in the same cell address bar. You can check the below screen shot for your reference.

Named Range
Named Range

This is the simple method which we can use. we have another method for creating the named range. That option is available in the Formulas Menu -> Name Manager. You can click the name manger and select the desired sheet and range of cells in the respective text boxes which will be available in the Name Manger option, then you can give the desired name. You can check the below screen shots for your understanding purpose.

Name Manager option
Name Manager option

Once you get the above name manager option, you can click the new option or edit option(if you want to change any given name) to name the range of cells, rows or columns as per your requirement. Once you click the new or edit option in the name manger, you get the below option box

Naming the range in the Name Manager Option
Naming the range in the Name Manager Option

Hope you understand basic excel option named range. If you have suggestion, please comment in the below comment box to encourage us.

LEAVE A REPLY

Please enter your comment!
Please enter your name here