Shift cells down and keep the formulas the same

I'm currently working a sheet which relies on different sets of exported pdf to excel graphs which are all similar however sometimes out by 10 or so rows. I have the formulas set out so when it all works its perfect however sometimes its not and I need to select 5-6 columns in a row and shift the data down. When I do this the formulas change to follow where it would have been originally despite setting the formulas as absolute

In the attached file for example I want to shift cells down of columns of A to J from the row 610 to be even with the #1 on row 632 however the formula needs to stay the same. Help please

No good with that. Although have just had a thought, if I shift the rows around I could then just reset the problem column U by dragging the formula from top to bottom..