Formala
 

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?

Formala
 

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

"sdmccabe" wrote in message ...
| 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?

Formala
 

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

"sdmccabe" wrote:

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?