Autofill with constant

New 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? 


3 Replies
best response confirmed by Hans Vogelaar (MVP)


If you have reference like


use absolute reference instead to fix it


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