Paste special from cells without formulas/formats

[Spartacus]

I want to copy a column in which certain cells have formulas and/or
formatting applied, and paste it to an adjacent column which has just been
added to the sheet. However, when I choose 'Paste Special' > 'Formulas and
number formats', I find that values from cells which contain only data are
pasted into the adjacent cell, i.e. it is not just 'Formulas and number
formats' which get pasted. Is there a way around this, other than copying and
pasting one-by-one the cells which have formulas and/or formatting applied?

 

[Bernie Deitrick]

Spartacus,

Any plans on leading an Excel-slave revolt? ;-)

After you complete the steps that you descibe, use Edit / Go To.... Special Constants, OK and then
press Delete.

HTH,
Bernie
MS Excel MVP

 

[Spartacus]

Dear Bernie,

"I am not an animal!" ;^D

Fanatastic answer - exactly what I was after; many thanks.

Spartacus R