From Sam Raheb: This routine allows the user to convert the cell references of the formulas within the selected range of cells to any form of absolute reference. This can be useful in situations where you have two or more sheets linked together via formula functions. Keep in mind that you can do a compounded conversion by running this routine multiple times on the same set of cells to achieve the desired results. Convert some or all of the cells to and from A1, $A1, A$1, $A$1, or add or delete the sheet name to and from the formulas. To view all the formulas on a sheet at once, press the Control and keys at the same time. Repeat the keystrokes to toggle back to the previous view.
read more +