Change Absolute References to Relative References in Excel
Reformat Excel References in a Flash
The word just came down from the higher-ups - someone's got to reformat all of the department's Excel spreadsheets so that the cells that are formulated as absolute are reformatted as relative. The lucky volunteer gets lauded as the office hero and a nice bonus. Your hand shot up before your brain could stop you.
You open up the first of many Excel files to discover an unending sea of rows and columns - and realize that this is going to take you far longer than you thought, and probably isn't worth it for the Applebee's gift certificate that was promised to you.
But soft, what light through yonder window breaks? Why, it's Excel Change References coming to save the day! It also means you get to go home at a decent hour.
Excel Change References lets you convert Excel absolute references to relative references -- or vice versa -- quickly and easily. You can change as few or as many cells as you like - select a block of cells, an entire spreadsheet, or the whole workbook, then specify whether you want the final outcome to be absolute or relative. Click a single button, and you're done.
Excel Change Reference is a godsend when you're dealing with very large spreadsheets, or have to change multiple spreadsheets at once. Why perform Excel format conversions manually when Excel Change Reference can do it for you, and so much more quickly?
Promotion Written by Roger Thomasson