You can store the list of values on any worksheet (handy if you have multiple lists you need to maintain), or in a different spreadsheet. This will apply the same drop-down list to those cells too. If you want to make this list of values available to other cells in the same column, click in the cell, then click and drag the bottom right + of that cell down to the cells below it. ![]() The table cell now has a drop-down arrow next to it, and you can now select any item in your list. This range will display in the Source field as something like this: =$H$5:$H$10.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |