If you have a great deal of empty rows in your Excel spreadsheet, you can erase them by right-clicking each once separately as well as selecting “Delete,” a very lengthy task. Nonetheless, there’s a quicker and much easier means of erasing both blank rows as well as empty columns.

Initially, we’ll reveal you exactly how to erase empty rows. Deleting blank columns is a comparable process that we’ll reveal you later on in this post.

Highlight the area of your spread sheet in which you want to delete the empty rows. Make sure to consist of the row just above the very first empty row as well as the row just below the last blank row.

Click “Find & Select” in the “Editing” area of the “Home” tab and pick “Go To Special …” on the drop-down food selection.

On the “Go To Special” dialog box, select “Blanks” and click “OK.”

All the cells in the choice that are not empty are de-selected, leaving only the empty cells picked.

In the “Cells” section of the “Home” tab, click “Delete” and after that pick “Delete Sheet Rows” from the drop-down food selection.

All the empty rows are removed and also the staying rows are currently adjoining.

You can likewise delete blank columns utilizing this function. To do so, pick the area containing the blank columns to be deleted. Be sure to consist of the column to the left of the leftmost column to be erased and the column to the right of the rightmost column to be deleted in your selection.

Once more, click “Find & Select” in the “Editing” area of the “Home” tab as well as choose “Go To Special …” from the drop-down menu.

Select “Blanks” again on the “Go To Special” dialog box and also click “OK.”

Once again, all the cells in the option that are not empty are de-selected, leaving only the blank cells selected. This time around, considering that there are no empty rows picked, only blank columns are chosen.

Click “Delete” in the “Cells” section of the “Home” tab and after that select “Delete Sheet Columns” from the drop-down menu.

The blank columns are removed and also the remaining columns are contiguous, just as the rows are.

This technique for removing blank rows and columns is quicker, especially if you have a huge workbook having large and multiple worksheets.