Excel: How to make the Home tab "stay put"

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?

RJo

Posted 2018-03-19T23:50:18.017

Reputation: 401

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 – 2018-03-21T18:58:04.977

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 – 2018-03-21T19:01:58.070

1Thank you RJo! Having to constantly switch from File to Home was driving me nuts! – RobertF – 2019-08-15T19:06:15.467

So glad to be able to spare others MS Office pain whenever possible. – RJo – 2019-08-16T23:59:44.647

Typical microsoft office, everything is hidden. – john – 2019-12-11T15:57:43.927

Excel: How to make the Home tab "stay put"

Answers