Forum Discussion

Copper Contributor

Feb 21, 2023

Solved

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 fix...

excel

SergeiBaklan
Feb 21, 2023
BillR30

If you have reference like

=A1

use absolute reference instead to fix it

=$A$1

BillR30

Copper Contributor

Feb 21, 2023

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

SergeiBaklan

Diamond Contributor

Feb 22, 2023

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