| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy part of a worksheet into a worksheet in the same file/keepi.
Excel 2000 My workbook contains 10 sheets. I want to copy one particular
sheet into the middle of every other sheet. I cannot copy and paste because I lose the format, formulas, etc... I can link , but the user would have to open the link to view, unless there is a way to keep the link expanded. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy part of a worksheet into a worksheet in the same file/keepi.
Use Paste Special, Values, Paste Special, Formats, Paste Special, Paste
Column widths, Paste Special, Paste Values and Formats, or any of the other options! You can do multiple paste specials from the one Copy command into the same cell, or range. If you want to play around, you can actually Copy a cell, Paste it, then Paste Special, formats, then Psate Special, Values and so on. To make it easier, if you do this often, you can use a macro to do the work. "JTB" wrote: Excel 2000 My workbook contains 10 sheets. I want to copy one particular sheet into the middle of every other sheet. I cannot copy and paste because I lose the format, formulas, etc... I can link , but the user would have to open the link to view, unless there is a way to keep the link expanded. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet 1 exact copy of worksheet 2, but in different order | Excel Discussion (Misc queries) | |||
| Copy from worksheet to worksheet help | Excel Worksheet Functions | |||
| copy subtotal value only - also can be lookup from other worksheet | Excel Discussion (Misc queries) | |||
| copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
| How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
Hybrid Mode
