| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy/paste want to retain cell coloration but lose the conditional formatting source data | Excel Discussion (Misc queries) | |||
| Copy text hyperlinks and paste them as source addresses? | Excel Discussion (Misc queries) | |||
| How do I copy & paste formulas without them linking to the source | Excel Discussion (Misc queries) | |||
| Keeping Source Formatting with Paste Link and VLOOKUP | Excel Discussion (Misc queries) | |||
| Copy Paste Conditional Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
