empty columns

[Guest]

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

 

[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

 

[Guest]

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.

 

[greg7468]

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.

 

[Guest]

wow, thank you, it seems quite good solution.