If you don’t need this feature simply untick the Show input message when cell is selected option at the top. Just add a brief title in the relevant field, and then enter the explanation in the main Input message box. This can be handy if the question you’re posing is a complicated one. With that completed you can move onto the Input Message tab, which allows you to create a message that will appear when a user clicks on the dropdown cell. Make sure the In-cell dropdown box is ticked and, if you want people to be able to leave the field blank rather than choose from your list, tick the Ignore blank box too. Click on this and then enter an = sign followed immediately by the name of your list. A new option will now appear at the bottom of the window, entitled Source. Click on the Allow menu then select List. ![]() The Settings tab will open by default and in here you’ll see two drop-down menus. In the box that appears you’ll see three tabs – Settings, Input Message, and Error Alert – which we’ll go through one by one. ![]() Highlight the cell where the list needs to appear then go up to the menu bar at the top of the page and select Data>Data Validation. Open up an existing, or new, worksheet into which you want to place the drop-down list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |