How to keep Home work Bar open in Excel

how to keep the “Home Work--Bar” open at all times instead of closing when the cursor moves to another location.
ZepITAsked:
Who is Participating?
 
harryhelpCommented:
Double-click Home at the top.
0
 
harryhelpCommented:
If you double-click the home button at the top, it should stick.

Good luck !
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

I'm not quite sure I understand your question completely, but I assume you are talking about the ribbon in Excel 2007 or later.

The ribbon can be expanded (always showing) or minimised (only showing when you click a tab). The double-click method harryhelp has mentioned is one way of toggling between expanded and minimised, and a very quick one at that.

Other ways are:

Hit Ctrl-F1

click the little arrow to the left of the Help icon (looks like a question mark) at the top right hand side of the window. See screenshots


ribbonup.png
ribbondown.png
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Note that the ribbon will not always show the Home tab, though, even if it is set to expanded.

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
maybe split between http:/#34241362 and http:/#34242754
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.