Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Settings of Data Validation
Hi,
I have couple of questions regarding how to use 'Data Validation' in Excel. 1. when use a list to show the data source for a cell in an Excel file, the maximum items that showing from the list when user clicks on it is 8 items, is that possible to expand it to show more? for example, when user clicks on the arrow, the 26 periods can be showed. 2. instead of showing from the first one from the source range, is that possible to choose which one to show on the top? thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003. Data/Validation/Settings - Allow/List: sizing list? | Excel Discussion (Misc queries) | |||
Conditional End Date in Data Validation Settings | Excel Worksheet Functions | |||
Printing Validation Settings | Excel Discussion (Misc queries) | |||
'Fill-in ignores Data Validation settings! | Excel Discussion (Misc queries) | |||
DATA/VALIDATION/SETTINGS | Excel Worksheet Functions |