Stopping calcs

[sassriverrat]

Making me angry because I know how to do it and forgot-

I have a string of numbers (basically finance) that are all in a row- and A2 is the year. Each year the auto calculate with formulas from various sheets and workbooks and I’d like to “freeze” a row so that it doesn’t calculate anymore when new numbers are put in elsewhere.... does that make sense. I’m this case I want all the numbers in row 2 to freeze and not update anymore but row 3 and etc to continue with formulas. I don’t want to go cell to cell in row two and delete formulas and input the current static values- that would suck.

 

[sandy666]

copy row 2 and paste as values in the same row ?