How do I turn off Static values
Hi, Does anyone know who to resolve this problem? Every time I do a
formula it automatically adds a $ to the column and row reference to lock the formula to that exact spot, instead of allowing for flexibility if the information I am wanting to calculate changes directions. I have to use the €śreplace€ť to remove the $. So the formula looks like this: =sum$H$7. Somehow I turned on this method and I cant figure out how to turn it off. It is causing me a lot of extra work. Anyones help would be GREATLY appreciated!!!! HELP! |
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com