When adding a filter to an Excel spreadsheet, how do I limit its scope to some rows only?

For instance, in this document:

enter image description here

the “Hello” column filter will contain the values 0, 2, 4, 5, 7, 9 and 27. How can I make the sum, that is the value 27, disappear from the values suggested by the filter?


The only way I can think of is by adding a blank row between the numbers and the sum. This way you can limit your filter to just the numbers.

enter image description here

  • Adding an empty row just adds another element (Empty) to the filter list. The sum is still there. – Arseni Mourzenko Apr 11 '16 at 15:01
  • Remove the filter and reapply the filter. – Raystafarian Apr 11 '16 at 15:01
  • Perfect. It works now. – Arseni Mourzenko Apr 11 '16 at 15:02

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.