If I have Excel sheets with long filtered lists, and I recalculate while a filter is applied, when I remove or change filters, can I always guarantee that Excel will have already calculated all hidden rows properly?

My spreadsheet takes a couple of minutes to calculate, and I usually F9 just to make sure, but is this completely unnecessary?


Yes Excel always calculates hidden rows unless your formula or VBA code is ignoring hidden rows on purpose. You can take a look at this Technet blog for more information. Here is a relevant quote tho.

Normally, hiding rows won't interfere with any formulas so your results will remain the same even if values are called from hidden cells.

| improve this answer | |
  • I'll be honest, I'm still worried, but thanks haha – Some_Guy Aug 14 '15 at 12:49
  • As with everything take it with a grain of salt lol. – Unfundednut Aug 14 '15 at 12:49
  • hmmmm I just can't decide whether I actually feel confident doing it still :/ could save me a lot of time but still – Some_Guy Aug 14 '15 at 12:54
  • @Some_Guy if you're worried, then just try it out in a new spreadsheet. – Sandy Chapman Aug 14 '15 at 16:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.