Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create List/Add Row
Hello,
I used the "Create List" function for a number of columns in a worksheet - but not all. I need to add a row, and I keep getting a message that says, "This operation is not allowed. The operation is attempting to shift cells in a list on your worksheet." I can add a row IN a list, but it only adds it in one column and doesn't carry it across the worksheet. It's when I try to add a row outside of a list that I get the error. Is there a way to correct this, so I can add/delete rows as needed? Thank you, in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create List/Add Row
Maybe you can convert each list back to a range, delete the row and then change
the ranges back to lists. hjneedshelp wrote: Hello, I used the "Create List" function for a number of columns in a worksheet - but not all. I need to add a row, and I keep getting a message that says, "This operation is not allowed. The operation is attempting to shift cells in a list on your worksheet." I can add a row IN a list, but it only adds it in one column and doesn't carry it across the worksheet. It's when I try to add a row outside of a list that I get the error. Is there a way to correct this, so I can add/delete rows as needed? Thank you, in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
I do not have the List-create a list option on my data toolbar ?? | New Users to Excel | |||
Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
Auto filtering vs Date List Create List | Excel Worksheet Functions | |||
Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) |