odmopa.blogg.se

We might want to expand the menu and add ‘Maybe’ on the list. How to Edit Shorter Drop-Down List in ExcelĪnd now we can have a look at the other way – how to edit the shorter list containing only ‘Yes’ and ‘No’. The drop-down menu will display only the items present in the cells you included as the source. You can use these steps to edit the list in whatever way you need. The drop-down menu has been edited and there are only those three options that we wanted to show. The list is now made of the data contained in the cells A6 to A8.ĭouble-check whether everything is correct and confirm with OK. You can notice how the information in the section ‘Source’ changed, too. Now we’ll select only the months we need – the summer months June, July and August. If we want to edit the drop-down menu, we need to remove the information in the ‘Source’ box.

Our list is made of options saved in the cells range A1 to A12. In the pop-up window that appeared, go to the tab ‘Settings’ and click into the box ‘Source’.Įxcel will take you to the location of the source cells for this drop-down list. 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