To do so, select the area containing the blank columns to be removed. You can also delete blank columns using this feature.
On the “Go To Special” dialog box, select “Blanks” and click “OK.”Īll the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. In the “Cells” section of the “Home” tab, click “Delete” and then select “Delete Sheet Rows” from the drop-down menu.Īll the blank rows are removed, and the remaining rows are now contiguous. Be sure to include the row just above the first blank row and the row just below the last blank row.Ĭlick “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special…” on the drop-down menu. Highlight the area of your spreadsheet in which you want to delete the blank rows. Deleting blank columns is a similar process that we’ll show you later in this article.
