audioguy52:

If I understand the question correctly then you need to add $ signs to the formula  such as $A$1 so that the cells you copy the formula to will continue to pint to the cell A1.  If understood incorrectly please let me know

ktwannabe

If you want the cell to stay contant (ie, ref cell A1, hit the F4 key once selected A1 (should look like this, $A$1, or you can just type in the $).

If you only want the columns to remanin constant, type $A1, or for rows type A$1.

With this done, no matter where you copy cell to on worksheet, the row/column/both will remain unchanged.

Thanks guys, the $ in front of the row & column designators did the trick.

Thanks again!

Just a note:

When you finish pasting formulas containing absolute cell references (like those using $ signs), it's a good idea to remove them from the sheet using edit find/replace.  I have had some trouble in the past copying parts of Excel sheets that contained absolute references without realizing this, and it can be very troublesome to be referring to a part of a sheet, (or another file) by mistake.  

i.e. absolute references retain the full filename and excel tab to which they are pointing ...yikes.

my 2 cents...

tg