Dear friends,

Please help me with following, it is very important. I have a very huge table containing many formulas and calculations. I needed to spread formulas till 500th row.

Of course, many data are linked to other sheet, etc.

So when I enter something... Excel starts Calculating cells (lower left corner), and then... 10%.....................15%.............................................30%.... etc
It lasts too long.

I know that I can turn off automatic calculation, but it is not solution I want.
Can I solve it on some other way? For example, that Excel calculate only the row in which I am momentarily entering numers, dates, amounts....

Thanks