How to Delete Blank Rows in Excel

Do you have an Excel spreadsheet with many blank rows in it? You can easily get rid of the blank rows in Excel.

Instructions

1. Make a backup copy of your spreadsheet. This is most important during the learning process.

2. Select the entire area that contains the blank rows that you want removed. For example, if you have data in rows 1 through 30, you can click on "Row 1" then press "Shift" and click on "Row 30." To select the entire spreadsheet, press the "Ctrl" and "A" keys simultaneously.

3. From the "Edit" field, select "Go To." Alternatively, you can press the "Ctrl" and "G" keys simultaneously.

4. Click "Special..."

5. Select the "Blanks" radio button and click "OK."

6. From the "Edit" menu, select "Delete..."

7. Select "Entire Row " and click "OK."

Tips & Warnings

• These steps will actually highlight all the blank cells in your selection. When you choose to delete the entire row, it will delete the row that contains blank cells.

• ctrl+z will undo your last action.

• If there are any blank cells in the rows you want to keep, they will be deleted using this process.