Forum Discussion
BillR30
Feb 21, 2023Copper Contributor
Autofill with constant
Trying to use autofill for a formula down a column.
It references a number in a single cell.
When I use autofill it tries to use other cells for that reference.
How can I keep that reference fixed without just typing the number in?
Thanks!
3 Replies
- SergeiBaklanDiamond Contributor
- BillR30Copper ContributorThanks. I should have remembered that. Ages since I've used Excel in anger.
- SergeiBaklanDiamond Contributor
BillR30 , no problem, we are all forgetting something from time to time