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

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

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

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

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