Empty Blank rows can be maddening in an excel spreadsheet. They hamper navigating and auto summing.
To eliminate or delete empty rows follow these steps.
Step 1: Select the range, Click Edit > Go To > Special > Select Blanks, click OK
Step 2: Click Edit > Delete > Entire Row > OK
Illustrated:
- Highlight the range
- Select Edit > Go To
- Select Special
- Select Blanks, click OK
- Select Edit > Delete
- Select Entire Row, then click OK
All the blank empty rows will be deleted from the range
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare