How to drag a formula without changing color.
Closed
ShaunaB
-
29 Sep 2010 à 14:03
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 30 Sep 2010 à 10:13
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 30 Sep 2010 à 10:13
Related:
- Google sheets drag formula without changing
- Google sheets download - Download - Spreadsheets
- Google sheets right to left - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Virtualbox drag and drop - Guide
- Position formula in excel ✓ - Office Software Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
30 Sep 2010 à 10:13
30 Sep 2010 à 10:13
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
