Tip: That’s why a more complex spreadsheet will need more advanced methods of selecting and removing blank rows.
![delete empty rows in excel 2010 delete empty rows in excel 2010](https://www.top-password.com/images/delete-sheet-rows.png)
But you should only shift cells if all the data line up as they are meant to be. If there is some data in the adjoining cells, you can opt for Shift cells up to make the non-empty rows move up into the vacant space. In our example, select the Entire row as the whole row is blank.
Delete empty rows in excel 2010 how to#
Excel will display four options in a tiny dialog to decide how to handle the empty spaces after deleting the blank rows. Right click anywhere on these rows and select Delete from the context menu.
![delete empty rows in excel 2010 delete empty rows in excel 2010](https://www.addictivetips.com/app/uploads/2010/01/DeleteSheetRows_thumb.jpg)
Blank rows will be sorted at the bottom of the selected range (indicated by colored rows in the screenshot below). Here you can select either the Sort A to Z or Sort Z to A button to sort in ascending or descending order.
![delete empty rows in excel 2010 delete empty rows in excel 2010](https://d1rytvr7gmk1sx.cloudfront.net/wp-content/uploads/2019/06/excelblankrows-fig3-12004.jpg)
Select the range of rows in the spreadsheet. A simple sort will bunch all blank rows together and help you quickly remove them. Sorting your data will not only help to organize your data but this can also bring out blank rows you do not need. Use a simple sort to find and remove blank rows in Excel
Delete empty rows in excel 2010 update#
The row numbers will also update to stay in sequence. Those rows below the deleted ones will be moved up to replace the deleted space. Right-click anywhere on this row and select Delete.You can select multiple rows by pressing Ctrl and clicking on the row number. Highlight the entire row by selecting the row number on the left side of the screen.When there are a small number of rows, you can quickly spot the blank rows and remove them with a selection. How to remove blank rows in Excel manually