Missing Lists options

[mikecox39]

I have a workbook with a "Details" sheet and a "Lists" sheet. The Lists sheet has my Account names.

There is an Account column on the Details sheet. I used to be that when I clicked on an empty cell in that column a triangle appeared at the right edge of the cell with the List from the Lists sheet, from where I could select the Account I want to appear in that cell. That is no longer happening, except in cells with data.


If I click the lower right corner of the last cell with data and drag it down the triangle returns but it also puts the Account of that last cell into the empty cells, as expected.

How do I get the triangle option back, without the data?

 

[Rick Rothstein]

I have a workbook with a "Details" sheet and a "Lists" sheet. The Lists sheet has my Account names.

There is an Account column on the Details sheet. I used to be that when I clicked on an empty cell in that column a triangle appeared at the right edge of the cell with the List from the Lists sheet, from where I could select the Account I want to appear in that cell. That is no longer happening, except in cells with data.


If I click the lower right corner of the last cell with data and drag it down the triangle returns but it also puts the Account of that last cell into the empty cells, as expected.

How do I get the triangle option back, without the data?

That triangle is from a Data Validation List (Data tab, Data Tools panel, Validation button, List option)... you can select your new cells and impose the same list on them as was used in the cells above them OR copy the last cell with an arrow down one cell, delete the contents only (do not do a Clear All) of the that newly copied cell and then copy that newly cleared cell down as far as you need.

 

[mikecox39]

That triangle is from a Data Validation List (Data tab, Data Tools panel, Validation button, List option)... you can select your new cells and impose the same list on them as was used in the cells above them OR copy the last cell with an arrow down one cell, delete the contents only (do notI do a Clear All) of the that newly copied cell and then copy that newly cleared cell down as far as you need.

The liked the second option, I will use it in the future when I'm faced with this dilemma. Thanks (-;