delete cells with formulas

I have a spreadsheet of employees' names, #'s, etc. I need to delete rows
and add new names, etc. The formulas says =+SUM(A73+1) for example. I can't
just highlight the row and delete because it gives me an error #REF!+1.
Please help.

You have responses at your "how do you delete cells when they are connected
with a formula" post....Were they not helpful?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Rere" wrote:

> I have a spreadsheet of employees' names, #'s, etc. I need to delete rows
> and add new names, etc. The formulas says =+SUM(A73+1) for example. I can't
> just highlight the row and delete because it gives me an error #REF!+1.
> Please help.