Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data Validation
Resolved · Low Priority · Version 2007
Reply Tue 13 Jan 2009, 16:58Delegate Ariyanna said...
Ariyanna has attended:
Excel Intermediate course
Excel Advanced course
Data Validation
What would be the maximum number of drop down options you could have in one cell?
For upcoming training course dates see: Pricing & availability
RE: Data Validation
Hello Ariyanna
Thank you for your question and welcome to the forum.
According to Microsoft, the maximum number of options that you can have in a drop-down list is 32,767 (see http://office.microsoft.com/en-us/help/HP100725991033.aspx)
Kind regards
Amanda
Wed 21 Jan 2009: Automatically marked as resolved.
|