How to view entire drop down list in Excel 2007 (Win 7)

**Sugartit** · 02-14-2011, 05:44 PM

I'm working on a spreadsheet made by someone else. When I click on a cell on my PC, I get a drop down menu with 8 choices and up/down arrows which allow me to scroll to see other drop down choices.

When I open the same document on a MAC, the entire drop down list opens up so I can easily choose from the entire list. This is MUCH easier for me.

How am I able to view the entire drop down list on my PC?

**DonkeyOte** · 02-15-2011, 04:09 AM

I don't have a Mac to test but on Windows a DV drop down will only ever display 8 items - implication being it's a Mac specific feature.

Re: show all items (on Windows) - VBA required: http://www.contextures.com/xldataval08.html#Font

@martincrow, FYI, Data Validation is not new to XL2007

**Sugartit** · 02-15-2011, 12:36 PM

Thanks for the responses. This link confirms what DonkeyOte stated: "The font size in a data validation list can't be changed, nor can its default list length, which has a maximum of eight rows."

http://www.contextures.com/xldataval08.html#Font

OK, but is there a reason why, when opened on a MAC, the entire list is displayed? I guess just a MAC vs PC feature. In this case, it might be worth it to me to work on this on a MAC if I can't get it work on a PC.

**DonkeyOte** · 02-16-2011, 03:38 AM

As I said - given I don't have a Mac I can't verify.

As for working exclusively with Mac, obviously that's an option but bear in mind lack of VBA support in XL2008 (exists in XL2004 / XL2011) - this may or may not be relevant to you.