delete cells with formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rere - 28 Dec 2005 16:46 GMT

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.

Reply to this Message

Ron Coderre - 28 Dec 2005 18:19 GMT

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

> 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.

Reply to this Message