If you don’t want a message to show up, clear the check box. If you want a message to pop up when the cell is clicked, check the Show input message when cell is selected box, and type a title and message in the boxes (up to 225 characters). ![]() If it’s OK for people to leave the cell empty, check the Ignore blank box. Note that we left out the header row, because we don't want that to be a selection option: We put ours on a sheet called Cities, in range A2:A9. On the Settings tab, in the Allow box, click List.Ĭlick in the Source box, then select your list range. Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again. Note: If you can’t click Data Validation, the worksheet might be protected or shared.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |