If I understand, you want the ability to switch relative to absolute or vice versa. Excel does not have a built in method for doing this. But ASAPUtilities does click here
Select the range of cells that you want to change, click on the ASAPUtilities Menu, Formula, Change reference style.
This has saved me countless hours of effort.