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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |