How to remove the blanks from an Excel Worksheet?

Created by Abhishek Devrani, Modified on Sat, 14 Dec, 2019 at 2:06 PM by Baijnath Kumar

In this video, we will see how to remove the blanks from an Excel worksheet. Suppose if you have a worksheet containing multiple rows or columns and there are so many blanks in-between, then it's a challenging task to remove it. Microsoft Excel provides a feature to remove it easily and quickly.


Follow these steps to do so.

  1. Open the desired Excel Worksheet.
  2. Select all the data and press CTRL+G, and go to Special, a pop-up window will appear.
  3. Select Blanks and click on OK. Here, we will see all the blanks rows are selected.
  4. Now press CTRL and '-'. A deletion pop-up will open asking what you want to do?
  5. Press OK. After clicking on OK, you will see all the blanks are removed from the entire sheet.


        

For any other concerns related to Office 365 plan and subscriptions. You can reach out to us by submitting a ticket on our portal https://cloud.foetron.com/ or you can directly mail us at [email protected]. Check out our website www.foetron.com to know about the services offered by us.  


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article