Prev: Filtered data range reference is too complex
Next: Dropdown list in HTML document
From: Tia Joseph, CSp Tia Joseph, on 26 Oct 2009 12:56
Normally, when I work with a list, an "insert row' is displayed directly
below the last row of data, with a blue asterisk (*) inside the left-most
cell.

Now, when I reactiveate the list (by clicking a cell within it), the list
border does not drop down to display the inserted row anymore.

How did I lost this? And what do I need to do to get my "insert row" back?
From: Gord Dibben on 26 Oct 2009 14:23
I can replicate this only when the worksheet is protected but this also
hides the dropdown arrows so I guess you would have noticed that.


Gord Dibben MS Excel MVP

On Mon, 26 Oct 2009 09:56:01 -0700, Tia Joseph, CSp <Tia Joseph,
CSp(a)discussions.microsoft.com> wrote:

>Normally, when I work with a list, an "insert row' is displayed directly
>below the last row of data, with a blue asterisk (*) inside the left-most
>cell.
>
>Now, when I reactiveate the list (by clicking a cell within it), the list
>border does not drop down to display the inserted row anymore.
>
>How did I lost this? And what do I need to do to get my "insert row" back?

 | 
Pages: 1
Prev: Filtered data range reference is too complex
Next: Dropdown list in HTML document