How can I copy down, the contents of a cell and not color

W

wade_aus10

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

CLR

Try Copy > PasteSpecial > Value, or Copy > PasteSpecial > Formula

Vaya con Dios,
Chuck, CABGx3
 
G

Gord Dibben

Wade

If you use Conditional Formatting to color the alternate rows, you won't be
bothered by the copying.

Select rows 1 to 50 then Format>Conditional Formatting>Formula is:

=MOD(ROW(),2)=1

Format>Pattern

The alternate rows will be the color you picked.

When dragging formulas down the color won't change.

Will also retain the alternate coloring when sorting or inserting/deleting rows.


Gord Dibben MS Excel MVP
 
Top