Hidden cells expanding when completing calculation
 

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?

Hidden cells expanding when completing calculation
 

Check your previous post.

KT wrote:

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