| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Way to keep formulas unchanged when deleting rows?
I have a bunch of references to some data that I copy into a datasheet.
Occasionally, this data has some blank rows or rows with unneeded data in it. If I delete those rows, it messes up all the formulas on other pages. Is there a way to define the formulas such that deleting data won't change them? I've tried using absolute cell references ($A$5), but when I delete the line, this cell reference gets changed. Thanks, Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting rows messing up formulas | Excel Discussion (Misc queries) | |||
| Excel 2002 - How to keep the formulas unchanged ? | Excel Discussion (Misc queries) | |||
| Adding and deleting rows with formulas ****Need Help**** | Excel Discussion (Misc queries) | |||
| Question about deleting rows and formulas | Excel Discussion (Misc queries) | |||
| deleting rows--calculating formulas with each row as it goes? | Excel Discussion (Misc queries) | |||
Threaded Mode
