How to drag a formula without changing color.

Closed
ShaunaB - Sep 29, 2010 at 02:03 PM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Sep 30, 2010 at 10:13 AM
Hello,
I have a spread sheet with different colored rows. I want to drag a formula down a column with about 500 cells through the alternating colors. Is there a way that I can copy the formula without copying the color and thus changing the colors of the other cells?
Thanks!



Related:

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Sep 30, 2010 at 10:13 AM
Hi ShaunaB,

When done dragging your formula and messing up all your colors a small square will appears near the place where you stopped dragging. Clicking this square will give you a couple of options, one of which will let you keep your format. When selecting that option your altered cells will get their original color back.

Best regards,
Trowa
13