Welcome Guest.

2Answers

How to delete multiple related data filtered by Excel

Asked by: Stephen 217 views Software April 6, 2019

How to delete multiple related data filtered by Excel

2 Answers

  1. +6Votes  

    Method 1: Use the sort function. Sort the rows you wish to delete, to the end. Then select the bottom row, right click on the line number, and delete it together. Method 2: Use targeting criteria. Click on “Find and Select” (the telescope icon) in the “Start” tab and click on “Targeting Conditions” and click on “Visible Cells” to delete the current filtered data without affecting other cells.

    Anthony Cooper- April 6, 2019 |

  2. +2Votes  

    Use the sort function.

     

    Sort the rows you want to delete, to the end.

    Then select the bottom few lines,

    right click on the line number and delete it together.

    Christine Johnson- April 6, 2019 |