Names in Excel Formulas

Formula Using Names

Naming a range or a constant enables you to use the defined name in formula instead of full range.

To have a clear understanding of this concept, follow the steps below:

1. Select a range of cells on your MS Excel sheet

Select a range of cells

2. On Formula Tab, under the Defined Name group, click and select Define Name

Define Name

3. Under the New Name window, give your selected range a name and click OK

click OK

4. Click on Cell A5 and type following formula

Click on Cell A5

5. The above formula will sum up all the values assigned to the Named Range

formula will sum up all

Shortcodes Ultimate

Follow Us