Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shift-edit paste picture in Excel
We recently upgraded to Office Pro 2003. I copy several cells from one tab to
another. Because of differences in column widths, I use the CTRL-COPY and SHIFT-EDIT PASTE PICTURE option. In Excel XP when I used the SHIFT-EDIT PASTE PICTURE menu command, the picture held the color formatting. In Excel 2003 it pastes as black text. Is there a way to get the color formats to be pasted? -- I know enuff to be dangerous. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
shift-edit paste picture in Excel
When copying from one worksheet to anotherr a keep formating you need to do
two steps. first paste the data. Then repeat the paste using the Edit Menu - Select Paste Special. Select format. "RealGomer" wrote: We recently upgraded to Office Pro 2003. I copy several cells from one tab to another. Because of differences in column widths, I use the CTRL-COPY and SHIFT-EDIT PASTE PICTURE option. In Excel XP when I used the SHIFT-EDIT PASTE PICTURE menu command, the picture held the color formatting. In Excel 2003 it pastes as black text. Is there a way to get the color formats to be pasted? -- I know enuff to be dangerous. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
shift-edit paste picture in Excel
The time someone in my office had a similar problem, his default printer was
a black and white printer and the "copy picture as printed" copied it in black and white, so when he pasted it, it pasted in black and white. "RealGomer" wrote: We recently upgraded to Office Pro 2003. I copy several cells from one tab to another. Because of differences in column widths, I use the CTRL-COPY and SHIFT-EDIT PASTE PICTURE option. In Excel XP when I used the SHIFT-EDIT PASTE PICTURE menu command, the picture held the color formatting. In Excel 2003 it pastes as black text. Is there a way to get the color formats to be pasted? -- I know enuff to be dangerous. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ability to paste from Picture Manager to Excel | Setting up and Configuration of Excel | |||
CUT AND PASTE A .JPEG PICTURE TO EXCEL, THEN IT WONT PRINT | Excel Discussion (Misc queries) | |||
Can an Excel formula be created to paste a picture in a cell? | Excel Worksheet Functions | |||
how to paste a picture into the header of spreadsheet in Excel 20. | Excel Discussion (Misc queries) | |||
How do I edit, copy and paste text in excel cells? | New Users to Excel |