AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Create a drop down menu in excel 20162/12/2023 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
0 Comments
Read More
Leave a Reply. |