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 fix...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 21, 2023

    BillR30 

    If you have reference like

    =A1

    use absolute reference instead to fix it

    =$A$1

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 21, 2023

BillR30 

If you have reference like

=A1

use absolute reference instead to fix it

=$A$1

  • BillR30's avatar
    BillR30
    Copper Contributor
    Feb 21, 2023
    Thanks. I should have remembered that. Ages since I've used Excel in anger.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Feb 22, 2023

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

Resources