shift-edit paste picture in Excel

R

RealGomer

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?
 
J

Joel

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.
 
B

bj

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Place picture in Excel cell 0
Paste to excel from word - auto format problem 1
Copy Picture in 2007 1
Paste as picture problem 0
copy and paste problem 2
Paste Options Icon does not show 0
How to SHIFT edit/copy/as shown when printed in Excel 2007? 2

Top