Excel 2007 paste special formatting??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2007 and want to break up a large worksheet into many small
sheets but retain the original data in one sheet. When pasting the coipied
data as a link the copied data is inserted into the new worksheet but sans
the original formating such as currency, number formats, text color etc.
What to do? >))
many thanks
 
Hi

Copy the original data, then on the destination sheet choose Paste
Special>Formats
 
Many thanks Roger. I am surprised that in a new version Microsoft do not
allow this to happen in one movement as aposed to two.
 

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

Excell 2007 Paste Special Formatting 1
Copy Paste VBA formatting issues 3
Excel 2007 Paste Special 3
Excel Copy and Paste Special problem 1
Excel 2007 - Paste picture link does not print 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Blank Charts and Paste Special 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top