How to Use Absolute References to Keep Formula Copies Working

ByRick

When you copy a formula to another cell in Excel, it does not copy the actual cell references. Instead, it keeps the spatial relationship of the cells in the formula. Say that a cell sums the two cells to its left (e.g., Cell C2 contains the formula =A2+B2).  Copies of that formula will always sum…

|

FORMULATEXT to Display the Formula in a Cell

ByRick

Here is a function that displays the formula in another cell: FORMULATEXT(reference). The argument, “reference”, is the cell address that contains the formula you want to display. This is most useful for documentation purposes.  For example, when you want to print out a spreadsheet with its formulas. If you have spent much time on this…