LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jin Jin is offline
external usenet poster
 
Posts: 3
Default Max number of drop-down list elements in excel

Is there a max number of elements allowed in drop-down list in Excel? I was
using the data validation and entering the list in the "source" box (using ,
as delimiter), after I entered 34 elements, excel does not allow me to enter
more element to the drop down list.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
list of unique elements Helena Excel Worksheet Functions 3 February 13th 08 06:41 PM
Finding duplicated elements in a list M.A.A.C Excel Discussion (Misc queries) 2 November 23rd 06 12:13 PM
How to format two repeating XML elements w/o getting list of list jimmyray32 Excel Discussion (Misc queries) 0 November 10th 05 03:17 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
How to do matrix operation with complex number elements in Excel WILSON CHIRAMAL Excel Worksheet Functions 1 August 15th 05 02:26 PM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"