View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Copy color - Excel 2007

Hi

Not sure what you mean by "copy color".
If you mean the Format Painter represented by the paintbrush icon, yes
it is still available.
Either
On the Home tab, the Format Painter is at the bottom right of the
Clipboard - the first section on Home tab
Or
When you right click on a cell, in addition to all of the Cut, Copy
Paste etc, there is a small floating toolbar above this with options for
most types of cell formatting including the format painter as the top
right icon.

If you don't see this additional floating toolbar, click the round
Office Button (top left), click on Excel Options and on the first
section displayed, the first option is to Show Mini toolbar on
Selection. Ensure it is ticked.

As with previous versions, a single click of the icon allows a single
"paint", but a double click of the icon makes it "sticky", allowing you
to paint lots of cells. Pressing Esc switches it off again.

--
Regards

Roger Govier


"KrunoG" wrote in message
...
Is there a "copy color" option in Excel 2007 ?
like in earlier versions

BR

K.