New Drop-Down Functionality in 2007?

[GregO]

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

 

[Otto Moehrbach]

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

 

[Roger Govier]

Hi Greg

You need to create a Table.
Insert tab>Table>Click my table has headers>OK
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

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