| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows without losing formulas
If I have a column of cells, say A1 to A15 with the values of A1=1,
A2=A1+1,A3=A2+1 etc, then if I want to delete say row A6, row A7 will show the #REF! error. Is there a way to delete the row without losing the formula in the next row? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Formulas while deleting rows | Excel Discussion (Misc queries) | |||
| Way to keep formulas unchanged when deleting rows? | Excel Discussion (Misc queries) | |||
| deleting rows messing up formulas | Excel Discussion (Misc queries) | |||
| Adding and deleting rows with formulas ****Need Help**** | Excel Discussion (Misc queries) | |||
| deleting rows--calculating formulas with each row as it goes? | Excel Discussion (Misc queries) | |||
Threaded Mode
