Tip Printed from ExcelTip.com

---

Use Sorting to Delete Blank Rows in Excel 2007


To delete blank rows between data:

1. Select a cell in a List.
2. Select Home -> Sort & Filter (in Editing Group) -> Sort Smallest to Largest.

Before:



After: