Excel 2007 paste special formatting??

G

garwil

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
 
R

Roger Govier

Hi

Copy the original data, then on the destination sheet choose Paste
Special>Formats
 
G

garwil

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