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.

Learn more
This tool is part of
Ultimate Suite
Delete Blanks for Excel 2016 - 2007

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

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Delete Blanks

  • 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

 

Excel

  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

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.
Excel add-ins and Outlook tools - Ablebits.com