How do I copy & paste and keep the source formatting?

  • Thread starter Thread starter dmk
  • Start date Start date
D

dmk

I am trying to copy a worksheet from one file to another. How do I keep the
formatting the same?
 
Use Pastespecial instead of paste this gives you the option to paste all. You
can pastespecial a second time for column widths for example.

Mike
 
R-click the tab of the sheet in question and pick Move or
Copy.................
 
You must log in or register to reply here.

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

Copy and Past Values AND Formatting AND Text 1
protect cell format 1
2007 copy & paste 2
How to Keep my Format ?? 7
Excel Highlighting duplicates 0
Using Worksheet as Data Source 1
Copying Conditional formatting 2
Copy worksheet1 to worksheet2, keep cell format eg cell size 2

Back
Top