Pasting Same Formula

[tc]

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.

 

[Gord Dibben]

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

 

[NickHK]

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