![]() ![]() On the Games worksheet, select cells B2 to C5, since we want the drop down list to be created for all cells within that range.From the Data tab on the ribbon, in the Data Tools group, click Data Validation.The 'Data Validation' dialog box appears. Click in the Source box and enter the formula.= OFFSET ( Source ! $A$2, 0, 0, COUNTA ( Source ! $A : $A ), 1 ) The above formula tells Excel to use cell A2 in the Source worksheet as the starting point (note the absolute reference to cell A2). Since the result that we want should begin with the reference cell, the offset should remain at zero rows, and zero columns (away from the starting point). #How to make a drop down list in excel searchable update.#How to make a drop down list in excel searchable how to.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |