View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lanza52 Lanza52 is offline
external usenet poster
 
Posts: 1
Default Adjusting Referances


Before whenever I would move a Cell to another place, all cells that
used it in a formula would adjust. Now, for some reason the cells arn't
adjusting, did I undo an option and is there anyway to fix this?

Exampe incase you don't understand.
A1= 15
A2= A1*3

Before if I would move A1 to A3 then A2 would change automatically to
A3*3. Now A2 is staying at A1*3.


--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316
View this thread: http://www.excelforum.com/showthread...hreadid=573599