I need to copy a column of formulas from one part of my spreadsheet to another.
I want to keep all those forumals intact.

I know I can anchor them using $ BUT is there another way short if having to
amend every single formula (I'm taking about 100 formulas so copying from the
formula bar is a bore too).

I thought copy and paste formula would work but the original cell location
shifts.

Maybe the answer is right under my nose and I've been working on this sheet
too long.... thanks!