Re: Dropdown Selection

Giganews Newsgroups
Subject: Re: Dropdown Selection
Posted by:  Chip Pearson (ch…
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.

Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC    ch…

"Tony Scott" <ton…> wrote in message
> I have seen a "Dropdown" selection facility in an Excel Spreadsheet. How
> this done?
> Many Thanks
> Tony Scott



In response to

Dropdown Selection posted by Tony Scott on Sat, 25 Oct 2003