how to delete empty rows in excel table

Easy Method: using filter

  1. Select your table (Click inside the table and press Ctrl + A)
  1. Go to Home > Sort & Filter > Filter

Then filter

  1. Click the small arrow on any column
  1. Uncheck “Select All”, then check “(Blanks)”

Then check blanks

  1. Only blank rows will show now
  1. Select those rows, right-click, and click Delete Row
  • Go back to the filter and click Clear Filter

Then

Now you have clear data

Leave a Reply

Your email address will not be published. Required fields are marked *