Results 1 to 12 of 12
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    HUGE Formula Bar - not shrinkable (2007 SP1, etc)

    Edited by HansV to shrink 1600x1000 pixel image. Don't post images large than 640x480 PLEASE!

    All of a sudden the Excel formula bar tripled in vertical size (see attachment). The formula bar is vertically resizeable - larger but not smaller.

    Anyone have any ideas how to get my regular-size formula bar back?

    Thanks,
    Attached Images Attached Images
    • File Type: jpg x.jpg (18.5 KB, 3 views)
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, etc)

    Does Resize the formula or name box in the formula bar help - in particular clicking the chevron at the end of the formula bar?

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, e

    I apologize for uploading such a huge image.

    Yes, I can INCREASE the vertical size of the formula bar. When i hover the cursor over the divider between the column headings and the formula bar, the cursor changes to a double-ended arrow and I can increase the size but not decrease it. Clicking on the chevron at the right also increases the size. Attached is an image of how the formula bar chages when I click on the chevron.

    Regards,
    Attached Images Attached Images
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, e

    I hope that someone who has Excel 2007 (I don't) will have a useful suggestion.

  5. #5
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, etc)

    I found that if I click the chevron on the right hand side the formula bar increases 3 lines.
    Clicking again on the chevron reduces it back to one line - A sort of toggle on toggle off application
    HTH
    Paul Coyle
    Approach love and cooking with reckless abandon

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, etc)

    Somehow, Al's name box and presumably formula bar are using a much larger font than the column headings. I think that's the cause of the tall formula bar, but I don't know how to change this.

  7. #7
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, etc)

    I have tried using the mouse to drag the size up and down, that worked OK
    This may be silly, have you checked if there is information in the bar, but the font colour is white so it is not displayed?
    If you tun on edit in cells does anything show?
    (Need a symbol for grasping at straws :-)
    Paul Coyle
    Approach love and cooking with reckless abandon

  8. #8
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, etc)

    TRy excel options, Popular, "when creating new workbook" set text tsize to say 10 pt.I reset mine to 72 pt, re-started Excel, then could not re-size the formula bar as I could before. HTH
    Paul Coyle
    Approach love and cooking with reckless abandon

  9. #9
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, e

    SOLVED ...

    Thanks for suggestions that pointed me to the solution. I performed a Web search for "excel formula bar font size". One result stated this - "The default font selected under Tools, Options, General controls the formula bar font". In Excel 2007, here's how you find and can change the default font size:
    1. <LI>Click the Microsoft Office Button , and then click Excel Options.
      <LI>In the Popular category, under When creating new workbooks, do the following:
      1. <LI>In the Use this font box, click the font that you want to use.
        <LI>In the Font Size box, enter the font size that you want to use
    When I did this, I discovered that the "default" font size was set to 28 points! Interesting since the standard cell font size is 10 - as you can see from the previous images I posted.

    As soon as I changed the "default" font size to 10 and restarted Excel, the formula bar shrunk to "normal size". This seems to me to be very strange behavior.

    Okay, so I decided to pursue this one a little further. I changed the "default" font to Impact with a size of 28 and restarted Excel. Low and behold the formula bar/cell contents are displayed in Impact font/28 but the cells on the worksheet are in Verdana/10 (see attachment). Here's the reason for the cell font not changing from Verdana/10, I think. After I installed Excel 2007, I created a worksheet template with the font face and size (Verdana/10) that I wanted when I started Excel. Since I'm using Vista (or is Vista using me? <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>), I stored the template in C:Usersuser nameAppDataLocalMicrosoftExcelXLStart. Now it seems that when I start Excel, the worksheet cells use Verdana/10 but the "default" font only affects the formula bar ... for at least as far as I have (and probably will) investigate.

    Thanks again for the posts that helped me research and solve the problem.

    Regards,
    Attached Images Attached Images
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, e

    You'll find that if you remove your template file from xlstart Excel WILL use the default font again.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, e

    Jan,

    Thanks. After my research, this behavior I would have expected although the logic escapes me.

    Are there other areas of Excel that the default font affects other than new workbooks and the formula bar?

    Regards,
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HUGE Formula Bar - not shrinkable (2007 SP1, e

    Yes, newly inserted worksheets and the characters on the row and column headers.
    Not sure if that's all though.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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