Drop Down Starting Position

  • Thread starter Thread starter veggies27
  • Start date Start date
V

veggies27

I have a drop down list in a data validated cell with blank items at the
bottom of the list (to allow for addition user-entered choices). Is there any
way, when you click on the drop down arrow, for the menu to start at the top
instead of the bottom? Did I do something wrong?

Thanks,
Jeff
 
Get rid of the blank cells and just turn off the error alert if you want to
be able to enter what's not in the list.

The user-entered choices do get get added to the list in any case unless you
use VBA code.


Gord Dibben MS Excel MVP
 

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 Drop Down Lists 9
Excel 2007 / right-click / pick from drop down list 1
Remove blank cells from data validation drop down box 3
Drop down fill box does not appear when cell clicked. 1
Starting drop down lists at the top 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Drop Down List 2

Back
Top