Change the reference to Absolute.

=A1 is relative and will increment as copied.

=$A$1 is absolute and will remain as is when copying

To add the $ signs, highlight the references in the formula bar and hit F4 key
to cycle through your options.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 15:51:28 GMT, "s2m via OfficeKB.com" <u23063@uwe wrote:

how can I copy a formula that does not change the column or row number?
I want to use the same formula with set column and row but when I copy from
cell to cell it goes to the next column or row