# Referencing Cells

In addition to typing values into your worksheets, you can enter references to cells. Using cell references is often more effective than typing actual values when you want to build formulas. If a value in a referenced cell changes, the formula that points to the reference is updated automatically. Best of all, one cell can be referenced in an unlimited number of formulas. A cell reference does not need to contain an operator unless you want to use it to perform a calculation.

For example, if you're calculating the amount of sales tax due on a car purchase, you can reference the cell that contains the current sales tax percentage in each formula. If the sales tax percentage changes or you enter it incorrectly, updating the percentage amount also updates the car purchase formula, as shown in Figure 5.6.

##### Figure 5.6. Referencing the sales tax percentage in a formula. Each time you reference a cell while you're building a formula, you need to type an operator. Otherwise, Excel won't store the cell reference, and your formula will be incomplete. Don't press the Enter key while you're still constructing a formula by pointing to cells. Pressing Enter is equivalent to clicking the green check mark and tells Excel that the formula is complete.

If you need to edit a formula, press F2 and make your changes. You can type the values and cell references, or you can point to them with the mouse. Click the Enter button when the formula is complete.

Excel uses color coding to assist you when you're editing a cell, as illustrated in Figure 5.7. Each cell reference and the cell it refers to in the worksheet are displayed in the same color. You can use the color coding to identify which references in the formula match which cells in the worksheet.

##### Figure 5.7. Press F2 to edit a formula.   Part I: Excel Basics  Hour 1. Getting Started  Hour 2. Entering Data  Hour 3. Organizing Your Files  Hour 4. Managing Your Files and Workbooks  Hour 5. Letting Excel Do the Math  Why Use Formulas?  How Formulas Work  Creating a Simple Formula  Referencing Cells  Using AutoSum  Using Range Names in Formulas  Using Relative and Absolute Addressing  Copying Formulas  Troubleshooting Formula Errors  Summary  Q&A  Hour 6. Using Excel Templates  Hour 7. Printing Your Workbook  Part II: Dress Up Your Work  Part III: Interactive Data Makes Your Worksheet Come Alive  Part IV: Advanced Excel Techniques  Part V: Creating and Using Databases in Excel  Part VI: At the Office and on the Internet/Intranet

ASPTreeView.com

Evaluation has expired.
Info...