Explanation

A Named Range allows you to give a meaningful name to a cell or range.

Instead of using:

=$F$1

you can name the cell:

TaxRate

Then use:

=B2*TaxRate

Example

Cell

Value

Name

F1

18%

TaxRate

F2

10%

Discount Rate

F3

5%

Commission Rate

Creating a Named Range

  1. Select the cell/range.
  2. Go to the Name Box.
  3. Type a name.
  4. Press Enter.

Alternatively:

Formulas → Define Name

Name Manager

Formulas → Name Manager allows you to:

  • Create names
  • Edit names
  • Delete names
  • View existing names

Example

=B2*TaxRate

is easier to understand than:

=B2*$F$1

Practice

Create named ranges for:

  • Tax Rate
  • Discount Rate
  • Commission Rate

Use them in a Sales Calculation Sheet.

PreviousNext