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
Sanjay Gandhi's avatar
Sanjay Gandhi
Copper Contributor
May 24, 2018
Hello Sherri, Appears like you have accidentally expanded the formula bar. Please try Ctrl+Shift+U to collapse the formula bar. If this works fine, then expand formula bar again, right above columns (C,D,E...) you will see the border of expanded formula bar. Try place the pointer at the border to resize to small size, and then collapse again. Hope this helps.
  • 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
      Diamond Contributor
      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 

Resources