Results 1 to 3 of 3
  1. #1

    Excel drop down box

    How do you increase the font size in a dropdown box. And how do you not let the box show on a printing but yet still show content?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Dublin, Ireland, Republic of
    Thanked 0 Times in 0 Posts

    Re: Excel drop down box

    It very much depends on what type of dropdown box, one from the Control Toolbox or one from the Forms toolbar. If it is from the Control Toolbox you can right click on it and select properties (you need to be in design mode to do this). You should then have a list of properties you can edit. The two you are interested in are Font and Print. Click on the font property and a font selection box will open where you can set the font they way you like. Click on the Print property and select False.

    If you are using a dropdown from the Form toolbar, then you cannot select a different font (unless somebody else knows different) but you can disable printing. Right click on the dropdown and select Format Control. Then select the properties tab and remove the tick mark beside print object.

    Andrew C

  3. #3
    4 Star Lounger
    Join Date
    Mar 2001
    Bismarck, ND, USA
    Thanked 0 Times in 0 Posts

    Re: Excel drop down box

    If you use Data/Validation and set "Allow" to "List", you can use a list you have entered somewhere. This creates a drop down in a cell (or selected cells) that won't print. It doesn't change the font size, though.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts