4

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?

1 Answer 1

6

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

3
  • Adding an empty row just adds another element (Empty) to the filter list. The sum is still there. Apr 11, 2016 at 15:01
  • 1
    Remove the filter and reapply the filter. Apr 11, 2016 at 15:01
  • Perfect. It works now. Apr 11, 2016 at 15:02

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .