ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   delete cells with formulas (https://www.excelbanter.com/new-users-excel/62107-delete-cells-formulas.html)

Rere

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.

Ron Coderre

delete cells with formulas
 
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.



All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com