View original (French)

Loss of rows due to a filter

Solved
kim57 Posted messages 404 Status Member -  
kim57 Posted messages 404 Status Member -
Hello everyone,

I'm filtering names in my Excel table, the sorting is done. I switch back to "select all" and then I lose 4 rows from my table (whether they are at the end or in the middle of the table). Has anyone here faced this issue before?

Thanks in advance.

7 answers

  1.
    Lentzouille Posted messages 728 Status Member 64
     
    Hello,

    Instead of selecting all, go to Sort and Filter in your ribbon and then clear,

    If the problem persists, consider sending your file via www.cjoint.com

    Best regards,
    1
  2. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    Do you have merged cells in the filter area
    a solution is to remove the filter and reapply it, which resets all filters to zero
    If you have merged cells, all the rows or columns will be hidden when applying a filter that corresponds to that merged cell
    Also check if you have any hidden rows or rows with a height of 0
    select the row before and the row after your missing rows, right-click and set row height = 12.75 for example

    Practice makes perfect. - It's at the foot of the wall that you see the mason - you always learn from your mistakes
    1
    1. kim57 Posted messages 404 Status Member 36
       
      I tried your solution of removing the filter and it worked. Thank you very much.
      0
  3. kim57 Posted messages 404 Status Member 36
     
    I can't send the file because it's professional material. You will understand, of course, that I can't disclose information. However, I tried your Lentzouille technique and the result is the same. At first, I have my lines from 6 to 23 without interruption, I apply a filter on a name, and when I return to "normal" mode by removing the filters, I lose lines 19 to 23 (or line 18 when applying a filter on a specific name).
    0
  4. Lentzouille Posted messages 728 Status Member 64
     
    The data in your table doesn't matter to me.

    Delete them and put whatever you want in their place, I'm just trying to correct your problem,

    And without having the file in front of me, I don't see too many solutions like this,

    Best regards,
    0
  6. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Are you sure you don't have 5 empty lines between lines 6 and 23?

    --
    Retirement is nice! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    0
    1. kim57 Posted messages 404 Status Member 36
       
      No, I have all my lines. I applied protections to my document; I don't know if this could affect my problem or not.
      0
  7. Lentzouille Posted messages 728 Status Member 64
     
    Remove your protections and redo the manipulation,

    If this is corrected, you'll know where it's coming from ;)
    0
    1. kim57 Posted messages 404 Status Member 36
       
      I tried your suggestion but without success. Thanks anyway.
      0