How to delete blank rows in excel?

Picture of Amitpal Singh
Amitpal Singh
July 4, 2023

1. Click Find & Select
2. Click to Go to Special
3. Choose  Blanks
4. Click OK and then all the blank rows/cells  will be highlighted
5. Choose the Delete under Cells section on the Home Tab
6. Click Delete Sheet Rows

Share this post:

How to Attribute?

Lorem ipsum is typically a corrupted version of De finibus bonorum et malorum, a 1st-century BC text by the Roman statesman and philosopher Cicero.
for Example: Website, Social Media, Blogs, ebooks , newsletter, etc.
Lorem ipsum is typically a corrupted version of De finibus bonorum et malorum, a 1st-century BC text by the Roman statesman and philosopher Cicero.
Copied!

Got a Question? Check out our FAQ Section.

Your action, our appreciation

It encourage us to give you more valuable content on website.