| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
stop excel changing formulas
i have a summary worksheet which looks up stock from other worksheets and
totals them for me. The problem is if i insert or delete a row into my stock excel automatically adjusts the formula range up or down. How do i keep the formula exactly as typed without the range being automatically adjusted? Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Stop Date Values from Changing to Formulas | Excel Worksheet Functions | |||
| How do I stop last number from changing to a 0 in excel | Excel Discussion (Misc queries) | |||
| When I add a row to excel how can I stop formulae changing | Excel Discussion (Misc queries) | |||
| how do i get excel to stop changing my input 5-9 to 9-May???? | Excel Discussion (Misc queries) | |||
| How do I stop excel from changing single numbers like 1 into a de. | Excel Discussion (Misc queries) | |||
Threaded Mode
