Hi
Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I use this list on another sheet in Excel to select a colour. Now I need to add another colour to the list so that the data capturer can have more colours to select from. How do I do this? When we used Excel 2003 it was easy. No I do not see (or I'm simply not understanding the new commands in 2007) how to add more data to a list. If I simply add the new colour at the bottom of the list, it does not form part of the list. Can someone please assist as this is urgent. Thanks. Talana
Configuration: Windows XP Firefox 3.0.5
Hi,
|
OK Talana, I've just figured out the answer. Go to the "Formulas" ribbon, then click "Name Manager" in the "Defined Names" section (about mid-screen). This will bring up a list of all defined names - including lists - and you can edit their names, range of cells, etc. Hopefully this still helps you, even though you posted your message about 4 months ago!
|
Add color to if statement in excel 2007 Add strings to one cell excel 2007 Adding a drop down in excel 2007 which will get data from other sheet Change date format in excel 2007 Excel 2007 merge 3 cells into one date column Excel 2007 percentage formula add percent to a value Excel 2007 vba macro to add buttons Excel vba add new row to other sheet How to add double quotation into excel cells (easy) How to create a new folder in ms excel 2007? How to put criteria for dates between two rows in excel 2007 with example How to turn off window recovery excel in excel 2007 Macro excel 2007 copy rows into a new worksheet Ms excel 2007 add variables to userform Ms excel 2007 drop down list choose calculation Opening .xls files and saving with excel 2007 does not save in new format Outlook add new email account cannot log into server Select from list excel 2007