Then it will prompt up a "New Name" window.Select all of your values, right-click, and then click "Define Name".They should be in a single column or row without any blank cells (for easy to use, it is recommended to sort your values). On a new worksheet, type the values that you want to appear in your drop-down list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |