Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modifying a validating list
I am creating a spreadsheet for data collection and using validating
lists. I'd like to do two things to reduce keystrokes..... 1 - have the list appear when the cell is picked, instead of having to pick the cell, then the down arrow. 2 - modify the length of the list box so that all values are shown without the scrollbar. The length would vary for the various columns but if there is a global setting that would be ok too. I realize these properties can be modified in combo boxes and list boxes, and have considered using them, but is there an easy way to copy these down 150 rows for all the records in the sheet, much like you can drag a cell down to copy formulas to all other cells? Thanks in advance. Zax |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
Editing a list of data | Excel Discussion (Misc queries) | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |