Blog

How to Quickly and Easily Delete Blank Rows and Columns in Excel 2013

If you have a lot of blank rows in your Excel spreadsheet, you can delete them by right-clicking each once separately and selecting “Delete,” a very time-consuming task. However, there’s a quicker and easier way of deleting both blank rows and blank columns.

First, we’ll show you how to delete blank rows.
Highlight the area of your spreadsheet in which you want to delete the blank rows. Be sure to include the row just above the first blank row and the row just below the last blank row.

dc1

 

 

 

 

 

 

 

 

 

 

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

special

 

 

 

 

 

 

 

 

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

dc3

 

 

 

 

All the cells in the selection that are not blank are de-selected, leaving only the blank cells selected.

dc4

 

 

 

 

 

 

 

 

 

 

 

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

dc5

 

 

 

 

 

 

 

 

All the blank rows are removed and the remaining rows are now adjacent

adjacent

Posted in: Uncategorized

Leave a Comment (0) ↓

Leave a Comment