View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GregP1962
 
Posts: n/a
Default Copying formulas to other cells. Keeping references w/o $ sign.


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 cells that have 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=535102