![]() ![]() To add an item to a drop-down list, go to the items and select an item.ģ. You can add or remove items from a drop-down list in Excel without opening the 'Data Validation' dialog box and changing the range reference. You can now enter a value that is not in the list. On the Error Alert tab, uncheck 'Show error alert after invalid data is entered'.ĥ. ![]() On the Data tab, in the Data Tools group, click Data Validation.ģ. To allow other entries, execute the following steps.Ģ. First, if you type a value that is not in the list, Excel shows an error alert. You can also create a drop-down list in Excel that allows other entries.ġ. For example, if a user types yes, an error alert will be displayed. Note: this makes your drop-down list case sensitive. You can also type the items directly into the Source box, instead of using a range reference. Note: to copy/paste a drop-down list, select the cell with the drop-down list and press CTRL + c, select another cell and press CTRL + v.ħ. Click in the Source box and select the range A1:A3 on Sheet2. The 'Data Validation' dialog box appears.ĥ. On the Data tab, in the Data Tools group, click Data Validation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |