sassriverrat

Well-known Member
Joined
Oct 4, 2018
Messages
622
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.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,108,987
Messages
5,526,068
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top