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.

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.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.