How to find and delete empty cells, rows in Excel

I thought I should share this with you - Microsoft Excel tips. I am working with some data points in Excel right now and encountered unnecessary empty cells or empty rows that I don't want to be included in the database. I could have just deleted it one by one, however, it will take me forever to finish 23,000 rows.

Googling led me to DigDB Excel add-in. It is an Excel macro add-in file that you can download and use for free.

Download the Excel macro add-in file:

DigDB.xla.zip for Excel 2000/XP/2003 (or DigDB.xla)
1 meg

DigDB.xlam.zip for Excel 2007 (or DigDB.xlam)
1 meg (supports 2007's million-row limit)

How to install?

1. Download the zip file
2. Open the zip, take the DigDB file out, place it on desktop.
3. If you never had DigDB before, just double-click DigDB to run it. If Excel has DigDB previously installed, start Excel first, click DigDB->Uninstall to uninstall the old version, close Excel. Double-click the new DigDB and run.
4. Add DigDB to Excel menu if you want to.

Add DigDB to Excel menu

You don't need to do this if you only use DigDB occasionally. You can simply place the downloaded macro on desktop and open it when needed. But if you use DigDB frequently, it's easy to make DigDB load up automatically when Excel starts.

For Excel2000/2003, go to Excel->Tools->Add-ins..., use "Browse..." to find and select your DigDB.xla file, make sure Digdb checkbox is checked, ok out.

For Excel2007, click the upper-left Office button, then "Excel options"->"Add-ins"->"Manage 'Add-ins' Go...", then use "Browse..." to find and select your DigDB.xla file, make sure Digdb checkbox is checked, ok out.

Thanks to digdb.com.