Hidden cells expanding when completing calculation

[KT]

I have a worksheet which contains 6,000 rows with subtotal amounts. When I
hit = to begin the calculation all hidden cells expand, which I don't want to
occur as locate the subtotalled cells is difficult.

How do I stop the hidden cells from becoming visible when trying to perform
the calculation?

 

[Dave Peterson]

Check your previous post.

I have a worksheet which contains 6,000 rows with subtotal amounts. When I
hit = to begin the calculation all hidden cells expand, which I don't want to
occur as locate the subtotalled cells is difficult.

How do I stop the hidden cells from becoming visible when trying to perform
the calculation?