We help IT Professionals succeed at work.

Why is Excel 2013 Hiding Header Bar?

307 Views
Last Modified: 2014-08-29
I have just upgraded my computer to Office 2013.  Whenever I go open an Excel 2013 document, I find that the header bar (the bar with A - whatever) is being hidden by the formula bar.  I've tried hiding the formula bar but then the worksheet itself just seems to move upwards so that the header bar is then hidden by the tabs at the top.  I've also tried using the zoom function thinking maybe it was that but it is not.  The only other option I could think of was that the workbook was in "maximized" mode but I can't find the button to minimize the internal window.  

On top of that, I have discovered that when I open a new Excel 2013 document, the header bar appear.  However if I switch into an Excel document that does not have the header bar, then the newly created document will also suddenly hide the header bar as well.  This is driving me bonkers!

I'm attaching a screenshot of the problem.  Does anyone know what is going on, and how I can fix it?  I did not have this problem with Excel 2010.        screenshot of problem
Comment
Watch Question

Andrew VelascoOperational Account Management & Data Analyst

Commented:
Hi,

Try this in the offending workbook: File > Options > Advanced.  Under the "Display" Header, make sure "Show Formula Bar" is checked.

Edit: Sorry - I just realized that's not what you are talking about. - you are talking about the column headers.  I apologize.  I will look into this.

Commented:
You can also try double clicking on any of the ribbon names (eg: Home) and see if that helps.
Andrew VelascoOperational Account Management & Data Analyst

Commented:
Ok, lets try this:
Same section (File > Options > Advanced).  Under the "Display options for this worksheet:", is "Show row and column headers" checked?
Glenn RayExcel VBA Developer
CERTIFIED EXPERT
Top Expert 2014

Commented:
^ I thought that also, but in his screen shot the row headers are visible.
Glenn RayExcel VBA Developer
CERTIFIED EXPERT
Top Expert 2014

Commented:
I noticed that you have the KUTOOLS addin.  Have you checked the View Group section, especially the "Show/Hide" options to make sure you aren't hiding the header row with that?

Reference:  
http://www.extendoffice.com/product/kutools-for-excel.html#view


-Glenn
hogefentonDirector of IT

Author

Commented:
@Andrew - Yes, that box is checked to show all column and row headers.

@Glenn - All options within KUTOOLS are to show the appropriate column headers.  

I wish I knew how to make a video of what happens when the worksheet seems to move itself upwards.  It's like it doesn't recognize that the formula bar or the ribbon should be sitting on top of the column headers.
Andrew VelascoOperational Account Management & Data Analyst

Commented:
To verify Glenn's theory, can you disable KUTOOLS and restart Excel?
Glenn RayExcel VBA Developer
CERTIFIED EXPERT
Top Expert 2014

Commented:
I can replicate this appearance in Excel 2010 using VBA:
Excel 2010 - normal window repositioned
This is actually a "normal" - not "maximized" window that is re-positioned to this state.  When the macro runs, the worksheet appears to move into this position, like you described above.

You stated that this is happening for "an Excel 2013 document."  Is this a specific document?  Any chance it is macro-enabled?

BTW, the code to replicate this was:
Sub Mess_It_Up()
    ActiveWindow.WindowState = xlNormal
    With ActiveWindow
        .Top = -36
        .Left = -6
    End With
End Sub

Open in new window


-Glenn
hogefentonDirector of IT

Author

Commented:
@Glenn - That is exactly how my document looks.  It is also happening to any new Excel document that I start from File > New.  It looks fine for a few seconds and then it reverts to the old way.  The old documents may be macro-enabled, however no macros should be running on the workbook.  When I click the File > New I do not believe that is labelled as a macro-enabled workbook.  (I hope I'm not mixing up terms here)
Excel VBA Developer
CERTIFIED EXPERT
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
hogefentonDirector of IT

Author

Commented:
@Glenn - the view change did not work.  Tried that originally.  

In the end I got fed up and just reinstalled Excel 2013.  That did the trick.  Just annoying that I had to do so.  Such a weird problem!  

Thank you all for all of your direction and help.
hogefentonDirector of IT

Author

Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for hogefenton's comment #a40279077
Assisted answer: 400 points for Glenn Ray's comment #a40275047

for the following reason:

Reason is that I did the action before another person could suggest it.  However I also allowed for the fact that Expert Glenn did suggest it, which is why he also got credit for the solution.
Glenn RayExcel VBA Developer
CERTIFIED EXPERT
Top Expert 2014

Commented:
Hi,
In order to receive any credit - partial as my suggestion may have been - you need to actually click the "Accept this solution" link above my previous post where I provided a solution.  You can then grade and assign points as appropriate.  

Sorry that a re-install was necessary, but I did suspect that may have been needed.  It's possible a registry setting placed the default window position in "negative" positions as I demonstrated with my macro example.

Regards,
-Glenn

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.