Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
permenent appearance of the drop down arrow when adding validation toa cell
hi all,
i'm building a spreadsheet for the user and i need to make all the drop-down arrows to be shows so the user will know exacly where he can pick his choice, is it posible to have this option becaouse for now the only way to show that there is an arrow is by placing the cursor on the cell,any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
permenent appearance of the drop down arrow when addingvalidation to a cell
cannot think of anything else than colouring those cells...
or otherwise marking them... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
permenent appearance of the drop down arrow when adding validation
You could use comboboxes instead of data validation dropdowns. The arrows
will remain visible. Debra Dalgleish's site has help on this: http://www.contextures.on.ca/xlDataVal11.html Hope this helps, Hutch "thread" wrote: hi all, i'm building a spreadsheet for the user and i need to make all the drop-down arrows to be shows so the user will know exacly where he can pick his choice, is it posible to have this option becaouse for now the only way to show that there is an arrow is by placing the cursor on the cell,any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation drop-down arrow not showing for SOME users - fine with others? | Excel Worksheet Functions | |||
in-cell drop-down arrow missing | Excel Discussion (Misc queries) | |||
Data Validation - Drop-down list - make arrow visible at all times | Excel Discussion (Misc queries) | |||
How do I change the appearance of an in-cell drop-down list? | Excel Discussion (Misc queries) | |||
How do I change the appearance of my drop down lists? | Excel Worksheet Functions |