Even after selecting "skip blanks" in the paste special menu in e.

[arudra1974]

Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells

 

[Gord Dibben]

I think you misunderstand the purpose of "skip blanks".

Skip Blanks option will still copy the blanks, the blanks just won't overwrite
existing data if copied onto a range containing data.

See help on "skip blanks".


Gord Dibben Excel MVP

 

[arudra1974]

Thanks for clarifying.

But I have a huge dump of data in excel from an ERP which contains blank
cells in between. I cannot work on it until I remove the blanks. Is there any
way to remove the blanks apart from individually selecting the blanks and
deleting them?

Help is much appreciated.

 

[Gord Dibben]

Audra

Select the range then F5>Special>Blanks and OK.

With blanks selected, Edit>Delete. You will get 4 options. Choose which one
you want.

Shift Up or Entire Row would seem to be the choices but I can't see the data
so don't know.


Gord Dibben Excel MVP

 

[arudra1974]

Thanks Gord...It really did my work...Thanks a lot!!

 

[Gord Dibben]

Thanks for the feedback.

Gord

Thanks Gord...It really did my work...Thanks a lot!!