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

Report
-
TrowaD
Posts
2598
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 10, 2020
-
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!



1 reply

Posts
2598
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 10, 2020
401
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
Thank you

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

CCM 3543 users have said thank you to us this month