Drop Down - Repost

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robert morris - 15 Nov 2007 17:13 GMT

I have Excel 2007 - I have created a drop down list in column "I" the drop
down boxes are in column C - Although my list (col I) is sorted A - Z my
drop down box opens with the list showing Z - A. I want it to open with A -
Z. What am I missing? I have searched "help" with no results.

Bob M.

Reply to this Message

Jim Rech - 15 Nov 2007 18:01 GMT

When you don't get a response to a post consider clarifying it. With
precise "steps to reproduce" ideally. Start with what kind of drop down you
have. There are at least 3 kinds in Excel.

Signature

Jim

|I have Excel 2007 - I have created a drop down list in column "I" the drop
| down boxes are in column C - Although my list (col I) is sorted A - Z my
| drop down box opens with the list showing Z - A. I want it to open with A -
| Z. What am I missing? I have searched "help" with no results.
|
| Bob M.

Reply to this Message

robert morris - 15 Nov 2007 18:20 GMT

Jim,

Thanks for the info. I have a column where I have entered a drop down list
(column C) through Data Validation from another (Master) list. This "master"
list will have names entered occassion which I sort A to Z. All works well
except when I open the drop down box in Column C to choose a name, the list
of names in the box opens at the bottom of the list. As few names start with
x,y,z, I have to scroll the box to the top. First name Andrews (sample)

Is this a little clearer?

Bob M.

> When you don't get a response to a post consider clarifying it. With
> precise "steps to reproduce" ideally. Start with what kind of drop down you
[quoted text clipped - 7 lines]
> |
> | Bob M.

Reply to this Message

Jim Rech - 16 Nov 2007 14:53 GMT

Sorry to be so slow getting back. I still don't see the problem but you
didn't really give me the precise steps to repro. Let me give you my steps
and you can tell me what I did wrong.

-Filled a-z in the range F1:F26
-In C1 created a Data Validation, List referencing F1:F26.
-Clicked the drop down arrow in C1 selected first item "A".
-"A" appeared in C1.
-Clicked arrow again and current item "A" was selected.
-Selected "Y" from list and "Y" appeared in C1.
-Clicked arrow again and the current selection "Y" was selected in drop
down.

All that seems as it should be so let me know what your scenario is.

Signature

Jim

| Jim,
|
[quoted text clipped - 20 lines]
| > |
| > | Bob M.

Reply to this Message

robert morris - 16 Nov 2007 17:04 GMT

Jim,

Thanks so much!

I have marked each step of your analysis as Yes (correct) or explained my
question.

> Sorry to be so slow getting back. I still don't see the problem but you
> didn't really give me the precise steps to repro. Let me give you my steps
> and you can tell me what I did wrong.
>
> -Filled a-z in the range F1:F26

Yes

> -In C1 created a Data Validation, List referencing F1:F26.

Yes

> -Clicked the drop down arrow in C1 selected first item "A".

No, when I click on the button in a blank cell in C1 it opens with the last
entry in Column F "Z" instead of the first name in the Column F list "A". I
therefore must scroll up to get to "A" in the list. Column F is sorted A to
Z. The drop down box only displays eight (8) names.

> -"A" appeared in C1.

> -Clicked arrow again and current item "A" was selected.
> -Selected "Y" from list and "Y" appeared in C1.
> -Clicked arrow again and the current selection "Y" was selected in drop
> down.
>
> All that seems as it should be so let me know what your scenario is.

Other than what I have described, it works perfectly. It is just an extra
step to have to "scroll" back to the top. My list in Column F is forty (40)
names so "A" does not appear in the box.
I really appreciate your time on this.

Bob M.

> | Jim,
> |
[quoted text clipped - 31 lines]
> | > |
> | > | Bob M.

Reply to this Message