The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

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:
PAH_A.png

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

help a fellow forumer meet their mental health care needs because USA healthcare sucks!

Ever tried. Ever failed. No matter. Try again. Fail again. Fail better

bit.ly/2XQM1ke
Tef on

Posts

  • Blake TBlake T Do you have enemies then? Good. That means you’ve stood up for something, sometime in your life.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.