Formala

[Guest]

How do I drag a formula in a column while preventing Excel from automatically
incrementing the cell location of the first (and or second) value of the
formula?

 

[Niek Otten]

Change the initial formula from (example) =A1 to =$A$1
This can easily be done by hitting F4 at the time of entering the address.

--
Kind regards,

Niek Otten

| How do I drag a formula in a column while preventing Excel from automatically
| incrementing the cell location of the first (and or second) value of the
| formula?

 

[Guest]

Use Absolute Cell References, denoted with a $.

$A$1 will not increment when copied.
$A1 will increment the row, but not the column
A$1 will increment the column, but not the row
A1 will increment both row and column

HTH,
Elkar