ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert row disappeared (https://www.excelbanter.com/excel-discussion-misc-queries/246565-insert-row-disappeared.html)

Tia Joseph, CSp

Insert row disappeared
 
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?

Gord Dibben

Insert row disappeared
 
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,
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?




All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com