lasaspre.blogg.se

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. Go to the Data tab on the Ribbon, then Data Validation. Select the cell in the worksheet where you want the drop-down list. Now is a good time to Sort data in a range or table in your drop-down list. Why should you put your data in a table? When your data is in a table, then as you add or remove items from the list, any drop-downs you based on that table will automatically update. If you don’t, then you can quickly convert your list to a table by selecting any cell in the range, and pressing Ctrl+T. Ideally, you’ll have your list items in an Excel table. In a new worksheet, type the entries you want to appear in your drop-down list. Drop-downs allow people to pick an item from a list that you create. You can help people work more efficiently in worksheets by using drop-down lists in cells. Как сделать dropdownlist в excel? Create a drop-down list