If you have a lot of bare rows in your Excel spreadsheet, you lot can delete them by right-clicking each in one case separately and selecting "Delete," a very time-consuming chore. However, there'south a quicker and easier fashion of deleting both blank rows and bare columns.

Commencement, we'll show you how to delete blank rows. Deleting bare columns is a similar procedure that we'll show you afterwards in this article.

Highlight the surface area of your spreadsheet in which yous desire to delete the blank rows. Exist sure to include the row just to a higher place the beginning blank row and the row just below the final blank row.

Click "Find & Select" in the "Editing" section of the "Home" tab and select "Go To Special…" on the driblet-down menu.

On the "Get To Special" dialog box, select "Blanks" and click "OK."

All the cells in the pick that are non bare are de-selected, leaving but the bare cells selected.

In the "Cells" section of the "Home" tab, click "Delete" and then select "Delete Sheet Rows" from the drop-downward menu.

All the blank rows are removed and the remaining rows are now contiguous.

Yous tin can as well delete blank columns using this feature. To practice so, select the area containing the blank columns to exist deleted. Exist sure to include the column to the left of the leftmost column to be deleted and the column to the correct of the rightmost column to be deleted in your choice.

Again, click "Notice & Select" in the "Editing" section of the "Dwelling" tab and select "Get To Special…" from the drop-downwards menu.

Select "Blanks" once again on the "Go To Special" dialog box and click "OK."

Again, all the cells in the selection that are non blank are de-selected, leaving simply the blank cells selected. This time, since in that location are no blank rows selected, just blank columns are selected.

Click "Delete" in the "Cells" section of the "Domicile" tab then select "Delete Sail Columns" from the drop-downward menu.

The blank columns are deleted and the remaining columns are face-to-face, merely as the rows are.

This method for deleting blank rows and columns is quicker, particularly if you lot have a large workbook containing large and multiple worksheets.

The above article may contain affiliate links, which assist back up How-To Geek.