| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I keep a formula from changing if a row is added or deleted
I have a formulas referencing cells in another worksheet. When rows are
added or deleted from the worksheet the formulas are either changed to skip the new row or receive an #REF! error when a row is deleted. Regardless of what happens in the worksheet I want the formulas to remain the same. |
|
#2
|
|||
|
|||
|
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany cwolt wrote: I have a formulas referencing cells in another worksheet. When rows are added or deleted from the worksheet the formulas are either changed to skip the new row or receive an #REF! error when a row is deleted. Regardless of what happens in the worksheet I want the formulas to remain the same. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use TODAY Function in formula without it changing the next . | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Linear Mode
