Whenever I work with spreadsheets, there’s no escaping the fact that I have to work with a lot of ranges.

Some of these ranges I have to reuse time and time again to create different calculations!

Good thing there are Named Ranges in Excel!

By using a Named Range, you can make your formulas much easier to understand and maintain.

You can define a name for a cell range, function, constant, or table.

Let us work with the following table below.Â  We want to populate the Euro Amounts and the Sum of the USD columns:

Let us go over how to do this in the tutorial below:

STEP 1:Â Let us create our firstÂ Named Range.Â

Highlight the USD Amounts and type in theÂ Name Box a name: Amounts

Make sure that there are no spaces.Â  PressÂ Enter.

Let us do the same to our Euro Exchange Rate. Highlight the exchange rate, and type in theÂ Name BoxÂ a name:Â EuroRate

PressÂ Enter.

STEP 2:Â Let us see our Named Ranges in action!

To calculate the Euro Amount column, type in: =A9 * EuroRate.

This will use our EuroRate Named Range!

Drag your formula below to the rest of the column to get the amounts calculated:

STEP 3:Â To calculate the sum of the Sum of USD column, type in: =SUM(Amounts).

This will use our Amounts Named Range!

And now you have your total!

STEP 4:Â If you want to check all the Named Ranges you created, go toÂ Formulas > Defined Names > Name Manager

You can edit your Named Ranges in here or delete them as well.

How to Create a Named Range in Excel

If you like this Excel tip, please share it

email

Pinterest