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.

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Data Validation

Data Validation

RE: Data Validation

Excel articles

Excel tip:

Viewing two Excel 2010 Workbooks at the same time