|Subject:||Re: Dropdown Selection|
|Posted by:||Chip Pearson (ch…@cpearson.com)|
|Date:||Sat, 25 Oct 2003|
I suspect you are referring to Data Validation, using the Allow List
setting. Enter the list of acceptable data in some range of cells. Then,
select the cell which you want to have the drop down. Then, go to the Data
menu, choose Validation, and choose List in the Allow listbox. Then enter
the range reference in the source box.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Tony Scott" <ton…@gtsystemsuk.co.uk> wrote in message
> I have seen a "Dropdown" selection facility in an Excel Spreadsheet. How
> this done?
> Many Thanks
> Tony Scott
Dropdown Selection posted by Tony Scott on Sat, 25 Oct 2003