Audra

Select the range then F5SpecialBlanks and OK.

With blanks selected, EditDelete. 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

On Sat, 19 Feb 2005 23:37:02 -0800, "arudra1974"
wrote:

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" wrote:

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

On Sat, 19 Feb 2005 04:25:02 -0800, "arudra1974"
wrote:

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