How to delete blank rows in excel?

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:

I would like to introduce myself as freelancer professional with unique 10+ years of rich experience in building a brand with “Result Oriented procedure” Keeping Quality on priority and On Time Delivery.

Account

Site

Support

How to delete blank rows in excel?

How to Attribute?

Your action, our appreciation