You could name your references, which will automatically make the reference
absolute. If you name the cells in an existing spreadsheet the formulas that
contain references to those cells will automatically reference the named
range instead.

When you copy the formulas they always refer back to the original cells.
--
Kevin Backmann


"GregP1962" wrote:


How do I copy formulas from a large group of cells to another group of
cells and have them all keep the references to the same cells? (It
normally changes the referneces to a cell that has the same position in
relation to the former cell) I don't want to go in and change all of the
references, adding the $ sign.


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=528771