View original (French)

Remove unselected rows in Excel

lynx87 Posted messages 4 Status Member -  
MonCoach365 Posted messages 136 Status Member -
Hello, in a filtered table, the unselected rows are hidden. I would just like to delete them. How can I do that?
Thank you for your help.

3 answers

  1.
    MonCoach365 Posted messages 136 Status Member 16
     
    Hello

    What you need to do is reverse your filter selections. This way, you will be able to remove unnecessary rows.

    Have a nice day
    0
  2. lynx87 Posted messages 4 Status Member
     
    Hello, thank you for your response.
    How can I delete these cells other than selecting them manually?
    Because I have a problem, I can't delete them by selecting them manually at the same time because I get a message saying:
    ...Sorry, we cannot move cells in a filtered range or table.
    0
  3. MonCoach365 Posted messages 136 Status Member 16
     
    What you need to do is click and hold the click while keeping your finger pressed on the Shift key when you click on the number of the first line to delete. Then, click on the last line number to delete and release the Shift key.
    Finally, you will need to right-click on the selection to choose to delete the cells.
    0