Forum Discussion
Sherri Lawry
May 20, 2018Copper Contributor
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 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
- crapscrusherCopper Contributor
Sherri Lawry I have a row of small green squares forming a line above my Formula bar. and 3 more green squares over just left of the small "x" you click on to close the window.
Anyone know what causes this and how to cure it?
- Lootah_Marble_106Copper Contributor
Select restore to previous versions by right-clicking the Excel file icon. Sherri Lawry
- Sophie_N1210Copper Contributor
Sherri Lawry I had this problem and I wasn't finding the right answers on line so I started playing around. I tried clicking on Display Settings at the bottom right and chose "Optimize for compatibility" instead of "Optimize for best appearance". I had to shut down Excel and when I reopened the workbook the white space was gone.
- emememOccasional Reader
Thanks Sophie & Sherry - I had the same issue and this worked for me
- Tony_32Copper Contributor
Sherri Lawry I had this same problem. It showed up on only 1 page of a workbook. I went to View-Workbook Views- and I changed the setting to normal. Somehow the setting had changed to Custom? I hope this helps.
T
- JohnC1963Copper Contributor
I have just had the same issue and found that since our company has started using the Private/Official notification bar, this blank space appeared. I found that just closing this bar by clicking in it, which brings up the Private/Official/Confidential bar, frees up this space again and the spreadsheet is back to normal
- heyloitsmerajCopper ContributorHi 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
- Suzanne_Johnson0504Copper ContributorThank you!
- JoanMaryKCopper Contributor
heyloitsmeraj THANK YOU! this worked!
- Sanjay GandhiCopper ContributorHello 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_G15Copper Contributor
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.
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