Creating an Absolute Reference in a Formula
Sometimes when you copy a formula, you don’t want one of the cell references to change. That’s when you need to create an absolute reference. You use the dollar sign ($) to indicate an absolute reference.
Type the equal (=) sign in the cell where you want to place the formula answer.
Type the reference to the first cell of the formula. If this reference is to be an absolute reference, add dollar signs ...
Get Easy Office 2013 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
