How to drag a formula without changing color. [Closed]

- - Latest reply: TrowaD
Posts
2569
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 25, 2019
- 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!



See more 

1 reply

Best answer
Posts
2569
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 25, 2019
377
13
Thank you
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

Say "Thank you" 13

A few words of thanks would be greatly appreciated. Add comment

CCM 5739 users have said thank you to us this month