3

This is a new problem (have not experienced it before; am running Excel 2010).

The workbook opens with the File tab active. So I switch to the Home tab to do some editing. The problem is that after just one edit (such as changing the color of a cell), the File tab becomes the active tab again. So to continue with editing, I have to switch back to the Home tab.

I thought maybe there was Display setting that needed to be checked in (or out), but as best I can tell, there's no option controlling active/inactive tabs.

How do I make the Home tab stay active with having to repeatedly switch back to it?

Improve this question
2
  • Yes, I was hasty in typing. I've edited my original post. Based on tangential research I've done, the problem is not necessarily unique to 2010, and can also happen with other Office products such as Outlook..
    – RJo
    Commented Mar 21, 2018 at 18:58
  • that's fine. Even in the case a question applies to multiple versions, it's best to indicate the version you have. Good answers will indicate what versions they apply to if possible.
    – I say Reinstate Monica
    Commented Mar 21, 2018 at 19:01

2 Answers 2

Reset to default
4

This worked for me.

  1. Go to Home tab and right click to show the toolbar options.
  2. Disable (uncheck) the minimize ribbon button.
Improve this answer
3
  • 1
    Thank you RJo! Having to constantly switch from File to Home was driving me nuts!
    – RobertF
    Commented Aug 15, 2019 at 19:06
  • So glad to be able to spare others MS Office pain whenever possible.
    – RJo
    Commented Aug 16, 2019 at 23:59
  • Typical microsoft office, everything is hidden.
    – john
    Commented Dec 11, 2019 at 15:57
0

Go to Home tab and right click to show the toolbar options. already enable minimize ribbon button. Just click one time minimize ribbon button. problem fixed

Improve this answer
2

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .