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.

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.

I assume you have some formula like:
=A1
You can make the row and/or column Absolute rather than Relative by using a
"$". e.g.
=$A$1

Check the help for "About cell and range references".

NickHK

"tc" wrote in message
ups.com...
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.