![]() ![]() In your excel spreadsheet, select all the cells which have reference to your drop-down list (In this example, select all rows from column Answers), i.e.You can do the same by following the below steps: Suppose we wanted to change the source value from “May Be” to “Not Sure”. You have preferences noted as the below image shows: ![]() As you can see in the below image, the values (Yes, No, May Be) are updated manually under source with a comma as a separator. When we say comma-separated-values, we mean that these values are manually entered as an input to the drop-down list while creating the same. You can see the image below for better generalization. ![]() Suppose you have some questions to the person who came for an interview in your company those questions are having polar answers (Yes/NO/May Be). You can download this How to Edit Drop Down List Excel Template here – How to Edit Drop Down List Excel Template Example #1 – Editing a Comma Separated ListĪ comma-separated drop-down list is the one under which you have defined list variables manually using a comma to separate them. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |