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.