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.
 
Back
Top