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:
- Google sheets drag formula without formatting
- Google meet download for pc - Download - Video calls
- Position formula in excel ✓ - Office Software Forum
- Google sheet right to left - Guide
- Google authenticator pc - Download - Password management
- Logitech formula vibration feedback wheel driver - Download - Drivers
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
