D
DCLBaker
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 can’t figure out how to turn it off. It
is causing me a lot of extra work.
Anyone’s help would be GREATLY appreciated!!!! HELP!
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 can’t figure out how to turn it off. It
is causing me a lot of extra work.
Anyone’s help would be GREATLY appreciated!!!! HELP!