Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-195547%22%20slang%3D%22en-US%22%3ELarge%20space%20suddenly%20appeared%20between%20formula%20bar%20%26amp%3B%20A1%20-%20HELP!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195547%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20know%20what%20happened%20or%20how%20to%20fix%20this.%20Suddenly%20I%20have%20a%20large%20space%20between%20the%20formula%20bar%20and%20the%20beginning%20of%20my%20spreadsheet%20(A1)%20and%20I%20can%20only%20read%20about%203%20lines%20of%20information.%20Not%20only%20did%20this%20happen%20on%20the%20spreadsheet%20I%20was%20working%20on%20but%20it%20spread%20to%20ALL%20of%20my%20workbooks%2C%20including%20when%20I%20I%20tried%20to%20open%20a%20brand%20new%20one.%20It's%20like%20Excel%20itself%20went%20crazy.%20What%20happened%20%26amp%3B%20how%20can%20I%20fix%20this%3F%3C%2FP%3E%3CP%3ESherri%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-195547%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-522999%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Large%20space%20suddenly%20appeared%20between%20formula%20bar%20%26amp%3Bamp%3B%20A1%20-%20HELP!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-522999%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI've%20had%20a%20similar%20problem%20and%20it%20had%20randomly%20appeared%20one%20day%20when%20I%20accessed%20Microsoft%20Excel%20for%20Office%20365.%20When%20I%20open%20up%20a%20new%20workbook%2C%20the%20formula%20bar%20has%20increased%20in%20height%20and%20I%20am%20unable%20to%20collapse%20by%20dragging%20it%20up%20or%20even%20using%20the%20CTRL%20shift%20U%20method.%20In%20addition%20to%20this%2C%20the%20height%20of%20every%20cell%20has%20increased%20to%2083.7%20for%20the%20no%20apparent%20reason.%20I%20have%20been%20unable%20to%20find%20a%20fix%20to%20this%20and%20it%20is%20extremely%20inconvenient%20to%20use.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F150030%22%20target%3D%22_blank%22%3E%40Sanjay%20Gandhi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197137%22%20slang%3D%22en-US%22%3ERE%3A%20Large%20space%20suddenly%20appeared%20between%20formula%20bar%20%26amp%3Bamp%3B%20A1%20-%20HELP!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197137%22%20slang%3D%22en-US%22%3EHello%20Sherri%2C%20Appears%20like%20you%20have%20accidentally%20expanded%20the%20formula%20bar.%20Please%20try%20Ctrl%2BShift%2BU%20to%20collapse%20the%20formula%20bar.%20If%20this%20works%20fine%2C%20then%20expand%20formula%20bar%20again%2C%20right%20above%20columns%20(C%2CD%2CE...)%20you%20will%20see%20the%20border%20of%20expanded%20formula%20bar.%20Try%20place%20the%20pointer%20at%20the%20border%20to%20resize%20to%20small%20size%2C%20and%20then%20collapse%20again.%20Hope%20this%20helps.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524432%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Large%20space%20suddenly%20appeared%20between%20formula%20bar%20%26amp%3Bamp%3B%20A1%20-%20HELP!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524432%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332626%22%20target%3D%22_blank%22%3E%40Mike_G15%3C%2FA%3E%26nbsp%3B%2C%20I%20guess%20that's%20since%20you%20have%26nbsp%3BCambria%20Math%20as%20default%20font%20when%20creating%20new%20workbook.%20Change%20in%20File-%26gt%3BOptions-%26gt%3BGeneral%20on%20something%20less%20specific%20-%20Calibri%20or%20Arial%2C%20whatever%3C%2FP%3E%3C%2FLINGO-BODY%3E
Sherri Lawry
Occasional Visitor

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 only did this happen on the spreadsheet I was working on but it spread to ALL of my workbooks, including when I I tried to open a brand new one. It's like Excel itself went crazy. What happened & how can I fix this?

Sherri

 

3 Replies
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.

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 

@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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies