This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I created a drop-down list and am using it in a spreadsheet, but now need to add a couple more options to the list. I cannot find the way to do that. I'm using Office Excel 2007.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
1. Click on the cell that contains the drop-down list
2. On the Office ribbon Select Data > Data Validation > Data Validation
3. Use the ‘Settings’ tab to modify the range
For additional information on how to create a drop-down list from a range of cells, visit the following link:
Great, so I have to do that 365 times? Fantastic.
Do you have the same workbook created for everyday of the year? Why didn't you just link every workbook (worksheet) to the one worksheet with the Data Validation on it? Bit late to give you that bit of advice I suppose.
All the best.
Oh, yeah, I created it and it works. It's on a separate sheet from the data sheet. I just need to add a few more options to the list.
When I click in the box on the left of the data bar I see 3 list names, two of which I would like to get rid of, and the third I want to edit. I just can't figure out how, it won't let me just expand the highlight box around the new entries and save it that way. So obviously I am missing some bit of knowledge that the help menu isn't helping me with.
I thought I had it figured out, but all I did was screw up other formatting. I changed the definition for the list from the name to the cell range. Then I copied/down from the top cell to the bottom cell, 165 rows/cells. That changed all 365 to the same color and outline as the first. Which I didn't want to do. And, placed a drop down list in the subtotal rows that are placed every 8th row of the sheet, which I also didn't want to do. My sheet is a full year, 365 rows, with a subtotal row after every week. On all the days rows I want the drop down list, and not in the subtotals rows. Should be a simple way to do this.
Sure that you created the drop down list? Is it in the same sheet or a different sheet?