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%3CLINGO-SUB%20id%3D%22lingo-sub-2274626%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-2274626%22%20slang%3D%22en-US%22%3E%3CP%3EI%20Have%20the%20same%20problem%2C%20the%20control%20**bleep**%20U%20thing%20does%20not%20work.%20Only%20easy%20but%20not%20the%20best%20way%20is%20to%20uncheck%20the%20formula%20bar%20in%20the%20view%20tab.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2345960%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-2345960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048616%22%20target%3D%22_blank%22%3E%40Anonomous_300%3C%2FA%3E%26nbsp%3B%20Thanks%2C%20that%20worked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20a%20monitor%20issue%3F%20How%20lame.%20Microsoft%2C%20please%20fix.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2350553%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-2350553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1051156%22%20target%3D%22_blank%22%3E%40dmsnopek%3C%2FA%3EHi%2C%20I%20am%20having%20the%20same%20issue%20but%20cannot%20find%20the%20setting%20to%20remove%20the%20whit%20space%20-%20can%20you%20let%20me%20know%20the%20steps%20to%20find%20it%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2296317%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-2296317%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22asgk009_0-1619506944992.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275728i9874CAD8C8EDA635%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22asgk009_0-1619506944992.png%22%20alt%3D%22asgk009_0-1619506944992.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ETry%20that%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1027313%22%20target%3D%22_blank%22%3E%40JEresearch2375%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F148700%22%20target%3D%22_blank%22%3E%40Sherri%20Lawry%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337844%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-2337844%22%20slang%3D%22en-US%22%3E%3CP%3ERan%20into%20this%20problem%20when%20using%20a%20monitor.%26nbsp%3B%3C%2FP%3E%3CP%3Estep%201%20bring%20the%20fil%20back%20to%20you%20PC%26nbsp%3B%20or%20laptop%20and%20fill%20the%20screen%3C%2FP%3E%3CP%3EStep%202%20in%20office%20360%20there%20is%20a%20use%20option%20for%20internal%2Fexternal.%26nbsp%3B%20go%20to%20the%20right%20and%20click%20on%20the%20x.%20this%20should%20collape%20that%20space%20entirely.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Anonomous_300_0-1620483451092.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279298i0D9CBEBF7BBF9823%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Anonomous_300_0-1620483451092.png%22%20alt%3D%22Anonomous_300_0-1620483451092.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2350799%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-2350799%22%20slang%3D%22en-US%22%3EThank%20you!%20Dragging%20the%20window%20from%20my%20monitor%20to%20my%20laptop%20and%20then%20back%20to%20my%20monitor%20worked%20for%20me.%20The%20other%20workaround%20I%20found%20was%20to%20close%20all%20Excel%20files%2C%20open%20a%20New%20Excel%20file%2C%20then%20open%20the%20file%20that%20had%20the%20issue.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2367284%22%20slang%3D%22en-US%22%3ERe%3A%20Large%20space%20suddenly%20appeared%20between%20formula%20bar%20%26amp%3B%20A1%20-%20HELP!%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367284%22%20slang%3D%22en-US%22%3EHi%20Everyone%2C%20i%20had%20the%20same%20issue.%20just%20found%20out.%20go%20to%20sensitivity%20under%20home%20in%20excel.%20click%20on%20the%20drop%20down%20and%20remove%20the%20tick%20mark%20from%20show%20bar%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2462303%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-2462303%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20this%20worked!%20I%20do%20use%20monitors%20attached%20to%20a%20lap%20top%20and%20it%20seems%20this%20issue%20only%20occurs%20when%20I%20open%20Excel%20on%20the%20extended%20screen.%20On%20the%20origin%20screen%20I%20can%20see%20and%20close%20the%20internal%2F%20external%20dialogue.%20It%20does%20not%20appear%20on%20the%20extended%20screen.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048616%22%20target%3D%22_blank%22%3E%40Anonomous_300%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2536580%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-2536580%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048616%22%20target%3D%22_blank%22%3E%40Anonomous_300%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EI%20love%20you%20so%20much%20right%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2799640%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-2799640%22%20slang%3D%22en-US%22%3EThank%20you!!!%20This%20is%20the%20answer.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2884547%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-2884547%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1171399%22%20target%3D%22_blank%22%3E%40JDekk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20unable%20to%20find%20the%20use%20options%2C%20able%20to%20guide%20me%20on%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

 

14 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

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.  @Sergei Baklan 

Ran into this problem when using a monitor. 

step 1 bring the fil back to you PC  or laptop and fill the screen

Step 2 in office 360 there is a use option for internal/external.  go to the right and click on the x. this should collape that space entirely.

Anonomous_300_0-1620483451092.png

 

@Anonomous_300  Thanks, that worked.

 

It's a monitor issue? How lame. Microsoft, please fix.

@dmsnopekHi, I am having the same issue but cannot find the setting to remove the whit space - can you let me know the steps to find it please?

 

Thanks 

Thank you! Dragging the window from my monitor to my laptop and then back to my monitor worked for me. The other workaround I found was to close all Excel files, open a New Excel file, then open the file that had the issue.
Hi Everyone, i had the same issue. just found out. go to sensitivity under home in excel. click on the drop down and remove the tick mark from show bar

Thank you this worked! I do use monitors attached to a lap top and it seems this issue only occurs when I open Excel on the extended screen. On the origin screen I can see and close the internal/ external dialogue. It does not appear on the extended screen. @Anonomous_300 

Thank you!!! This is the answer.

@JDekk 

 

I am unable to find the use options, able to guide me on this?