![]() Next, go to the Settings tab and find the Allow box. Then, go to your Data tab and find the option for Data Validation under the Data Groups section: Now, head back to your working sheet and click the cell or cells that you'd like to validate. The list can be any length you'd like and can include any type of information - some common list items are Yes/No (often abbreviated as Y/N), Pass/Fail, numbered lists, and dates. To do this, head to your blank sheet and list the items that you'd like to include in your drop-down in Column A. In order to perform this operation, you will need at least two sheets open in your workbook: a working sheet and a blank sheet where you can compile your lists. Creating a Long Drop-Down List in Excel. ![]() Create Drop-Down List in Microsoft Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |