DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Delete Blank (empty), Hidden Rows, Columns, Sheets

These delete actions are simple, but they become tedious and error-prone when you have large amount of data. For example:

Delete blank (empty) rows

  1. Select a range, invoke 'DigDB->Delete->Rows->Empty', DigDB will treat your selected area as a table to find and delete empty rows in it.

    Or, click a single cell, then invoke the command. This way DigDB assumes the current sheet's entire data area as a single table to find and delete empty rows in it. (A sheet's entire data area means the area formed by the top and bottom non-empty rows and the left-most and right-most non-empty columns in the current sheet).

    Delete blank, empty), hidden
    Practice file - delete-blank-empty-demo.xls (16k)

  2. All empty rows will be selected to reconfirm before deleting. Click OK to delete.

    Delete blank, empty), hidden

    After empty rows are deleted

    Delete blank, empty), hidden

Delete blank (empty) columns

  1. Select a range, invoke 'DigDB->Delete->Columns->Empty', DigDB will treat your selected area as a table to find and delete empty columns in it.

    Or, click a single cell, then invoke the command. This way DigDB assumes the current sheet's entire data area as a single table to find and delete empty columns in it. (A sheet's entire data area means the area formed by the top and bottom non-empty rows and the left-most and right-most non-empty columns in the current sheet).

    Delete blank, empty), hidden
    Practice file - delete-blank-empty-demo.xls (16k)

  2. All empty columns will be selected to reconfirm before deleting. Click OK to delete. Note that column headers are ignored in determining if a column is empty.

    Delete blank, empty), hidden

Delete blank (empty) sheets

  1. Invoke 'DigDB->Delete->Sheets->Empty...'

    Delete blank, empty), hidden
    Practice file - delete-blank-empty-demo.xls (16k)

  2. Empty sheets appear in the to-delete pool. Non-empty sheets appear in the to-keep pool. Click OK to delete. or use the 'Add' and 'Remove' to select what to delete.

    Delete blank, empty), hidden

Delete hidden rows

  1. Click a cell in your table area, invoke 'DigDB->Delete->Rows->Hidden...'. (You can use this delete on AutoFilter, Advanced filter, DigDB filter, table match, Subtotal)

    Delete blank, empty), hidden
    Practice file - delete-hidden-rows-demo.xls (16k)

    After deletion:

    Delete blank, empty), hidden

Delete hidden columns

  1. Click a cell in your table area, invoke 'DigDB->Delete->Columns->Hidden...'

    Delete blank, empty), hidden
    Practice file - delete-hidden-columns-demo.xls (16k)

    After deletion:

    Delete blank, empty), hidden

Delete hidden sheets

  1. Invoke 'DigDB->Delete->Sheets->Hidden...'

    Delete blank, empty), hidden
    Practice file - delete-hidden-sheets-demo.xls (16k)

  2. Hidden sheets appear in the to-delete pool. Visible sheets appear in the to-keep pool. Click OK to delete. or use the 'Add' and 'Remove' to select what to delete.

    Delete blank, empty), hidden

    Click OK to delete hidden sheets.

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact (free forum)

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

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