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 Contributor Last seen December 27, 2022 - Sep 30, 2010 at 10:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 30, 2010 at 10:13 AM
Related:
- Google sheets drag formula without formatting
- Google sheets right to left - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Virtualbox drag and drop - Guide
- Student position formula in excel ✓ - Office Software Forum
- Number to words in excel formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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
