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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I copy & paste and keep the source formatting? (https://www.excelbanter.com/excel-discussion-misc-queries/197776-how-do-i-copy-paste-keep-source-formatting.html)

DMK

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

I am trying to copy a worksheet from one file to another. How do I keep the
formatting the same?

Mike H

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

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

"dmk" wrote:

I am trying to copy a worksheet from one file to another. How do I keep the
formatting the same?

Bob I

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

R-click the tab of the sheet in question and pick Move or
Copy.................

dmk wrote:

I am trying to copy a worksheet from one file to another. How do I keep the
formatting the same?

All times are GMT +1. The time now is 05:33 AM.