Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Drop-Down Menu Options
I have created a number of drop-down menu lists. I want to let users of the
spreadsheet know that there is a drop-down option there by displaying the "drop-down arrow" on the face of Excel, rather than only finding it when they move to that particular cell. How can I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Drop-Down Menu Options
Just colour the cells and let them know that.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AndyD4" wrote in message ... I have created a number of drop-down menu lists. I want to let users of the spreadsheet know that there is a drop-down option there by displaying the "drop-down arrow" on the face of Excel, rather than only finding it when they move to that particular cell. How can I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Drop-Down Menu Options
You've added a drop down using the Data Validation feature. If you want the
drop down to always be visible you should replace that with a combo box from the Forms toolbar. -- Jim "AndyD4" wrote in message ... |I have created a number of drop-down menu lists. I want to let users of the | spreadsheet know that there is a drop-down option there by displaying the | "drop-down arrow" on the face of Excel, rather than only finding it when they | move to that particular cell. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
Excel Options not displaying - some tabs only | Excel Discussion (Misc queries) | |||
how do i choose multiple options in a drop down menu in excel? | Excel Discussion (Misc queries) | |||
Drop-down menu options | Excel Discussion (Misc queries) | |||
How do I increase the font of my drop-down menu options? | Excel Worksheet Functions |