Select the col. from which you would like to delete the empty rows. Click on
"EDIT -- Go To -- Special -- Blanks -- OK". This step will highlight only
the blank cells in the selected col. You can now delete all the blank rows at
once.

sk

"McLeod" wrote:

I pasted a long list (report) from word pad into EXCEL. THis list has lots
of empty rows spread throughout this single column list. Can I globally
delete all empty rows?