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?