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!
|