View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aarotu aarotu is offline
external usenet poster
 
Posts: 1
Default 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