If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
New Drop-Down Functionality in 2007?
I've noticed when working in 2007 that I can reference field names as
[field1], which show up as a drop-down menu. As soon as I type =[, a menu pops up with a listing of all the field names. To the left of the field names in the menu is a yellow/gold box that shows (...) It's great functionality but I can't seem to figure out how to create it in a new columns created manually. I first noticed it when I exported a list from SharePoint to Excel - these references were created automatically. Can anyone fill me in on what this is at least called so that I may research it? I searched the discussion groups and Excel Help but haven't found anything. Thanks |
#2
|
|||
|
|||
New Drop-Down Functionality in 2007?
Greg
You have always had the ability to use range names as list identifiers. Type a list somewhere. Name it something, say, MyList. Then when you setup the Data Validation cell, select List, and in the source box type "=MyList" without the quotes. Done. HTH Otto "GregO" wrote in message ... I've noticed when working in 2007 that I can reference field names as [field1], which show up as a drop-down menu. As soon as I type =[, a menu pops up with a listing of all the field names. To the left of the field names in the menu is a yellow/gold box that shows (...) It's great functionality but I can't seem to figure out how to create it in a new columns created manually. I first noticed it when I exported a list from SharePoint to Excel - these references were created automatically. Can anyone fill me in on what this is at least called so that I may research it? I searched the discussion groups and Excel Help but haven't found anything. Thanks |
#3
|
|||
|
|||
New Drop-Down Functionality in 2007?
Hi Greg
You need to create a Table. Insert tabTableClick my table has headersOK You will notice that a new Design tab appears and in the Properties section you can give the Table a name rather than default Table1 if required. There is also an option on the Design tab in the Tools section to Convert to Range which will remove all of the table functions. -- Regards Roger Govier "GregO" wrote in message ... I've noticed when working in 2007 that I can reference field names as [field1], which show up as a drop-down menu. As soon as I type =[, a menu pops up with a listing of all the field names. To the left of the field names in the menu is a yellow/gold box that shows (...) It's great functionality but I can't seem to figure out how to create it in a new columns created manually. I first noticed it when I exported a list from SharePoint to Excel - these references were created automatically. Can anyone fill me in on what this is at least called so that I may research it? I searched the discussion groups and Excel Help but haven't found anything. Thanks __________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Thread Tools | |
Display Modes | |
|
|