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...
If you dislike modifying your references from relative to absolute, select the original cell, select the entire formula therein on the formula bar, press Ctrl+C, press Esc, select the destination cell, press Ctrl+V, and press Esc.
