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?
21 Answer
This worked for me.
- Go to Home tab and right click to show the toolbar options.
- Disable (uncheck) the minimize ribbon button.
