| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Drop Down Lists
Hoepfully this will be Uber qwick. I have created myself a drop down list of possible options to enter into a cell. There are in total 24 options; default has see it so you can see only the first 8 and then scroll down for to se the others. Can you change this value of 8? Also If you can change that can you change the size of text that appears in the drop down list? And if you can do that, can you use logo pictures instead of text? Super., Thanks. -- samprince ------------------------------------------------------------------------ samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168 View this thread: http://www.excelforum.com/showthread...hreadid=563652 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Drop Down Lists
right click, setup controls, change to more than 8 lines
hth regards from Brazil Marcelo "samprince" escreveu: Hoepfully this will be Uber qwick. I have created myself a drop down list of possible options to enter into a cell. There are in total 24 options; default has see it so you can see only the first 8 and then scroll down for to se the others. Can you change this value of 8? Also If you can change that can you change the size of text that appears in the drop down list? And if you can do that, can you use logo pictures instead of text? Super., Thanks. -- samprince ------------------------------------------------------------------------ samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168 View this thread: http://www.excelforum.com/showthread...hreadid=563652 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Drop Down Lists
If you created the drop-down list using DataValidationList, the 8 lines and
the text size is default and cannot be changed. Workarounds provided by Debra Dalgleish at http://www.contextures.on.ca/xlDataVal08.html#Font Gord Dibben MS Excel MVP On Fri, 21 Jul 2006 07:29:00 -0400, samprince wrote: Hoepfully this will be Uber qwick. I have created myself a drop down list of possible options to enter into a cell. There are in total 24 options; default has see it so you can see only the first 8 and then scroll down for to se the others. Can you change this value of 8? Also If you can change that can you change the size of text that appears in the drop down list? And if you can do that, can you use logo pictures instead of text? Super., Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting custom views from drop down box | Excel Discussion (Misc queries) | |||
| Adding sub-menus and actions to data in drop down lists in Excel 2 | Excel Worksheet Functions | |||
| How do I have hierarchial drop down lists in Excel | Excel Worksheet Functions | |||
| Drop Down Lists - Not allowing other contents to be put in same ce | Excel Worksheet Functions | |||
| How do I change the appearance of my drop down lists? | Excel Worksheet Functions | |||
Linear Mode
