The image size limit has been raised to 1mb! Anything larger than that should be linked to. This is a HARD limit, please do not abuse it.
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

Excel Help: Data Entry Dropbox Too Small

TefTef Registered User regular
edited January 2011 in Help / Advice Forum
I'm currently creating a matrix for use in monitoring the training progress of our staff. I have set up some data validation across the relevant cells which in and of itself works fine; the only problem that I have is that the dropdown box that appears contains text that is very hard to read when the sheet is zoomed out.

I'm aware that there's a way to place a combo box (I guess on top of?) the data validation drop box but for the life of me I can't work out how to do it in excel 07. I've found details on how to do it on earlier versions of excel but I'm not clever enough to work it out on excel 07

I'll include a screenshot just in case it helps:

tl;dr I need help making the text bigger in my data entry drop down boxes in excel 2007

Tef on


  • Blake TBlake T Registered User regular
    edited January 2011
    If you go to developer ribbon click properties, then click design mode then click on the drop down now you should be able to edit all of the properties associated with it.

    Blake T on
Sign In or Register to comment.