Home > Articles > Home & Office Computing > Microsoft Applications

Using the Excel 2013 Interface

This chapter introduces the Excel 2013 interface elements such as the ribbon, formula bar, and status bar.
This chapter is from the book

This chapter is from the book

The Excel interface has had a major makeover over the last decade. Excel 2007 introduced the ribbon and Quick Access Toolbar to replace the familiar command bar at the top of Excel. Excel 2010 brought the expanded File menu. Excel 2013 brings the Start menu, plus new Open and Save As panes. These were discussed in Chapter 1, “Staying Connected Using Excel 2013.” This chapter reviews all of the remaining Excel interface elements.

Using the Ribbon

The ribbon is composed of seven permanent tabs labeled Home, Insert, Page Layout, Formulas, Data, Review, and View. Other permanent tabs appear if you install certain add-ins. For example, PowerPivot, Inquire, and Easy-XL are tabs that you see if you install certain add-ins. Other contextual ribbon tabs appear when you select a certain type of object, such as a chart, image, or pivot table.

Each tab is broken into rectangular groups of related commands. The group shown in Figure 3.1 is the Clipboard group on the Home tab.

Figure 3.1

Figure 3.1. Detail of the Clipboard group of the Home tab of the ribbon.

The mantra of the ribbon is to use pictures and words. Many people have seen the little whisk broom icon in previous versions of Excel but never knew what it did. In Excel 2013, the same icon has the words “Format Painter” next to it. When you hover, the tooltip offers paragraphs explaining what the tool does. The tooltip also offers a little-known trick: You can double-click the Format Painter to copy the formatting to many places.

Using Fly-out Menus and Galleries

The ribbon fits more commands in a smaller space by using new types of controls that were not available with the Excel 2003 menu bar and toolbars.

In Figure 3.1, the Cut icon is a pure command. You click the icon and Excel cuts the selection onto the Clipboard. In contrast, the Paste and Copy icons are a new type of element comprised of a button and a drop-down. If you click the top half of Paste or the left side of Copy, you invoke the command. But if you click the arrow in either icon, you get a fly-out menu with more choices.

Fly-out menus allow many choices from a single icon. For example, the Conditional Formatting icon on the Home tab takes up a 76×76 pixel area on the ribbon. Clicking Conditional Formatting leads to five new fly-out menus and three commands. In all, the fly-out menus lead to a total of 64 distinct commands, all driven from a single 76×76-pixel icon (see Figure 3.2).

Figure 3.2

Figure 3.2. Fly-out menus offer dozens of choices from a single icon.

Another new element in the ribbon is the gallery control. Galleries are used when there are dozens of options from which to choose. The gallery shows you a visual thumbnail of each choice. A gallery starts out showing a row or two of choices in the ribbon. The right side of the gallery offers icons for up, down, and open. If you click up or down, you scroll one row at a time through the choices (see Figure 3.3).

Figure 3.3

Figure 3.3. Use the up and down arrows on the right side of the gallery to move one row at a time through the choices.

If you click the open control at the bottom-right side of the gallery, the gallery opens to reveal all choices at once (see Figure 3.4).

Figure 3.4

Figure 3.4. If you open the gallery control, you can see all of the choices at one time.

Rolling Through the Ribbon Tabs

With Excel as the active application, move the mouse anywhere over the ribbon and roll the scroll wheel on top of the mouse. Excel quickly flips from ribbon tab to ribbon tab. Scroll away from you to roll toward the Home tab on the left. Scroll toward you to move to the right.

Revealing More Commands Using Dialog Launchers, Task Panes, and “More” Commands

The ribbon holds perhaps 20% of the available commands. The set of commands and options available in the ribbon will be enough 80% of the time, but you will sometimes have to go beyond the commands in the ribbon. You can do this with dialog launchers, “More” commands, and the task pane.

A dialog launcher is a special symbol in the lower-right corner of many ribbon groups. Click the dialog launcher to open a related dialog with many more choices than those offered in the ribbon.

Figure 3.5 shows details of the Number group of the Home tab. In the lower-right corner is the dialog launcher. It looks like the top-left corner of a dialog, with an arrow pointing downward and to the right.

Figure 3.5

Figure 3.5. The dialog launcher takes you to additional options.

When you click the dialog launcher, you go to a dialog box that often offers many more choices than those available in the ribbon. In Figure 3.6, you see the Number tab of the Format Cells dialog.

