Cell Reference Wizard
This tool converts the style of cell references used within the function(s) of the current selection.
You can specify one of the following styles to use:
Style:
- Absolute references, i.e. $A$1
- Relative references, i.e. A1
- Columns as total references, i.e. $A1
- Rows as total references, i.e. A$1
I.e., the following functions could be changed from:
=MID($A$1;FIND(" ";$A$1;1)+1;FIND(" ";MID($A$1;FIND(" ";$A$1;1)+1;LEN($A$1));1)-1)
=SUM($E$2;$K$2;$Q$2;$W$2;$AC$2;$AI$2;$AO$2;$AU$2;$BA$2;$BG$2;$BM$2;$BS$2)
to:
=MID(A$1;FIND(" ";A$1;1)+1;FIND(" ";MID(A$1;FIND(" ";A$1;1)+1;LEN(A$1));1)-1)
=MID($A1;FIND(" ";$A1;1)+1;FIND(" ";MID($A1;FIND(" ";$A1;1)+1;LEN($A1));1)-1)
or
=SUM(E2;K2;Q2;W2;AC2;AI2;AO2;AU2;BA2;BG2;BM2;BS2)
In case you just have created a function, using one of the XLplus Wizards, you could run this tool to change the cell references, the function uses, from "Absolute references" to "Columns as total references" - this would allow to copy the function created downwards and automatically have the row references adjusted.
If run on a selection of cells, it will change every functions references to the style chosen. Empty cells or cells containing labels will be ignored.