deleting empty spaces

Hi,

I have the following problem: I have filtered my worksheet for dubble
values and now I have all these empty cells. For quick lookup I do not
want that so how can I delete all these empty cell and write my unique
values under each other?


Thanks Michiel


--
vrijbergen
------------------------------------------------------------------------
vrijbergen's Profile: http://www.excelforum.com/member.ph...fo&userid=27757
View this thread: http://www.excelforum.com/showthrea...threadid=472802

Hi Michiel,

Not sure what you mean. If you have column headers and blank cells in that
column (whichever desired) you can autofilter said column for null values
( "" ), then select those cells, press F5, select Visible Cells Only, then
delete them as desired.

Not sure if this is what you're asking for or not. Remember to save all
progress before attempting any deletion.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"vrijbergen" <vrijbergen.1wcjqa_1128377101.1496@excelforum-nospam.com> wrote
in message news:vrijbergen.1wcjqa_1128377101.1496@excelforum-nospam.com...
>
> Hi,
>
> I have the following problem: I have filtered my worksheet for dubble
> values and now I have all these empty cells. For quick lookup I do not
> want that so how can I delete all these empty cell and write my unique
> values under each other?
>
>
> Thanks Michiel
>
>
> --
> vrijbergen
> ------------------------------------------------------------------------
> vrijbergen's Profile:
> http://www.excelforum.com/member.ph...fo&userid=27757
> View this thread: http://www.excelforum.com/showthrea...threadid=472802
>