Slider

How to Batch Delete Blank Cells in Excel

Date:2019-10-14 Author:Cordelia

What would you do if you find some unwanted blanks in Excel sheet? Deleting them one by one is obviously a waste of time. Is there any quick way to remove all the blank cells at once?

Well, the Go To feature of Excel may help you.

1. First of all, select the whole sheet.

How to Batch Delete Blank Cells in Excel

2. Press [Ctrl+G] to call out the Go To window, and then click Special… at the bottom-left corner.

How to Batch Delete Blank Cells in Excel

3. Or you can click HomeFind & SelectGo To Special.

How to Batch Delete Blank Cells in Excel

4. In the Go To Special window, check Blanks and hit OK to locate and select all the blank cells in your Excel file.

How to Batch Delete Blank Cells in Excel

5. Then click Delete in Home tab.

How to Batch Delete Blank Cells in Excel

6. All the blank cells in your Excel sheet will be removed immediately.

How to Batch Delete Blank Cells in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

1 thought on “How to Batch Delete Blank Cells in Excel”

  1. vurtil opmer says:

    I was wondering if you ever considered changing the layout of your site? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or two images. Maybe you could space it out better?

Leave a Reply

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