Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation

Data Validation

ResolvedVersion 2007

Tue 13 Jan 2009, 16:58 Delegate 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?

Wed 14 Jan 2009, 11:34 Trainer Amanda said...

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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy