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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
harryhelpConnect With a Mentor Commented:
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)Connect With a Mentor 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
All Courses

From novice to tech pro — start learning today.