empty columns

S

sisco98

HI all,

is there a way to delete the empty rows on a worksheet? I'm thinking about
something like when I select the empty rows with autofilter, just now I would
like to delete columns not rows.

thanks in advance
 
D

daiblackburn

Try highlighting the column selection and pressing f5 or edit go to.
select the special button and then selct blanks.
this should highlight all of the blank columns whcih you can then delete.

hth

David
 
Top