Figure 3.6

Figure 3.6. After clicking the dialog launcher, you get access to far more choices.

Many menus in the ribbon end with an entry for “More blank...” or “Blank Options...”. You will see menu options for More Rules..., Effects Options..., and so on. Look for these menu items as the last entry in many menus. Clicking a More item takes you to a dialog or task pane with far more choices than those available in the ribbon.

Figure 3.7 shows the More Rules menu item, which leads to the New Formatting Rule dialog.

Figure 3.7

Figure 3.7. Choosing More Rules leads to a dialog with more choices.

Charts in Excel 2013 show a plus icon to the right of the selected chart. This icon leads to fly-out menus that eventually lead to a “More...” menu item (see Figure 3.8). When you select More... from a chart, you go to a redesigned task pane. Task panes were popular in Excel 2003. They were nearly banished in Excel 2007 due to the edict that all commands must be at the top. However, they are back with a vengeance in Excel 2013.

Figure 3.8

Figure 3.8. Choosing More... from the chart’s plus icon leads to a task pane.

Task panes typically appear on the right side of the Excel window, although you can undock them and have them float above the worksheet. After a task pane appears, it typically stays visible until you close it by clicking the X button. Figure 3.9 shows a task pane for formatting the chart title. If you click a data label in the chart, the task pane changes to show options for chart labels. If you click a picture, SmartArt, or WordArt, the task pane changes to show options for the newly selected object.

Figure 3.9

Figure 3.9. The Format dialog from Excel 2010 is now a task pane.

For charts, the task pane in Excel 2013 replaces the Format dialog from Excel 2010. It seems more confusing to use the task pane.

In Excel 2010, the Format dialog had a list of categories down the left side. These categories were arranged into groups with a horizontal separator between categories. For example, in Figure 3.10, the first group of categories is Fill, Border Color, and Border Styles. In a glance, you could see other categories such as Glow and Soft Edges, Properties, and Alt Text. I appreciated seeing a long list of words to choose from.

Figure 3.10

Figure 3.10. The Format dialog from Excel 2010 offered easy-to-understand words in the left navigation pane.

The Excel 2013 task pane offers a hierarchy of words, icons, and more words. In Figure 3.11, the equivalent task pane starts with two sets of words at the top: Chart Options and Text Options. It won’t be obvious in the figure, but Chart Options is shown in green and is the currently selected choice. When Chart Options is selected, you have three icons: a paint bucket, a pentagon with a reflection, and a square that someone appears to be measuring. Again, it is not obvious from the figure, but the paint bucket is in green and selected. When the paint bucket is selected, two word choices appear in the task pane: Fill and Border. Click the triangle next to either word to show all of the choices for that word. Figure 3.12 shows the Border category after expanding.

Figure 3.11

Figure 3.11. The task pane offers a three-level menu of words, icons, and then more words.

Figure 3.12

Figure 3.12. After choosing Chart Options, the paint bucket, and then Border, you get these options.

The task pane is confusing because you can’t see all of the categories at one time. You will find yourself trying to guess which Level 1 word to choose and then clicking through each of the Level 2 icons trying to find the Level 3 category you want.

Figure 3.13 shows the name of each Level 2 icon and the types of categories you might find there.

Figure 3.13

Figure 3.13. Icons you might find in various task panes.

Resizing Excel Changes the Ribbon

The ribbon appears different as the size of the Excel application window changes. You should be aware of this when you are coaching a co-worker over the phone. You might be looking at your screen and telling him to “look for the big Insert drop-down to the right of the orange word Calculation.” Although this makes perfect sense on your widescreen monitor, it might not make sense on his monitor. Figure 3.14 shows some detail of the Home tab on a widescreen monitor. The Cell Styles gallery shows 10 thumbnails, and Insert, Delete, and Format appear side-by-side.

Figure 3.14

Figure 3.14. On a widescreen monitor, you see 10 choices in the Cell Styles gallery.

Figure 3.15 shows the typical view on a laptop. The Cell Styles gallery is collapsed to a single drop-down. The Insert, Delete, and Format icons are now arranged vertically.

Figure 3.15

Figure 3.15. On a normal monitor, the cell styles gallery is collapsed.

As you resize the Excel screen, more items collapse. In Figure 3.16, the three icons for Insert, Delete, and Format are collapsed into a single drop-down called Cells.

