AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() On the Settings tab, add a check mark to In-cell drop down.In the Data Tools group, click Data Validation.Select the cell that contains a data validation list.In the Data Validation dialog box, you can turn off the option for a drop down list. Under ‘For Objects, Show’, select All, then click OKĮven though the default setting for a data validation list is to show the arrow, it’s possible to change that setting.Scroll down to the ‘Display Options for This Workbook’ section.Click the Office Button, then click Excel Options.To make the objects visible again, follow these steps: Because they’re objects too, the drop down arrows will also be hidden. Maybe there were some other shapes on the worksheet, like logos, or text boxes, and you changed a setting to hide them. If you want drop down arrows that are always visible, you can use combo boxes instead of data validation. If you want to make it easy to find the cells that have data validation lists, you can colour the cells, or add a cell comment. So, you might have 100 cells with data validation drop down lists, but you’ll only see the arrow in the active cell. The data validation drop down arrow only shows when you click on the cell. Later, you opened that workbook, and the data validation arrows are missing! What happened, and how do you get those arrows back? ![]() You added some data validation drop down lists to your Excel worksheet, to make it easier to enter the data. ![]()
0 Comments
Read More
Leave a Reply. |