Select your data range and press Ctrl + F keyboard shortcut to open the "Find and Replace" dialog.Ĭlick Options to see advanced search criteria. Open the Excel spreadsheet where you wish to delete blank rows.Method 2: Delete Blank Rows in Excel Using Find & Replace Navigate to the Home tab, click Delete and choose Delete Sheet Rows. You should see that all the empty rows in Excel are now highlighted in blue. Under the Home tab, click Find & Select and then click Go To Special.Ĭhoose the Blanks radio box and click OK. Highlight the area of your Excel spreadsheet in which you want to delete the blank rows. Method 1: Delete Blank Rows in Excel with Go To Special Command This tutorial will show you 4 simple methods to quickly delete or remove blank rows from your Excel spreadsheet in Excel 2016 / 2013 / 2010 / 2007. Got a large Excel spreadsheet that is full of empty rows? How to quickly remove all the blank rows that are scattered everywhere in your Excel worksheet? Deleting each blank row manually can be very annoying and time-consuming.
0 Comments
Leave a Reply. |