8/24/2023 0 Comments Excel drop down list![]() In this example, you'd add or remove entries in cells A2 through A5. If the Source box contains a reference to a range of cells (for example, =$A$2:$A$5), click Cancel, and then add or remove entries from those cells. For example: Fruits,Vegetables,Meat,Deli. When you're done, each entry should be separated by a comma, with no spaces. If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need. On the Settings tab, click in the Source box. Select the cells that have the drop-down list. ![]() In Excel for the web, you can only edit a drop-down list where the source data has been entered manually.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |