Solved

How to keep Home work Bar open in Excel

Posted on 2010-11-30
8
1,109 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
  • 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
Ingeborg Hawighorst 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
ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
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

Expert Comment

by:Ingeborg Hawighorst
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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

831 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