Excel Absolute Relative Reference Change Software
Change formula references from absolute to relative or relative to absolute.
DOWNLOAD
2.5 MB
This software offers a solution to users who want to change formula references from absolute (with '$') to relative (without '$') and vice versa in MS Excel.
When a cell has an absolute reference, it means that it will always reference the cell location in the formula no matter what. When a cell has a relative reference, it means that it will change the cell location in the formula if the referenced cell is cut and pasted somewhere else, for example. To get this software to work, simple select a block of cells, entire sheets or entire files and the software will make the changes in batch. Excel 2000 or higher required.
DOWNLOAD
2.5 MB