Convert Cell References converts Cell References Add-In for Microsoft Excel Convert Cell References Add-In for Microsoft Excel--------------------------------------------------Convert one or all the formulas on a spreadsheet in a single operation to: L A1 Format L $A1 Format L A$1 Format L $A$1 Format L Add the active Sheet Name to the formulas L Remove the active Sheet Name from the formulasIntroduction:This utility 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. Note: 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.When installed, a new menu item is added to the Tools menu called oConvert Cell Referenceso.