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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells
 
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
 
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.
 
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
 
Back
Top