Deleteing empty rows

Is there an easy (quick) way of deleting empty rows in a large spreadsheet?

This can be accomplished easily with one of the standard features of the
add-in called ASAP Utilities, available free from www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3


"Ken G." <KenG@discussions.microsoft.com> wrote in message
news:9D582ED8-B374-40F1-B1B2-5917CBBADACD@microsoft.com...
> Is there an easy (quick) way of deleting empty rows in a large
spreadsheet?

one of the easiest is not really deleteing.
If there is a column which will have data for any non empty row.
select everything and sort by that column.
Note there may be "" values beow the last row. If you do want these deleted
select the rows beloow the last set of data you want to keep ad edit delete
rows.

"Ken G." wrote:

> Is there an easy (quick) way of deleting empty rows in a large spreadsheet?

Yep, hightlight the rows you want to delete, right click, press delete, then
choose one of the four options.


"Ken G." wrote:

> Is there an easy (quick) way of deleting empty rows in a large spreadsheet?