How to Delete Blank Rows in Excel

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.'