software

Have a spreadsheet that contains empty cells. Want to delete all empty cells
at one time (if possible). Have filtered column to show only empty cells.
If I delete the filtered cells, all cells are deleted.

Is there anyway to quickly delete empty rows in a worksheet? My w/s is
rather large. Thanks.

Dakota

Rather than filtering, sort the data based on that column so that all the
rows to delete are grouped together - and then delete

quot;Dakotaquot; wrote:

gt; Have a spreadsheet that contains empty cells. Want to delete all empty cells
gt; at one time (if possible). Have filtered column to show only empty cells.
gt; If I delete the filtered cells, all cells are deleted.
gt;
gt; Is there anyway to quickly delete empty rows in a worksheet? My w/s is
gt; rather large. Thanks.
gt;
gt; Dakota