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

[Guest]

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?

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3

 

[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

 

[Chip Pearson]

Use Conditional Formatting to color the rows. See
www.cpearson.com/excel/banding.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)