Forum Discussion

BillR30's avatar
BillR30
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 fixed without just typing the number in? 

Thanks! 

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    BillR30 

    If you have reference like

    =A1

    use absolute reference instead to fix it

    =$A$1

    • BillR30's avatar
      BillR30
      Copper Contributor
      Thanks. I should have remembered that. Ages since I've used Excel in anger.

Resources