Figure 3.16

Figure 3.16. At small sizes, icons collapse into drop-downs.

New in Excel 2013, you can even coax a new right-arrow icon to scroll the ribbon right (see Figure 3.17).

Figure 3.17

Figure 3.17. Click the right-arrow icon to scroll the ribbon to the right.

Eventually, the Excel ribbon gets too small, and Excel hides the ribbon completely (see Figure 3.18).

Figure 3.18

Figure 3.18. When the Excel windows gets too narrow, the ribbon is hidden.

Activating the Developer Tab

If you regularly record or write macros, you might be looking for the VBA tools in the ribbon. They are all located on the Developer tab, which is hidden by default. However, it is easy to make the Developer tab visible. Follow these steps:

  1. Right-click the ribbon and choose Customize the Ribbon. Excel displays the Customize Ribbon category of the Excel Options dialog.
  2. A long list box of ribbon tabs is shown on the right side of the screen. Every one of them is checked except for Developer. Check the box next to Developer.
  3. Click OK. The Developer tab displays.

Activating Contextual Ribbon Tabs

The ribbon tabs you see all the time are called the main tabs. Another 18 tabs come and go, depending on what is selected in Excel.

For example, Excel offers a whole series of commands for dealing with photographs that you insert into your worksheet. However, 90% of people never bother to dress up their worksheets with clipart or pictures, so there’s really no reason to show all the commands for working with photographs on the ribbon. However, after you insert a picture and the picture is selected, the Picture Tools, Format tab appears in the ribbon (see Figure 3.19).

Figure 3.19

Figure 3.19. Anywhere from one to three contextual ribbon tabs display when you activate certain objects.

The 18 contextual tabs are identified in Figure 3.20.

Figure 3.20

Figure 3.20. This table shows which tabs appear and when.

Here is the frustrating thing: As soon as you click outside of the object (that is, the picture), it is no longer selected and the Picture Tools Format tab disappears.

If you need to format an object and you cannot find the icons for formatting it, try clicking the object to see if the contextual tabs appear.

Two other tabs occasionally appear, although Excel classifies them as main tabs instead of contextual tabs. If you add the Print Preview Full Screen icon to the interface, you arrive at a Print Preview tab. Also, from the Picture Tools Design tab, you can click Remove Background to end up at the Background Removal tab.

Finding Lost Commands on the Ribbon

Often, the command you need is front and center on the Home tab and everything is fine. However, there are times when you simply cannot find an obscure command that you know used to be in Excel 2003. Here is my strategy for finding those commands:

  1. Right-click the ribbon and select Customize Quick Access Toolbar. Excel displays the Quick Access Toolbar category of the Excel Options dialog.
  2. Open the top-left drop-down and change Popular Commands to All Commands. You now have an alphabetical list of over 2,000 commands.
  3. Scroll through this alphabetical list until you find the command you are trying to locate in the ribbon.
  4. Hover over the command in the left list box. A tooltip appears, showing you where you can find the command. In Figure 3.21, the Justify command is located on the Home tab, in the Editing group, under the Fill drop-down.
Figure 3.21

Figure 3.21. This tooltip shows you where to find a command.

Microsoft offers a free interactive ribbon guide that can help you locate an Excel 2003 menu command on the ribbon. Type Interactive Ribbon Guide in any search engine to find the latest incarnation of the ribbon guide. I’ve seen the guide and tried it out once, but given that the tooltips are built into the Customize Quick Access Toolbar panel of Excel Options, it seems pointless to go out to the Web when you can find the answer quickly using the steps just outlined.

Shrinking the Ribbon

The ribbon does take up four vertical rows of space. This won’t be an issue on a big monitor, but it could be an issue on a tiny netbook.

Starting in Excel 2013, to shrink the ribbon, you can right-click the ribbon and choose Collapse the Ribbon. The ribbon collapses to show only the ribbon tabs. When you click a tab, the ribbon temporarily expands. To close the ribbon, choose a command or press Esc.

To permanently bring the ribbon back to full size, right-click a ribbon tab and uncheck Collapse the Ribbon.

Note that you can also minimize the ribbon using the carat (^) icon at the bottom right of the expanded ribbon. To expand the ribbon, click any tab and then click the pushpin icon in the lower-right corner of the ribbon.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020