Preserve borders during copy and paste?

Is it possible to preserve your border and font formats in a document when
pasting data from another worksheet which does not have the same font size
and border style.

Currently when I copy and paste, the font and borders of the data from which
I am copying overrides the formatting of the sheet that I am pasting to.

I would like the format of the sheet I am pasting the data on to preserve
it's formatting regardless of the format of the copied data.


Thank you

Perhaps Copy and Paste Special>Values>OK>Esc

Or Paste Special>Formulas and Number Formats

Or Paste Special>Values and Number Formats.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 14:39:20 GMT, "aarotu" <u23988@uwe> wrote:

>Is it possible to preserve your border and font formats in a document when
>pasting data from another worksheet which does not have the same font size
>and border style.
>
>Currently when I copy and paste, the font and borders of the data from which
>I am copying overrides the formatting of the sheet that I am pasting to.
>
>I would like the format of the sheet I am pasting the data on to preserve
>it's formatting regardless of the format of the copied data.
>
>
>Thank you