ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   shift-edit paste picture in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/132339-shift-edit-paste-picture-excel.html)

RealGomer

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.

joel

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.


bj

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