Excel 2007 paste special formatting??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

garwil - 11 Sep 2007 04:56 GMT

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

Reply to this Message

Roger Govier - 11 Sep 2007 07:51 GMT

Hi

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

Signature

Regards
Roger Govier

>I am using Excel 2007 and want to break up a large worksheet into many
>small
[quoted text clipped - 3 lines]
> What to do? >))
> many thanks

Reply to this Message

garwil - 11 Sep 2007 08:26 GMT

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.

> Hi
>
[quoted text clipped - 8 lines]
> > What to do? >))
> > many thanks

Reply to this Message