How many entries can be put into a drop down list in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a drop down list in excel. I am not able to go any farther
than 15 cells with one or two word choices. Can someone tell me how many
entries I can make?
 
I am creating a drop down list in excel. I am not able to go any farther
than 15 cells with one or two word choices. Can someone tell me how many
entries I can make?
Click to expand...


By experiment, my version of Excel 2002 allows 32767 entries in a drop
down list.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Excel Excel: How do I put a formula in a drop down list 11
Drop Down Lists 1
drop down list 3
Creating a drop down list with a multitude of entries selected 1
How do I create a drop down box within a drop down box? 1
Drop Down Lists 2007 10
How to add entry in the list for drop down in excel? 1

Back
Top