Options
Excel 2010 Drop Down List Help
Master Ozzy
Posts: 18,938
Forum Member
✭✭
I ahve an absolutely huge spreadsheet of data at work. I have previously been using Excel 2003 at work. On this particular spreadsheet I had the data filtered so that I could just click the little arrow at the top of each column and it would display all of the data in drop down lists. However, I've just been upgraded to Excel 2010 at work and when I now click the little arrows, all of the data is displayed but you have to 'de-select' or 'select all' to get the data you want. Is there no way to just have it the same way I sued to like in Excel 2003? I can't use Data Validation as the particular spreadhseet is updated multiple times a day with information and so it would mean em cosntantly having to change the Data Validation settings/options etc.
0
Comments
See I much prefer it the old way in Excel 2003, but it seems there's no option to have it that way in Excel 2010.
I don't understand the problem either, but I'm fairly sure that anything in Excel 2003 is achievable in 2010 - the interface is just different.