A safe way to remove blanks in Excel

When you import data to Excel, you can come across empty rows or columns, and your workbook may contain empty sheets. This small utility lets you get rid of those in a click.

How to delete blanks in Excel

Remove empty rows

If you need to delete blank rows, select a cell in the worksheet where you need to remove them, click the Delete Blanks icon in the Transform group on the Ablebits Tools tab, and choose the Empty Rows option from the drop-down list:
Get rid of all empty lines in a click.

First, you will get a notification message asking you to confirm the action:
Confirm the action to remove blank lines from the worksheet.

Click OK and see the number of removed rows:
A result message saying that 7 empty rows have been deleted.

Delete blank columns

To delete blank columns, select a cell in your table, click the Delete Blanks icon in the Transform group on the Ablebits Tools tab, and pick the Empty Columns option:
Quickly get rid of all empty columns in your worksheet.

A notification message will appear right away asking you to confirm the action:
Confirm if you want to remove empty columns from your worksheet.

Click OK and you'll see a confirmation with the number of deleted columns:
The tool found and got rid of 4 empty columns.

Get rid of blank worksheets

To remove empty sheets from your workbook, click the Delete Blanks icon in the Transform group on the Ablebits Tools tab and select Empty Sheets:
Click the corresponding option to delete empty tabs from your file.

See the number of blank sheets to be deleted and confirm the action by clicking OK:
2 empty worksheets will be removed from the file.


Charles Bolton says:
June 23, 2020 at 7:12 pm


I want to recode missing cells to "Missing" globally. How do I do that?


Hi Charles,

Thank you for contacting us. I'm sorry but your task is not clear. Please send us a small sample workbook with your source data and the result you expect to get to support@ablebits.com. We'll look into your task and see if our software can help.


Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard