You can give the List range a Name then use it for the Source. One way around this and a better solution is to give the List range a Name. This is a better method than manually entering the values, but older versions of Excel require the list to be on the same worksheet.
The same list data was put into the range J1: J6, then I changed the source reference to these cells. A better way is to put the list in a range, then refer to the range. Manually entering the source data for the Excel 2010 drop down list is probably the least desirable method. The list I created was for cell A1, which is shown below. Make sure the In-cell dropdown box is checked.Type in a list of values separated by a comma.Choose Data Validation from the Data Tools group on the Data tab.Select the cell or range you want to use for a drop-down list, then How to Create a Drop Down List in Excel for a Cell or Range This article walks you through a step-by-step guide of how to create a drop down list in Excel. Here we’ll use a List to restrict what values can be entered into a cell.
Data Validation is used to define restrictions on what data can or should be entered into a cell. As tech nerds, we’re happy that such an option exists within an Excel spreadsheet.Īdding a drop-down list to a cell or range using Data Validation is a simple matter. For example, if you have ever used such a menu for surveys, polls, and web forms, you know how convenient they are. As you may already know, drop down lists make data entry a breeze. Those wondering how to create a drop down list in Excel will be relieved to know that it is easier than it sounds.
0 kommentar(er)
