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 paste this down? 3
Copy/Paste (Clipboard) Issues 1
Unwanted line across top of pages; how to delete? 0
How can the font and size of (all) citation numbers be altered? 1
Paste to excel from word - auto format problem 1
Auto Merge text from multiple sources 0
Need help modifying code 0
Visio shape text disappears upon copy paste 1

Top