Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't modify List after converting to 2007
I had an Excel 2003 file that contains a drop down list for a user to pick
values from a range elsewhere in the workbook. I recently upgraded to Excel 2007. The file is still in 2003 format but I can no longer modify the properties of this control. I need to add some values, but I can't seem to get into the properties of the control so that I can modify the range for the pick-list. It is possible that I just don't know how to do it in 2007 so any help would be appreciated. Thanks. (Note: Right clicking on the drop down does not reveal any options that would allow me to modify the control and there does not appear to be anything in the Developer section of the Ribbon that will help me.) -Dom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't modify List after converting to 2007
Click on Data in the menu across the top. Then find Data Validation in the
ribbon about in the center of the ribbon. Click that, then click on Data Validation. A dialog box will appear that looks just like the one in 2003. HTH Otto "Domenick" wrote in message ... I had an Excel 2003 file that contains a drop down list for a user to pick values from a range elsewhere in the workbook. I recently upgraded to Excel 2007. The file is still in 2003 format but I can no longer modify the properties of this control. I need to add some values, but I can't seem to get into the properties of the control so that I can modify the range for the pick-list. It is possible that I just don't know how to do it in 2007 so any help would be appreciated. Thanks. (Note: Right clicking on the drop down does not reveal any options that would allow me to modify the control and there does not appear to be anything in the Developer section of the Ribbon that will help me.) -Dom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't modify field Author in excel 2007 | Excel Discussion (Misc queries) | |||
How do I modify a database in Excel 2007? | Excel Worksheet Functions | |||
Modify Keyboard Shortcuts? Excel 2007 | Excel Discussion (Misc queries) | |||
Trying to modify a list | Excel Discussion (Misc queries) | |||
modify drop down list | Excel Discussion (Misc queries) |