Use absolute cell references in your formulas.

$A1 to lock the column

A$1 to lock the row

$A$1 to lock both column and row.

Note: you can mix them in formulas like a VLOOKUP formula.

=VLOOKUP(A1,$B$1:$E$50,3,FALSE)

When dragged down, the A1 will change but the table array remains the same.


Gord Dibben MS Excel MVP

On 17 May 2007 21:30:48 -0700, tc wrote:

when i copy a formula to a range of cells the formula logically
changes according to the other cells. However, i need to maintain the
very same formula throughout the range of cells . i am able to
successfully paste the same formula to a single cell, but not to a
range of cells.