In case, you don’t need to show any message then leave the option “show input message when cell is selected” unselected. Now assign the title and message which you want to show in the dialog box i.e.To make a message box to pop-up when you make a tap over the cell, in that case you need to choose the “Show input message when cell is selected”.If you don’t want that empty cell create any kind of issue then make a check across the Ignore blank Also tick the In-cell dropdown option. Remember: we have left the header row just because we need not to include this in the selection area:Ħ. In the shown example we are putting our data on the sheet named as cities in the A2:A9. Go to the Source box and choose the list range.From the Settings tab you have to hit the Allow box, and then choose the List option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |