Training Snap Shot: Absolute References and Dollar Signs
DOLLAR | ABSOLUTE REFERENCE
What Is Absolute Referencing?
A dollar sign in a formula fixes a cell reference, this is called creating an ‘absolute reference’
You can use an ‘absolute reference’ to keep a row and/or column constant
An absolute reference is designated in a formula by the addition of a dollar sign “$” before the column and row. If it is placed before the column or row (but not both), it's known as a mixed reference
SUMMARY OF ABSOLUTE REFERINCING Absolute referencing can be used in many different styles of spreadsheets, it is important to know how to use it effectively in financial and figure based sheets. $ Inside A Formula Means “
If the $ is before the letter of the cell reference it means it fixes the column if you drag the formula vertically (UP DOWN), =$A1 * 10
If the $ is after the letter of the cell reference it means it fixes the column if you drag the formula horizontally (LEFT RIGHT), =A$1 * 10
Absolute referencing is widely used for financial spreadsheets and using knowledge on percentages can help you work on a much larger scale spreadsheet used for inputting important figures and statistics for any business.
EXCEL HELP FILE
By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)—in the same row (2). When you copy a formula that contains a relative cell reference, that reference in the formula will change.
As an example, if you copy the formula =B4*C4 from cell D4 to D5, the formula in D5 adjusts to the right by one column and becomes =B5*C5. If you want to maintain the original cell reference in this example when you copy it, you make the cell reference absolute by preceding the columns (B and C) and row (2) with a dollar sign ($). Then, when you copy the formula =$B$4*$C$4 from D4 to D5, the formula stays exactly the same.