| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel linked values turn to #REF! after clicking don't update | Excel Worksheet Functions | |||
| how to turn positive to negative values in excel | Excel Worksheet Functions | |||
| Copying cell values once and then making them static | Excel Worksheet Functions | |||
| Linked values turn to #REF! after clicking don't update | Excel Worksheet Functions | |||
| Why do formulas turn to values wen copying in Excel 2003... | Excel Worksheet Functions | |||
Linear Mode
