Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete rows using formulas
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. Someone tried to help me but then I got the error #value!. This is a numerical sequence 1,2,3, etc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete rows using formulas
Please stay in the original thread, Ron already posted a follow up there
-- Regards, Peo Sjoblom "Rere" wrote in message ... 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. Someone tried to help me but then I got the error #value!. This is a numerical sequence 1,2,3, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete rows listed less than 8 times??? | Excel Worksheet Functions | |||
How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
Insert rows | Excel Worksheet Functions | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions |