Drop Down List Formatting II

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

Guest

I couldn't find the answer to this one on Contextures.com.

2 of the 5 drop down lists on my spreadsheet default to the bottom of the
list. The others default to the top. All the source lists are in the the
same format and named in the same way.

How can I make all the cells default-select the top item within the drop
down list?
 
Hi!

Are there any empty cells in any of the sources?

When the drop arrow is clicked and there is already a selection in the cell,
the drop list will automatcally "scroll" to that selection.

Biff
 
I feel pretty dumb, but I don't understand about having empty cells. For
instance when I set up the source list it is a blank list with the heading
"employees" in 'b4' and these names are added at a later date. I have blank
cells from 'b5' to 'b124'. How do i set up the range to default to the top
and if names are added it will pick all names with default to top? Thank you
for the help.
 
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

Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
Drop Down Starting Position 2
data validation drop down list format 1
Drop Down lists and condtional formating 2
Drop Down Lists 2007 10
Multiple Dependent Drop Down 1

Back
Top