Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
prodrafter
 
Posts: n/a
Default drop-down lists


I am trying to search through a list that is 12 columns wide by 8912
rows. Each row must stay together.

The spreadsheet I have now has drop-downs on the top of the page, but
the drop-down lists do not include all the possible entries in each
column. It only contains approximately 1000 of the first alph-numeric
entries.

Is there a 1000 entry limit on drop-down lists?

How can I get the drop-downs to include all data in the column?

Thanks for any and all help on this.:)


--
prodrafter
------------------------------------------------------------------------
prodrafter's Profile: http://www.excelforum.com/member.php...o&userid=30287
View this thread: http://www.excelforum.com/showthread...hreadid=499557

 
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
Drop Down Lists geeksrgood Excel Worksheet Functions 0 December 5th 05 06:47 AM
unrestricting drop down lists Robert Excel Worksheet Functions 2 July 13th 05 02:40 AM
Data Validation - Drop down lists - if then? Steve R Excel Discussion (Misc queries) 2 April 8th 05 06:13 PM
multiple drop down lists jason n z Excel Discussion (Misc queries) 1 March 10th 05 01:24 AM
Can different drop down lists be displayed depending on the value. Laurentd Excel Discussion (Misc queries) 1 February 24th 05 12:31 AM


All times are GMT +1. The time now is 05:13 AM.

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

About Us

"It's about Microsoft Excel"