Remove blanks in Excel

Quick solution to delete empty rows, columns, and sheets

Looking for a safe way to remove blank cells in Excel? A couple of clicks will delete blank rows or columns where all cells are empty, so not a single bit of your information will be lost. The add-in can also remove all blank sheets you no longer need.

Free download Ultimate Suite for:
2019 365 2016 2013 2010
Download this and 60+ other tools for Excel included in Ablebits Ultimate Suite

14-day fully functional version
Delete Blanks for Excel 2019, 2016 - 2010

With Delete Blanks you will

  • Remove blank rows in Excel Eliminate all empty lines in your table in a click.
  • Delete empty columns Get rid of multiple blank columns in your Excel spreadsheet with a single button click.
  • Delete blank spreadsheets Remove empty sheets from your Excel workbooks.
  • Safe way to remove blanks The tool only deletes completely blank rows, columns, and sheets. It won't remove a single cell with any information in it.

How to remove blanks in Excel

Choose to delete all empty rows from a sheet
Choose to delete all empty rows from a sheet
All blank lines are removed from your table at once
All blank lines are removed from your table at once
Remove all empty columns within your table
Remove all empty columns within your table
Extra columns are removed from the table
Extra columns are removed from the table
Get rid of all empty sheets in your Excel workbook
Get rid of all empty sheets in your Excel workbook
No blank Excel tab is left behind
No blank Excel tab is left behind

License benefits

Our customers get

Unconditional 60-days money-back guarantee
Life-time license, no additional
fees ever
Free life-time support
Secure payment guarantee
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Delete Blanks and what do I need it for?

Large worksheets often contain gaps that you need to close up. Whether you wish to remove blank rows, columns, or empty spreadsheets, the Delete Blanks tool can eliminate them all in a click.

Why not get rid of empty rows by selecting blank cells and then deleting them?

Removing empty rows via Go to Special > Blanks > Delete is the worst-case scenario because it deletes all rows that contain at least one blank cell. If you don't want to remove rows with any information in any of the columns, use our Delete Blanks utility. It only detects and removes lines, columns, and worksheets that are absolutely empty.

How to remove blank rows in Excel?

  1. Select a cell in the worksheet where you need to delete blank rows.
  2. Go to the Ablebits Tools tab and click Delete Blanks > Empty Rows.

See a more detailed description here.

How to remove blank columns in Excel?

  1. Select a cell in the worksheet where you need to delete extra columns.
  2. Head over to the Ablebits Tools tab and click Delete Blanks > Empty Columns.

See a more detailed description here.

How to remove blank spreadsheets in Excel?

  1. Open a workbook where you want to delete empty pages.
  2. On the Ablebits Tools tab, click Delete Blanks > Empty Sheets.

See a more detailed description here.

Supported versions

Microsoft Excel

  • Excel included in ​Microsoft 365 (formerly Office 365)
  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • 32-bit and 64-bit
  • Note! Office Insider is not supported

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
  • Note! Windows insider is not supported
  • Note! Surface Pro X and Windows X are not supported

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close