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

A

arudra1974

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

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
 
A

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top