Forum Discussion
copy and paste a range of cells and keep formula eferences
My goal is to copy a range of cells and have all the formulas in the copied range of cells pasted into a new location keeping the original formula references. I.e, I will have two identical data in t...
Tim_Parisi , both assume changes cell by cell. To copy entire range the workaround could be
- select entire range
- Ctrl+H and replace = on #
- copy/paste the range on new location
- select range, Ctrl+H and replace # on = (for both ranges)
Incredibly helpful!, I was also able to replace cell references in bulk, but I first have to replace = with # before doing so, then reverse that after I'm done replacing the cell references. A bit of a workaround but it is way better than moving the reference selections.