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.