View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default How can I copy down, the contents of a cell and not color

Try Copy PasteSpecial Value, or Copy PasteSpecial Formula

Vaya con Dios,
Chuck, CABGx3



"wade_aus10" wrote:

I set up alternate colors in rows. But when I go to copy a formula down, or
the contents down (or right), the color of the cell is copied also.
How can I copy the contents only and leave the background color of the cells
the same?