HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: Eliminate Blank Rows in a Spreadsheet

Excel 2007: Eliminate Blank Rows in a Spreadsheet

Blank rows can be beneficial when it comes to making your spreadsheet easier to read, however if you are going to pull the data into another application (such as Access), the blank rows can cause you some problems. You could go through the painful task of selecting and removing these rows individually, but if you are working with a large spreadsheet, it could take forever to accomplish this. Instead, utilize Go To Special and let Excel do the work for you. Here’s how:


1. Select the range of data that contains the blank rows.

2. Go to the Ribbon, and select the Home tab.

3. In the Editing section, click the small arrow next to Find & Select.

4. Select Go To Special.

5. Select the Blanks radio button and click OK.

6. All blank rows within the selected data range will be highlighted.

7. Go to the Ribbon.

8. Click the small arrow beneath Delete.

9. Select Delete Sheet Rows

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

LATEST REVIEWS

Recent Comments

error: Content is protected !!