East Bay Solutions

Make Home Tab in Excel Default Tab- Display Excel Ribbon Tabs

KB-750

Solution

Problem or Question:

How do I make the “Home” tab the default tab? When I’m working, the “File” tab is highlighted. When I want to format a cell, I click on the “Home” tab, make my changes, and when I exit the cell, it reverts back to the “File” tab.

Environment:

Office - Excel, Word, PowerPoint

Solution or Answer:

Your Excel ribbon is collapsed so it just appears as if the File tab is your default tab. Whether the ribbon is collapsed on expanded, the File tab will always appear in the same color. Below are pictures of what you will see when the Ribbon is collapsed and expanded.

 

collapsed_ribbon.png       expanded_ribbon.png


Double-click on any of the tabs to expand the Ribbon so that all tabs are in view all the time.

You can also accomplish this by using the Expand and Minimize button in the top right-hand corner of the window.

expand ribbon.png


Cause:

The Ribbon was minimized. When the Ribbon is minimized and you click on a Tab, the Ribbon will collapse again. The ribbon may have been collapsed in error when a ribbon tab was double-clicked.


This YouTube shows is a good demo of how it seems that the File tab is the default tab and how to display the ribbon by double-clicking on the tabhttp://www.youtube.com/watch?v=VXElBxJLtpg


Submitted by Jennifer Toor jennifer.toor@csueastbay.edu


Article Details

Last Updated
29th April 2013 03:41:03 pm

Submitted By
Jeniffer Toor

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (39 votes)

97% thumbs up 2% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Related Articles

No related articles were found.

Attachments

No attachments were found.
  • Print This Page
  • Bookmark and Share