Make sure that the cell references are absolute (such as $A$2) and not relative (such as A2, or A$2, or $A2). Note: If you want to create a drop-down list in multiple cells at one go, select all the cells where you want to create it and then follow the above steps. This will create a drop-down list that lists all the fruit names (as shown below).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |