Forum Discussion

Sherri Lawry's avatar
Sherri Lawry
Copper Contributor
May 20, 2018

Large space suddenly appeared between formula bar & A1 - HELP!?

I don't know what happened or how to fix this. Suddenly I have a large space between the formula bar and the beginning of my spreadsheet (A1) and I can only read about 3 lines of information. Not onl...
excel
Mike_G15's avatar
Mike_G15
Copper Contributor
May 03, 2019

Hello,

I've had a similar problem and it had randomly appeared one day when I accessed Microsoft Excel for Office 365. When I open up a new workbook, the formula bar has increased in height and I am unable to collapse by dragging it up or even using the CTRL shift U method. In addition to this, the height of every cell has increased to 83.7 for the no apparent reason. I have been unable to find a fix to this and it is extremely inconvenient to use. 

Sanjay Gandhi 

SergeiBaklan's avatar
SergeiBaklan
MVP
May 03, 2019

Mike_G15 , I guess that's since you have Cambria Math as default font when creating new workbook. Change in File->Options->General on something less specific - Calibri or Arial, whatever

  • JEresearch2375's avatar
    JEresearch2375
    Copper Contributor
    Apr 15, 2021

    I Have the same problem, the control **bleep** U thing does not work. Only easy but not the best way is to uncheck the formula bar in the view tab.  SergeiBaklan 

    • mlmhenry's avatar
      mlmhenry
      Copper Contributor
      Feb 05, 2022
      I did this, then I saw and deleted the restricted workbook ribbon. Deleting this ribbon fixed the problem. I then recheck the formula bar to return to normal.
      • Mariagatz's avatar
        Mariagatz
        Copper Contributor
        Nov 20, 2023
        Finally a solution that holds. Thank you!

Resources