Sage-Tips

Why does my drop down list keep disappearing?

Show drop down list’s disappeared arrow again with one option-checked. In some cases, the arrow of drop down list disappears because the option called In-cell dropdown is not checked. 3. Clock OK to close dialog, and you can see the arrow of drop down list has been shown.

Why is Excel not showing my drop down list?

In the Data Validation dialog box, you can turn off the option for a dropdown list. To turn it back on: Select the cell that contains a data validation list. On the Settings tab, add a check mark to In-cell dropdown.

Why is my data validation drop down not showing?

Drop Down Option Even though the default setting for a data validation list is to show the arrow, it’s possible to change that setting. On the Ribbon, click the Data tab. In the Data Tools group, click Data Validation. On the Settings tab, add a check mark to In-cell drop down.

How do I keep the drop down button in Excel?

Go to the Data tab in the ribbon, then press the Data Validation button. Select the Input Message tab. Click the checkbox: “Show input message when cell is selected”.

Why is the data validation greyed out in Excel?

The reason Data Validation is Greyed Out is due to the characteristics of your spreadsheet. If you spreadsheet is “Protected” or being “Shared” with another file, the Data validation tool is turned off in Excel. The other option is to copy the data set into a new worksheet that is not shared.

How do you keep data validation in Excel?

Add data validation to a cell or a range

1. Select one or more cells to validate.
2. On the Data tab, in the Data Tools group, click Data Validation.
3. On the Settings tab, in the Allow box, select List.
4. In the Source box, type your list values, separated by commas.
5. Make sure that the In-cell dropdown check box is selected.

Why is Data Validation grayed out?

How do I restore Data Validation in Excel?

Select the cell(s) with data validation. On the Data tab, click the Data Validation button. On the Settings tab, click the Clear All button, and then click OK.

Why Data Validation is not visible in Excel?

You might currently be entering data – The Data Validation command is not available while you are entering data in a cell. To finish entering data, press Enter or ESC to quit. The worksheet might be protected or shared – You cannot change data validation settings if your workbook is shared or protected.

How do I create a cell dropdown rule in data validation?

How do I unlock Data Validation in Excel?

How to solve [data validation drop down list disappeared]?

[Solution] Data Validation Drop down List Disappeared 1 Use code tags for VBA. [code] Your Code [/code] (or use the # button) 2 If your question is resolved, mark it SOLVED using the thread tools 3 Click on the star if you think someone helped you See More….

How do you use drop down lists in Excel?

Drop-down lists in a cell (also known as validation lists) are a great way to make your Excel model interactive. When a user selects the cell that contains a drop-down list, a small icon appears to the right of the cell. Clicking on this icon allows them to make a selection from a list.

Why did my dropdown arrows disappear from my Excel spreadsheet?

If you used the camera tool, then if the input cells of the camera tool object (the linked cells) are on a different worksheet as the data validation dropdown enabled cells, the dropdown arrows go missing. They aren’t actually gone, however:

Why did my drop-down button disappear?

I’ve just had the same disappearing drop-down button behaviour shown in your gif. It might be there are other things that cause this behaviour as well but in my case it was caused by using the camera tool. Deleting the camera image restored the normal drop-down button visibility.