Excel Auto Fill
Closed
Kris
-
Nov 3, 2011 at 09:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 8, 2011 at 10:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 8, 2011 at 10:26 AM
Related:
- Excel Auto Fill
- Grand theft auto 1 download - Download - Action and adventure
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Nvidia drivers auto detect - Guide
- Auto redial - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 8, 2011 at 10:26 AM
Nov 8, 2011 at 10:26 AM
Hi Kris,
So you want to keep the row numbers in your formula when dragging down?
Then use absolete cell references. Put a $ symbol in front of the row numbers you want to keep, You can also click on the range in your formula and hit F4 multiple times to cycle through the different references.
Best regards,
Trowa
So you want to keep the row numbers in your formula when dragging down?
Then use absolete cell references. Put a $ symbol in front of the row numbers you want to keep, You can also click on the range in your formula and hit F4 multiple times to cycle through the different references.
Best regards,
Trowa