How to Delete Blank Lines in Excel 2007 Lists

1. Open the Microsoft Excel 2007 application on your computer. Click the 'Office' button.
2. Click the 'Open' option and select the file that contains the information you want to edit. Click the 'Open' button.
3. Highlight all of the cells within the column that contains the blank rows that you want to delete. If you have multiple columns that need to remain in a specific order then select all of the cells in the columns.
4. Click the 'Data' tab. Click the 'Sort' button. Select the column heading, e.g., 'Column A,' that contains the blank rows in the 'Sort by' drop-down list. All of the blank rows will move to the bottom of the column.
5. Highlight all of the rows you want to delete. Click the 'Home' tab. Click the arrow under the 'Delete' option. Click the 'Delete Sheet Rows' option.