Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List Formatting II
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? -- Ian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List Formatting II
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 "Ian3103" wrote in message ... 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? -- Ian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List Formatting II
Spot on Biff! It was driving me mad. Many thanks.
-- Ian "Biff" wrote: 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 "Ian3103" wrote in message ... 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? -- Ian |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List Formatting II
You're welcome.
Biff "Ian3103" wrote in message ... Spot on Biff! It was driving me mad. Many thanks. -- Ian "Biff" wrote: 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 "Ian3103" wrote in message ... 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? -- Ian |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List Formatting II
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. "Ian3103" wrote: 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? -- Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Drop Down List | Excel Worksheet Functions |