Solved

Excel 2013 large formulae bar

Posted on 2013-12-02
18
494 Views
Last Modified: 2013-12-02
Hi all,

The formulae bar at the top of excel is very big and I cannot find a way to reduce it.
If I open excel in safe mode it is okay.
I have manually disabled all add-ons and done a repair but it is still the same.  Is there a way to reset Excel settings back to default?

Thank you
0
Comment
Question by:afflik1923
  • 5
  • 4
  • 4
  • +2
18 Comments
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39689612
See the image:
Click here to shrink itHTH,
Dan
0
 

Author Comment

by:afflik1923
ID: 39689617
Unfortunately it is not that simple.  Please see screenshot of the bar.

Excel 2013
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39689638
OK, it's probably a font problem.
Look for Book.xlt and Sheet.xlt in C:\Users\<user name>\AppData\Roaming\Microsoft\Excel\XLSTART

Backup, then delete them. Start Excel and see if the problem persists.
0
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 500 total points
ID: 39689648
Also, check the font for formulas. It should be no larger than 12pt.
It's in Options->General. See picture:
Font for formulas
0
 
LVL 4

Expert Comment

by:andrew_man
ID: 39689681
Please move the cursor to the bottom of the formula bar, hold down the mouse left button.  Then, you can adjust it.

Thanks!
0
 

Author Comment

by:afflik1923
ID: 39689689
I have gone to

C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART but the folder is empty
0
 
LVL 4

Expert Comment

by:andrew_man
ID: 39689694
Please move the cursor to the bottom of the formula bar, hold down the mouse left button.  Then, you can adjust it or just press CRTL+Shift+U.

Andrew Man from Hong Kong
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 39689699
Looking at the screen print, it isn't the formula bar that is at fault.

It appears to be the same size as the ribbon bar above it.

Also, the RangeName "window" and Function button at the left hand end are also larger than normal.

When I stretch my formula bar down, the two items mentioned above stay small.

Also the column headers are taller than they should be.

Has someone managed to create a custom toolbar showing the RangeName, Function buttons??? Or a Custom View??

Go to the View tab on the Ribbon and check to see that Formula Bar is checked, you should be able to see whether there are any Custom Views from this tab as well.

Thanks
Rob H
0
 
LVL 4

Expert Comment

by:andrew_man
ID: 39689715
Hi Rob H,

The client asked for the formula bar, the formula bar can be manual adjusted.  Thus, it can be  very large.

Andrew Man from Hong Kong
0
Being driven mad by email signature updates?

Having to make a change to your users’ email signatures, yet again? Feel like your head is going to explode? Rely on an Exclaimer email signature management solution to make the process simple!

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39689754
@andrew_man,

Please look at the supplied picture and read what Rob wrote. The formula bar has not been extended to multiple rows, which is what your suggestion addresses - it is only one row but very large.

Regards,
Rory
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 39689759
Hi Andrew Man,

I realise the client has pointed out the issue with the formula bar which I know is adjustable but the client seems unable to reduce it from the large size it is currently set at.

I have also pointed out that the items normally to the left of the formula bar are also stretched which seems odd as that does not normally occur, or at least it doesn't on my machine with Excel 2010 installed; I assume it is possible that a change introduced in Excel 2013 means those items also change height. Likewise the column headers appear to be larger than required for the font displayed within them.

Unfortunately, I do not have a solution for the question but thought that pointing out these other issues may help others solve the problem.

There are also other things which I have spotted that may assist. Is this being used in a local copy of Excel 2013 or is it a Web based or remote server Application.

Thanks
Rob H
0
 
LVL 4

Expert Comment

by:andrew_man
ID: 39689767
So just press CRTL+shift+U

Please move the cursor to the bottom of the formula bar, hold down the mouse left button.  Then, you can adjust it or just press CRTL+Shift+U.

Andrew Man from Hong Kong
0
 

Author Comment

by:afflik1923
ID: 39689807
There are no custom views.  Formula bar is ticked.  It is a local install of excel.  Although this is an iMac that is running windows 7 via bootcamp.  

Andrew - I have tried dragging the bar and CTRL-shift-U and it did not resolve the issue.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39689811
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 39689840
Hi Rory,

I just tried changing my default font to 48 and it replicated the issue, the formula bar and items to the left of it were stretched.

It also affected the columnn and row headers but differently to the issue displayed above.

Thanks
Rob H
0
 

Author Comment

by:afflik1923
ID: 39689876
Yes it is set to a number below 12. see the screenshot below.

However I thought I would change the font as well as I have never heard of 'Cambria Math' before.

Set it to 'Calibri' and that resolved the issue.
2013-12-02-1411.png
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39689879
OK, so it WAS a font problem.
These tend to be tricky to solve...
0
 

Author Closing Comment

by:afflik1923
ID: 39689888
Was a font issue as suspected by Dan
0

Featured Post

The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
time format showing wrong 12 49
macro for same location path 2 19
Formula or Macro to determine variance 17 75
Access Excel export not behaving 2 23
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now