Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
the insert row with the asterisk disappeared from my list
I have a worksheet with several lists. A couple of times now, I have had the
insert row (with the asterisk) disappear from the end of some of the lists. Right now I have a worksheet with 5 lists. The first four don't have an insert row when they're active. The last one does. How does this happen and how can I get the insert row back? I've tried converting it back to a range and recreating the list, but this doesn't work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
the insert row with the asterisk disappeared from my list
"Mark" wrote: I have a worksheet with several lists. A couple of times now, I have had the insert row (with the asterisk) disappear from the end of some of the lists. Right now I have a worksheet with 5 lists. The first four don't have an insert row when they're active. The last one does. How does this happen and how can I get the insert row back? I've tried converting it back to a range and recreating the list, but this doesn't work. Replying to my own message in case anyone's looking for an answer. I also found that I wasn't able to insert a row into a list. I got a message saying that I couldn't insert into a "filtered list" even though I didn't have any filters on. I went into the working list (maybe any of them would have worked) and went to the DATA/FILTER/ADVANCED FILTER selection. In the Criteria Range there was a reference to a seemingly random cell in the first list on the worksheet, which was not working. I deleted the reference. Suddenly all the other lists were working and going into them showed that the criteria range was blank. I don't know why this worked nor will I swear that I also didn't make some other inadvertent change at the same time, but in case you've had this problem........ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert into Header/Footer List Box | Excel Worksheet Functions | |||
Excel drop down list arrow has disappeared. | Excel Worksheet Functions | |||
How to auto insert rows in a list of numbers | Excel Discussion (Misc queries) | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
How do I find data from a list (or table) and insert it in a row? | Excel Discussion (Misc queries) |