You can always ask an expert in the Excel Tech Community or get support in the Answers community.Always show arrow of data validation list with a symbol inserting If you decide you want to change the options in your drop-down list, seeĪdd or remove items from a drop-down list For example, you might want to check to see if If you don’t want a message to show up, clear the check box.Īfter you create your drop-down list, make sure it works the way you want. If you don’t want a message to show up, clear the check box. You can also just type a list of entries in theĬheckbox, and type a title and message in the boxes (up to 225 characters). 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 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.

Openoffice calc dynamic drop down list