Drop-down arrow not visible unless cell selected Excel 365

[metsmaniac]

The subject line pretty much says it. I have a drop-down list in Excel. Unless the cell is selected, the drop-down arrow is not visible.

I tried this site. My "in-cell dropdown" option is already checked.

How to show drop down list’s disappeared arrows again in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Unless the cell is selected, the drop-down arrow is not visible.

That's just how data validation works & AFAIK there is no way of changing it.

 

[Joe4]

The subject line pretty much says it. I have a drop-down list in Excel. Unless the cell is selected, the drop-down arrow is not visible.

I believe that is the default behavior of how Data Validation works. It only shows the arrow when you select the cell. It does not show it if it is not the active cell.
I do not recall ever seeing it behave any differently.

I tried this site. My "in-cell dropdown" option is already checked.

That just affects the behavior when you have selected that cell. If you uncheck it, it does not show the arrow at all, even when it is the active cell.

To do what you want may require you to use Form Controls or ActiveX Controls instead of Data Validation.
That may require a bit of VBA attached to it to populate the values and write the selections to the correct cells.

 

[metsmaniac]

I believe that is the default behavior of how Data Validation works. It only shows the arrow when you select the cell. It does not show it if it is not the active cell.
I do not recall ever seeing it behave any differently.


That just affects the behavior when you have selected that cell. If you uncheck it, it does not show the arrow at all, even when it is the active cell.

To do what you want may require you to use Form Controls or ActiveX Controls instead of Data Validation.
That may require a bit of VBA attached to it to populate the values and write the selections to the correct cells.

Understood. It works just like the validation comments that pop up. Thanks.