Partial data consideration by the filter function

Solved
-  
Hello,

In an Excel sheet, the filters do not account for all the cells in my spreadsheet and I can't explain why.
I haven't found any clues on Google or in the resolved posts of this forum. Does anyone have an idea?

Thank you in advance!

Configuration: Windows 7 / Firefox 26.0 / Excel 2007

4 answers

  • Votes
  • Date
  • Descending date
  1. Contributor
    Hello,

    why a filter doesn't work if only the header row is selected
    one explanation could be that rows 3 to 1198 were selected when the filter was applied and you just don't remember that or you didn't pay attention (due to a copy-paste, for example). And you completed the others afterwards.

    eric

    In addition to the thank you (yes, it is done!!!), please remember to mark it as resolved when it is the case (at the top near your title).
    Thank you
    1. Hello eriiic,
      I have a doubt, the filter is on the range [A10:H10], it always goes to the first row of a selection..! However, there must be a value in each cell of the filtered row..!
      Friendly regards.
      The Penguin
    2. Hello eriiic,

      That must be it! Thank you!
    3. Contributor
      I have a doubt, the filter is on the range [A10:H10], it always applies to the first row of a selection..!
      Let's say rows 2 to 1198 then, the header row copied-pasted as well... ;-)
      eric
    4. Thank you eriiic,
      I'm still on cloud nine.
      The Penguin
    5. Excellent answer !! I didn't know that the filter acted on the current selection! And to think I had been facing this problem for years :)