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. |