Solved

How to keep Home work Bar open in Excel

Posted on 2010-11-30
8
1,115 Views
Last Modified: 2012-05-10
how to keep the “Home Work--Bar” open at all times instead of closing when the cursor moves to another location.
0
Comment
Question by:ZepIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
8 Comments
 
LVL 7

Accepted Solution

by:
harryhelp earned 250 total points
ID: 34241362
Double-click Home at the top.
0
 
LVL 7

Expert Comment

by:harryhelp
ID: 34241369
If you double-click the home button at the top, it should stick.

Good luck !
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 250 total points
ID: 34242754
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 50
ID: 34242764
Note that the ribbon will not always show the Home tab, though, even if it is set to expanded.

cheers, teylyn
0
 
LVL 50
ID: 34412670
maybe split between http:/#34241362 and http:/#34242754
0
 
LVL 24

Expert Comment

by:broomee9
ID: 34459722
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

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question