SOLVED

Autofill with constant

Copper Contributor

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
best response confirmed by Hans Vogelaar (MVP)
Solution

@BillR30 

If you have reference like

=A1

use absolute reference instead to fix it

=$A$1

Thanks. I should have remembered that. Ages since I've used Excel in anger.

@BillR30 , no problem, we are all forgetting something from time to time

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@BillR30 

If you have reference like

=A1

use absolute reference instead to fix it

=$A$1

View solution in original post