By Ted French

**Cell References in Formulas**

While the formula in the previous step works, it has one drawback. If you want to change the data being calculated you need to edit or rewrite the formula.

**A better way** would be to write formulas so that you can change the data without having to change the formulas themselves.

To do this, you need to tell Excel which cell the data is located in. A cell's location in the spreadsheet is referred to as its cell reference.

To find a cell reference, simply look at the column headings to find which column the cell is in, and across to find which row it is in.

The cell reference is a combination of the column letter and row number -- such as **A1**, **B3**, or **Z345**. When writing cell references the column letter always comes first.

So, instead of writing this formula in cell C1:

= 3 + 2

write this instead:

= A1+A2

**Note:** When you click on a cell containing a formula in Microsoft Excel (see the example above), the formula always appears in the formula bar located above the column letters (circled in red in the example).

Previous

- Excel Formulas Overview
- Writing the Formula
- Cell References in Formulas
- Updating Excel Formulas
- Mathematical Operators in Formulas
- Excel Formula Example Step 1
- Excel Formula Example Step 2
- Excel Formula Example Step 3

Related Articles

- Mixed Cell Reference - Spreadsheets Terms - Excel Mixed Cell Reference Defi...
- Using Cell References in Excel Formulas
- Excel Spreadsheets Glossary of Terms - Cell Reference Definition
- Excel Tips - Microsoft Excel Tips - Excel Tips and Tricks
- Using Labels in Functions and Formulas in Excel 2003 - Labels in Excel 2003...

Explore Spreadsheets

Must Reads

- Basic Formulas and Functions Tutorial
- Beginners Guide to Excel
- Excel Step by Step Format Tutorial
- Excel Formulas: Free Email Course
- Excel Data Management: Free Email Course

Most Popular

See More About:

By Category

- Excel 101- How to Use Excel
- Formulas in Excel
- Excel Functions
- Excel VLOOKUP Tutorials
- Data Management in Excel
- Excel Shortcut Keys
- Formatting Options in Excel
- Excel How To Videos
- Charts and Graphs
- Excel Tips, Tools and Templates
- Advanced Excel
- Excel 2003 Tutorials
- Google Spreadsheets
- Other Excel Alternative Spreadsheet Tutorials
- Excel Glossary of Terms

- About.com
- Computing
- Spreadsheets
- Formulas in Excel
- Using Cell References in Excel Formulas