osebabes.blogg.se

Select or clear the Ignore blank depending on how you want to handle empty cells.Make sure the In-cell dropdown box is checked otherwise the drop-down arrow won't appear next to the cell.In the Source box, type the items you want to appear in your drop-down menu separated by a comma (with or without spaces).In the Data Validation window, on the Settings tab, do the following: Enter the list items and choose the options. On the Excel ribbon, go to the Data tab > Data Tools group and click Data Validation.ģ. Use Excel Data Validation to create a drop-down list. You can even select non-contiguous cells by pressing and holding the Ctrl key while selecting the cells with the mouse.Ģ. If you select the whole column, a drop down menu will be created in each cell of that column, which is a real time-saver, for example, when you are creating a questionnaire. This can be a single cell, a range of cells or the entire column. You start by selecting a cell or cells where you want a drop-down box to appear. Select a cell or range for your drop-down list. This is the fastest way to add a drop-down box in all versions of Excel 2010 through Excel 365. Drop-down box from comma-separated valuesĬreate drop down list with comma-separated values.Below you will find a quick outline of the main advantages and drawbacks as well as the detailed step-by-step instructions for each method: On the whole, there are 4 ways to create a drop down menu in Excel using the Data Validation feature. How to copy a dropdown into multiple cells.