

Please note that other Pearson websites and online products and services have their own separate privacy policies. This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about Peachpit products and services that can be purchased through this site. As a result, the formula is correctĦ An absolute cell reference in the formula makes it possible to copy the Only the relative reference in the formula. When you copy the formula in cell C6 to the cells beneath, Excel rewrites As shown in Figure 5, the formula in cell C6 becomesĥ This formula uses an absolute reference to cell C3. Simply include a dollar sign ($)īefore each part of the reference that you want to Excel not to adjust when the

Special notation for that cell reference. So how do you tell Excel that you always want to refer to cell C3? You use Reads this: "Take the value in the cell one cell to the left of the currentĬell and multiply it by the value in the cell three cells above the currentĬell." Excel rewrites the formulas in each destination cell Remember, Excel doesn't read cell addressees in the formula. Excel doesn't know that weĪlways want to refer to cell C3, and helpfully changes the formula toĤ You can't expect Excel to read your mind and know that you want an Through C9? As shown in Figure 4, disaster. What happens when we copy the formula in cell C6 (=B6*C3) down to cells C7 InĮach case, the formulas in cells C6 though C9 need to refer to the profit valueģ Absolute cell references can come in handy when you need a bunch ofįormulas that are basically the same to reference the same cell. Why would you want to use an absolute reference? Well, perhaps you have aīunch of formulas that all refer to the same cell. No matter where the formula is copied, the cell Reference relative to the cell in which the formula is written. Learn More Buy Using Absolute Cell ReferencesĪn absolute cell reference tells Excel not to think of a cell Microsoft Office Excel 2003 for Windows: Visual QuickStart Guide
