Hi. Folks,
I have many cells containing formulas and wish to copy these into other cells.
They all contain many cell references but don't have absolute references (I think thats what they're called, please correct me if this is wrong!) - e.g. A1, A2, A3, NOT $A$1, $A$2, $A$3 etc. I know that I can add the $ symbol to all the cells, but I am trying to save a lot of tedious work.
Is there a way of identically copying these formulas into other cells without the cell references altering. I cannot simply have another cell referencing these as the old cells will need altering eventually.
I have tried Paste Special with no luck. I am hoping there is a Shift/Enter or Alt/Enter or some similar option available.
Your help is and always has been very much appreciated.
Looking forward to your answer in anticipaion.
Big Rick.
Bookmarks