Paste special from cells without formulas/formats
 

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?

Paste special from cells without formulas/formats
 

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" wrote in message
...
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?

Paste special from cells without formulas/formats
 

Dear Bernie,

"I am not an animal!" ;^D

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

Spartacus R

"Bernie Deitrick" wrote:

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" wrote in message
...
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?