How to drag a formula without changing color.
Closed
ShaunaB
-
Sep 29, 2010 at 02:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 30, 2010 at 10:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 30, 2010 at 10:13 AM
Related:
- How to drag formula down in google sheets
- How to change sheet direction in google sheets - Guide
- Google meet download for pc - Download - Video calls
- Free fire id transfer facebook to google - Guide
- Number to words in excel formula - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 30, 2010 at 10:13 AM
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
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
