Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I show the arrow for dropdown menu in excel?
If you don't "click" on the cell, you would not know it has a dropdown list.
I want this to be visible without clicking on the cell. Also, my dropdown list when clicking on it, shows on the outside (right side) which is outside the cell. I noticed that Microsoft, in their dropdown list, it shows and is inside the cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I show the arrow for dropdown menu in excel?
You can't, for Data validation (DV) dropdowns. But you could easily
format/color the cell to make it distinctive. Or insert a comment on the DV cell (and show the comment). One alternative - you could try using a combo box from the Forms toolbar, and draw it sized to fit to grid -- hold down Alt key when you draw/resize -- so that it looks like it's inside the cell. The dropdown will be visible. It does take more work to get it up though, compared to DVs. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "dorinc29" wrote: If you don't "click" on the cell, you would not know it has a dropdown list. I want this to be visible without clicking on the cell. Also, my dropdown list when clicking on it, shows on the outside (right side) which is outside the cell. I noticed that Microsoft, in their dropdown list, it shows and is inside the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't click on dropdown menu in excel, but others can. Help! | Excel Discussion (Misc queries) | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
In Excel how do I set up the list from the Data dropdown menu? | Excel Discussion (Misc queries) | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
Show last files used in File dropdown menu | New Users to Excel |