drop down box

  • Thread starter Thread starter jms54
  • Start date Start date
J

jms54

I have a problem with a drop down box. I am using excel 2007. I create the
dropdown box using the data validation method. It works fine, but when i
open the dropdown box and click the down arrow, the first cell that is shown
is just after all of my data and it is blank. I can scroll up to see
choiices, but i would like to start at the first one. Thanks
 
It sounds like you have an empty cell in the source for the drop down list.
Readjust the source range to exclude that empty cell.
 

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

How to delete a drop down box in Excel 2007 1
Data Validation Error 1
How do i show the drop down arrow for a list in Excel 1
Select drop down menu option using libre-calc macro 0
Automatic Drop-down of Dropdown list 3
empty cells in the drop down list 7
How do I Make a drop-down box longer 2
Data Validation 5

Back
Top