Drop down list in Excel
 

I need a drop down to expedite the entry of info. However, I also need the
cell(s) formatted so as to take info not contained in the drop down. How can
I accomplish this?

Drop down list in Excel
 

Use Data Validation to set your list. On the error alert tab either uncheck
the Show error alert after invalid data is entered box or change the style to
warning or info.
--
If this helps, please remember to click yes.


"BillyBoy" wrote:

I need a drop down to expedite the entry of info. However, I also need the
cell(s) formatted so as to take info not contained in the drop down. How can
I accomplish this?

Drop down list in Excel
 

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

To allow manual entries, on the Error Alert tab, uncheck "Show error alert
after invalid data is entered".

--
Biff
Microsoft Excel MVP


"BillyBoy" wrote in message
...
I need a drop down to expedite the entry of info. However, I also need the
cell(s) formatted so as to take info not contained in the drop down. How
can
I accomplish this?