![]() ![]() In the section ‘Data Tools’, go to ‘Data Validation’. What we need to do is edit the list according to this.Ĭlick on the cell that contains the drop-down list you want to edit – it’s the cell with the list of months. Our items now include months that are irrelevant – the list of three summer months will do for this question. Let’s say we want to make changes to the first question and we want to use, for example, ‘Which is your favourite summer month?’ instead. So, here’s the longer one – the months of the year. How to Edit Longer Drop-Down List in Excel I’ll show the shorter one later on, and I’ll use the lists we created together in the previous tutorial. Here, I’ll use two different examples to show how editing a drop-down menu works, so you’ll know two ways how to do it. 2 How to Edit Shorter Drop-Down List in Excel ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |