empty columns

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

Hi,
there maybe an easier/better way but could you not transpose the columns into rows, delete the empty ones and then transpose back.

HTH.

Greg.

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

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
>
>
>

wow, thank you, it seems quite good solution.


--
sisco98


"greg7468" wrote:

>
> Hi,
> there maybe an easier/better way but could you not transpose the
> columns into rows, delete the empty ones and then transpose back.
>
> HTH.
>
> Greg.
>
>
> --
> greg7468
> ------------------------------------------------------------------------
> greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
> View this thread: http://www.excelforum.com/showthread...hreadid=377634
>
>