Autofill with constant

[BillR30]

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! 

[#2 · Accepted solution]

@BillR30 

If you have reference like

=A1

use absolute reference instead to fix it

=$A$1

[#3]

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

[#4]

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