Preserve borders during copy and paste?

A

aarotu

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to preserve PivotTable borders and colours on refresh? 1
Excel copy/paste questions 10
Lock format but allow data entry 1
Excel 2000 PIvot Table Borders 1
Copy and Paste 1
Cut & Paste in Excel without erasing cell borders? 1
Excel 2003 - VBA - A simple copy and paste 1
Conditional Formatting 2

Top