thank you for the tip, maybe I misunderstood something, but on this way i can
only select the empty cells. I would like to select and delete only those
columns which are totally empty, and don't select those which contains few
empty cells. if it is possible.
--
sisco98


"daiblackburn" wrote:

> 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" <sisco98@discussions.microsoft.com> wrote in message
> news:5651F7DC-21E1-4B74-ADB0-BC5ACEA51ACB@microsoft.com...
> > 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
>
>
>