If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete text in cells but keep formula | YanYan | Worksheet Functions | 4 | December 1st, 2005 01:08 PM |
refreshing formulas in cells | Daigle | General Discussion | 7 | November 28th, 2005 05:01 PM |
pasting or moving formula cells without updating formulas | jake | General Discussion | 2 | April 14th, 2005 01:02 PM |
Contiguous cells are blank - Delete | Howard | General Discussion | 2 | October 11th, 2004 10:41 PM |
Delete rows in Excel file with formulas | Krassimir | Setting up and Configuration | 1 | October 1st, 2003 03:17 AM |