Data Validation

Resolved · Low Priority · Version 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:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Data Validation

Data Validation

RE: Data Validation

Excel articles

Excel tip:

Display pictures on Chart Data Point