This means the user won’t necessarily know that there is a drop-down list for them to choose from. The problem is that the drop-down icon arrow disappears when the user selects a different cell. Clicking on this icon allows them to make a selection from a list. When a user selects the cell that contains a drop-down list, a small icon appears to the right of the cell. Mr Excel Podcast #1816 – Other solutions by Bill Jelenĭrop-down Arrow Always Visible Example.xlsx (28.9 KB) Problem: The Drop-down List Arrows Disappearĭrop-down lists in a cell (also known as validation lists) are a great way to make your Excel model interactive. Video: Drop-down List Arrow Always Visible This technique will make the drop-down arrow permanently visible on the worksheet, even if the user selects a different cell. Bottom Line: The drop-down arrow (icon) for a data validation list disappears when another cell is selected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |