| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete a row without dirupting the formulas in the following rows
I am making a schedule that is updated daily and each time I update it I have
to delete the rows that have been completed, but when I delete them all the cells below that have formulas that once related to the cells in the row I deleted all turn to "#value!" instead of just adapting to the new row that was moved up and accepting those cells in the formula. Is there anyway to make excel do that? What I'm currently doing is deleting my rows and then highlighting the rows below and dragging them up over the messed up formulas to correct them, but that gets to be time consuming. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete the test values, but do not delete the formulas | Excel Discussion (Misc queries) | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| How to delete rows using formulas | Excel Worksheet Functions | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
Threaded Mode
