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 two sets of cells on a sheet.
E.g. one of the cells in the range to be copied might have a formula similar to, "='sheet 2'!K75". I wish for that formula to be pasted into the destination cells and be "='sheet 2'!K75".
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.