Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Past Values AND Formatting AND Text
I want to copy and paste a section of my spreadsheet, however, I can't seem
to find a way to copy the formatting, the text, and the values. If I try to use the paste values (special) function, I lose all of my text and all of my formatting. Any method I've tried that retains my formatting results in a loss of my values. I am going from one worksheet to another within the same workbook and have many merged and adjusted cell sizes which seem to be a lot of the problem. Any suggestions? -- KKD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Past Values AND Formatting AND Text
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "KKD" wrote in message ... I want to copy and paste a section of my spreadsheet, however, I can't seem to find a way to copy the formatting, the text, and the values. If I try to use the paste values (special) function, I lose all of my text and all of my formatting. Any method I've tried that retains my formatting results in a loss of my values. I am going from one worksheet to another within the same workbook and have many merged and adjusted cell sizes which seem to be a lot of the problem. Any suggestions? -- KKD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Past Values | Excel Discussion (Misc queries) | |||
Copy (Formulas and Formatting ONLY) no values to other rows | Excel Discussion (Misc queries) | |||
Copy and paste values, formatting and formulas | Excel Discussion (Misc queries) | |||
Copy and Past | Excel Discussion (Misc queries) | |||
Past Link then copy | Excel Discussion (Misc queries) |