deleting empty spaces

  • Thread starter Thread starter vrijbergen
  • Start date Start date
V

vrijbergen

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