![]() Be sure to include the column to the left of the leftmost column to be deleted and the column to the right of the rightmost column to be removed in your selection.Īgain, click “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special…” from the drop-down menu. 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. Delete Blank Rows in Excel – How to Remove Blank Rows in Excel?ĭelete Blank Rows in Excel – How to Remove Blank Rows in Excel?įirst, we’ll show you how to delete blank rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |