Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
clipboard pastes wrong item
Hello.
I have some cells in an EXCEL 2002 spreadsheet that I have neatly formatted with borders, subscripts, bold lettering, etc, so it looks like a neat table. I'm trying to copy these cells AS IS into an EXCEL chart, retaining the exact appearance it has in the spreadsheet. The chart I'm pasting the table into already has other data plotted in it. In order to retain the format (borders, subscripts, etc.) that the table has in the spreadsheet I first have to paste it into a blank MSWord page using "Paste special", then selecting "Picture (Enhanced Metafile)". Then I copy it from MSWord into the EXCEL chart using ctr+v. If I try to copy the formatted cells from the worksheet directly to the chart, the format of the sheets (the border shading, column widths, subscripts) gets changed, or sometimes EXCEL automatically graphs the numbers in the table. The problem happens when I paste the highlited cells from EXCEL into MSWord using the "Paste special" then "Picture (Enhanced Metafile)" sometimes it pastes something else that was previously pasted onto the clipboard. I don't know how to keep this from happening. This feature of EXCEL with a clipboard that has multiple items is something I absoulutely don't need. Is there a way I can turn this off? I want to turn off COMPLETELY the feature that stores more than one item at a time on the clipboard, so when I paste from the EXCEL spreadsheet to MSWord using "Paste special", then "enhanced metafile", it pastes what I most recently copied to the clipboard in EXCEL. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clipboard Item not collected | Excel Discussion (Misc queries) | |||
how do i remove the item from clipboard? | New Users to Excel | |||
Select one of many clipboard item to paste into document | Excel Worksheet Functions | |||
clipboard in Excel collects but will only paste most recent item | Excel Discussion (Misc queries) | |||
Item in clipboard | Excel Worksheet Functions |