K
KT
I'm trying to do a simple calculation in a worksheet that contains
hidden/subtotaled cells. When I enter = to begin the calculation all hidden
cells expand to show all data and I only need to see those cells which have
subtotal amounts (this is quite frustrating in a worksheet with 6,000 rows).
What do I need to do to my settings to ensure that the hidden rows remain
hidden when I'm attempting to complete a calculation?
hidden/subtotaled cells. When I enter = to begin the calculation all hidden
cells expand to show all data and I only need to see those cells which have
subtotal amounts (this is quite frustrating in a worksheet with 6,000 rows).
What do I need to do to my settings to ensure that the hidden rows remain
hidden when I'm attempting to complete a calculation?