Adding a new entry into a list - Excel 2007
Solved/Closed
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
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
Related:
- Adding a new entry into a list - Excel 2007
- Save as pdf office 2007 - Download - Other
- Counter strike 1.6 cheats list - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Liste déroulante excel anglais - Guide
- Amd crossfire gpu list - Guide
3 responses
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!
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!
neomsi
Posts
9
Registration date
Saturday October 18, 2008
Status
Member
Last seen
April 20, 2009
3
Jan 10, 2009 at 06:37 AM
Jan 10, 2009 at 06:37 AM
hi,
try this link to get full information about excel:
http://www.microsoft.com/learning/en/us/syllabi/50041AFinal.mspx
try this link to get full information about excel:
http://www.microsoft.com/learning/en/us/syllabi/50041AFinal.mspx
https://docs.microsoft.com/en-us/previous-versions/office/office-2010/cc179167(v=office.14)?redirectedfrom=MSDN#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.
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.
Apr 21, 2009 at 04:32 AM
I have been having the same issue and trawling the net but with little joy for a solution until now.
Many thanks
Apr 29, 2010 at 06:12 PM
Oct 25, 2010 at 11:23 PM
May 9, 2011 at 05:25 AM
Dec 7, 2012 at 06:38 PM