|  

» Use Sorting to Delete Blank Rows in Excel 2007

CATEGORY - Excel Sorting VERSION - Microsoft 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:



Rate This Tip
12 34 5
Rating: 1.50     Views: 6340
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments