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
"sisco98" wrote in message
...
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
--
sisco98
|