# How to use Name Ranges in Excel || Learn Excel Tips

The instructional exercise clarifies what an Excel name is and demonstrates to characterize a name for a cell, range, steady or equation.

Names in Excel are an incomprehensible thing: being a standout amongst the most valuable highlights, they are frequently viewed as futile or geeky. The reason is that not very many clients comprehend the pith of Excel names. This instructional exercise won’t just show you how to make a named run in Excel, however, will likewise demonstrate to use this element to make your equations substantially less demanding to compose, read, and re-utilized.

## What is a Named Range?

Name range is a term that is just a descriptive or meaningful name given to a set of data, that can be used for a range of cells, for any specific value or a particular formula. Here below we have shown a list or a range of some Quantity cells is given a Named range as Quantity, which we can directly use to access this whole list by a single name “Quantity”. Like Suppose, we want to find out the maximum quantity out of the list, then we simply use the MAX Function and define it as,

=MAX(Quantity) rather than MAX(B2:B7)

And it will simply give us the results.

## How we create a Named Range?

Follow these simple steps to create a named range:

• To create a named range, just go to the formula bar in the Top left of Excel window.
• Then click on the Name box.
• Type a meaningful name for your list.
• And just press the Enter, and you are good to go.

### How can we make Excel create the Named Range Automatically?

On the off chance that you have very much organized information with marks, you can have Excel make named ranges for you. Simply select the information, alongside the marks, and utilize the “Create from Selection” feature on the Formulas tab of the Excel ribbon.