Re: Dropdown Selection

Giganews Newsgroups
Subject: Re: Dropdown Selection
Posted by:  Chip Pearson (ch…@cpearson.com)
Date: Sat, 25 Oct 2003

Tony,

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.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com    ch…@cpearson.com

"Tony Scott" <ton…@gtsystemsuk.co.uk> wrote in message
news:bne17u$vr6$…@newsg3.svr.pol.co.uk...
> I have seen a "Dropdown" selection facility in an Excel Spreadsheet. How
is
> this done?
>
> Many Thanks
>
> Tony Scott

Replies

None

In response to

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