Most valuable professional
  • Excel Book Excerpt

Excel Go Wide

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Go Wide

Problem: My ribbon looks different than my co-workers.

Strategy: Invest in a wide-screen monitor. The Office 2010 experience dramatically improves at a 1440x900 resolution.

When you reduce the size of the Excel window, Excel automatically starts consolidating ribbon options into smaller icons and then groups. The next four figures show details of the Home tab of the ribbon at different sizes.

 

LE100010.tif 

Figure 19 At 1920 wide, five columns of the gallery are shown

LE100012.tif 

Figure 20 At a smaller screen, the cell styles gallery is a dropdown.

LE100013.tif 

Figure 21 Eventually, the entire Styles group becomes a dropdown..

LE100014.tif 

Figure 22 If the Excel window is too small, the Ribbon disappears.

If you are the go-to person for solving Excel problems and you are helping a co-worker over the phone without using GoToMeeting, there will be some frustration as you tell them to look for the Bad, Good, Neutral tiles and they can only see a Styles dropdown.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: