![]() |
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. |
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. |
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. |
All times are GMT +1. The time now is 11:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com