Define and use names in formulas

In Excel, Named Ranges make your formulas easier to read and manage. Instead of using cell references like A1:A10, you can define a name like SalesData and use that in your formulas.

✅ How to Define a Name

Method 1: Using the Name Box

1. Select the range (e.g., A1:A10).
2. Click in the Name Box (left of the formula bar).
3. Type a name (e.g., SalesData) and press Enter.

Method 2: Using the Name Manager

1. Go to Formulas > Name Manager > New.
2. Enter:
   • Name: SalesData
   • Refers to: =Sheet1!$A$1:$A$10
3. Click OK.

✅ Rules for Naming

• Must start with a letter (A-Z)
• Can include letters, numbers, underscores
• No spaces (use underscore _ or CamelCase)
• Can’t look like a cell reference (A1, B2, etc.)

✅ Using Named Ranges in Formulas

🔹 Example 1: Sum a named range

=SUM(SalesData)

🔹 Example 2: Average a named range

=AVERAGE(SalesData)

🔹 Example 3: Use multiple names

If you have another named range like Costs, you can subtract:

=SUM(SalesData) - SUM(Costs)

✅ Managing Names

Go to Formulas > Name Manager to:

• View all names
• Edit or delete them
• See what they refer to