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.
