how do you add a drop down menu in excel 2016

Just include the cells that should appear in the drop-down. If you already made a table with the drop-down entries, click in theīox, and then click and drag the cells that contain those entries. Select the cell in the worksheet where you want the drop-down list. Sort your data in the order you want it to appear , any drop-downs you based on that table will automatically update. Why should you put your data in a table? When your data is in a table, then as you

To stop people from entering data that isn’t in the drop-down list, click Information will show a message with this iconĪnd Warning will show a message with this icon To show a message that doesn’t stop people from entering data that isn’t in the drop-down list, click If you don’t want a message to show up, clear the check box. Show error alert after invalid data is enteredīox, and type a title and message. If you want a message to pop up when someone enters something that's not in your list, check the

If you want a message to pop up when the cell is clicked, check theīox, 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 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. Or stop sharing the worksheet, and then try step 3 again.īox, then select your list range. Unlock specific areas of a protected workbook , the worksheet might be protected or shared.

How do you add a drop down menu in excel 2016