Adding a new entry into a list - Excel 2007 [Solved/Closed]

talana - Jan 10, 2009 at 12:11 AM - Latest reply:  confused
- Jan 18, 2013 at 03:44 AM
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
See more 

12 replies

Best answer
25
Thank you
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!

For the life of me, I can't imagine WHO thought these changes were a good idea. It's completely different from any previous version of Excel. People who use productivity software DO NOT want to completely RELEARN the software when there is an updated version. Please Microsoft, make SMALL CHANGES with each new version!! This is INSANE!

Thank you, Slausage 25

Something to say? Add comment

CCM has helped 1705 users this month

Slausage = Legend
Thank you! Never would have figured this out on my own - took me one full hour just to update three lists because I couldn't figure it out! Now I know for next time.
Hey Slausage,
that really helped. Thank you so much.
life saver
neomsi 9 Posts Saturday October 18, 2008Registration date April 20, 2009 Last seen - Jan 10, 2009 at 06:37 AM
2
Thank you
hi,
try this link to get full information about excel:
http://www.microsoft.com/learning/en/us/syllabi/50041AFinal.mspx
Thanks Neomsi

I'm fairly comfortable with Excel and it is only this specific issue that I have a problem with - do you know how to do this?

T
Slausage > talana - Apr 15, 2009 at 12:37 PM
I'm having the same problem and it's driving me freakin BONKERS. I can't believe how absurdly STUPID Excel 2007 can be!! Why would they make it so difficult to EDIT A FREAKIN LIST!!! Do people at Microsoft never have the need to append new things to a list? This is giving me such a headache...
0
Thank you
http://technet.microsoft.com/en-us/library/cc179167.aspx#whatschanged16

Tables: Insert row
Description: The List feature in Office Excel 2003 had a special row at the bottom to add new records to the list. This special row is removed in Office Excel 2007. Instead, you can add data to a table by using the ENTER and TAB keys when the active selection is in the last data row of the table. You can also drag the resize handle at the bottom-right corner of the table to add more rows.