How to Delete All Blank Rows in Microsoft Excel

How to Delete All Blank Rows in Microsoft Excel

When you copy a Microsoft Excel spreadsheet from one document to another, or when you load an Excel file that was not created in the same version of Excel as the version you’re using to run the file, the formatting of the spreadsheet can get messed up. The text in the table may be in the wrong font, colors may be changed, and empty rows may appear.

The latter can be a particular problem, especially if you have a large document. Finding all the empty rows and then manually deleting them is quite a time-consuming and tedious task. Fortunately, in Excel, it is possible to find all the empty rows, and then delete them all at once.

Watch our video tutorial where we show you how to delete all blank rows in Microsoft Excel, using Windows 10.

Video Transcript:

  1. How to Delete All Blank Rows in Microsoft Excel
  2. Open Excel spreadsheet where you want to delete all blank rows, then click on Find & Select
  3. Click on Go To Special…
  4. Click on Blanks
  5. Click on OK
  6. Click on Delete
  7. Click on Delete Sheet Rows


1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Share: Share to Facebook to Facebook Share to LinkedIn to LinkedIn Share to Twitter to Twitter

Send: Send to Viber to Viber Send to WhatsApp to WhatsApp Send to Telegram to Telegram Send to Facebook Messenger to Messenger Send to Email to Email

If you enjoyed this article, you might also like...

Leave a Reply

Your email address will not be published. Required fields are marked *