Paste special from cells without formulas/formats

S

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?
 
B

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
 
S

Spartacus

Dear Bernie,

"I am not an animal!" ;^D

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

Spartacus R
 

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

Similar Threads

Paste, Paste Special 2
Pasting formats and values without formulas 2
Finding dates without attention to data formats 1
How do I copy cells containing drop downs? 3
Paste Special values only 1
Special Paste 2
Paste Special 3
Edit Paste Special Formulas 7

Top