How to delete empty rows in Excel

spiros · 1 · 2763

spiros

  • Administrator
  • Hero Member
  • *****
    • Posts: 810371
    • Gender:Male
  • point d’amour
How to delete empty rows in Excel

To delete empty rows between data:

1. Select all columns containing data.
2. Click the Sort icon (either Ascending or Descending).


 

Search Tools