ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adjusting Referances (https://www.excelbanter.com/excel-worksheet-functions/106101-adjusting-referances.html)

Lanza52

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



All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com