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



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:



Account
Site
Copyright © 2022 AmitpalSingh.com, doing business as Woocoders. All Rights Reserved.
Got a Question? Check out our FAQ Section.