Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > The Ribbon Is Large and in Charge in Excel 2013

The Ribbon Is Large and in Charge in Excel 2013

The Excel menu has been slowly transitioning over the years from the grid with drop-down menus towards the “ribbon.” In the latest version of Excel, the ribbon transition is complete, and users are now left with this smoother, seamless menu option.

The ribbon is that rectangular bit at the top of Excel, with command options that are displayed all the time. At the top where the menu used to be are now tabs. These tabs allow selection of various menu tools.

With the ribbon in full effect, Excel is able to deploy even more access in a limited amount of space.

Watch the free video here, transcripts for the entire video follow:


Facebook Linkedin Twitter

Learn how to master Microsoft Excel 2013. Get 19 hours of Microsoft Excel 2013 training – click here.

Video transcripts:

Welcome back to our course on Excel 2013.  If you’ve used Office 2007 products or Office 2010 products, you’ll be familiar with the Ribbon and the Quick Access Toolbar.  For the different constituent programs within Office, the migration from the old Menu system to the Ribbon based system has preceded at a sort of variable pace.  Some of them have completed the transition before the others.  But by the time we get to 2013, it’s pretty much complete.  And in Windows 8, the Ribbon is starting to make an appearance.  If you’re using Windows 8, you will have seen the program that was called Windows Explorer that’s now called File Explorer has a Ribbon interface as well.  So, pretty much the Ribbon is here to stay.  Not everybody likes it.  Some people still prefer the old Menu system.  But I think more people like it now than did originally and one of the good things about the Ribbon Interface is it is pretty highly customizable and if you do particularly repetitive work or if you focus on just a few commands within a product like Excel, so you don’t need the vast array of different options that are available, then the ability to customize the Interface can really pay off.  So if you’ve not used the Ribbon before or you’re a little bit cagey about using it and you think, well, I’d really prefer the old Menu system.  Give the Ribbon a chance because I think that if you use it for a while it will grow on you.

The Ribbon is this sort of rectangle here and part of the Ribbon, or just above it if you like, you have these words like View, Review, Data, Formulas, and so on.  Now these correspond to tabs and at any one time with the Ribbon, you have a selected tab.  Now omit the word File from this, that file white on a green background.  That’s the access to Backstage View, which we’ve used already.  We’re talking about the word Home onwards and at the moment you see that Home has got this sort of three-quarters of a rectangle round it.  The Home tab is selected.  If I click on the word Insert, the Insert tab will be selected.  Page Layout and so on.  So they are the tabs of the Ribbon and at any time in Excel which tabs you can see will vary.  Now the tabs you see now will be there pretty much all of the time.  It’s more that you get additional tabs sometimes.  And you’ll see some of those later on in the course.

 

Microsoft Excel 2013 training by Simon Sez IT

 

The Home tab, as the name implies, that’s the one which we sort of regard as Home.  And when the Home tab is selected you can see a number of groups.  Now the groups have names and the groups are the words at the bottom.  So that’s the Clipboard Group.  That’s the Font Group.  And a group, the groups are separated by these vertical faint dividing lines.  So there’s a Clipboard Group, then there’s a dividing line, then there’s the Font Group, then another line, Alignment Group, another one, Number, and so on.  So on each of the tabs there are a number of groups and as you will see each tab has different groups.

Now within a group there are individual commands.  So for instance, on the Insert tab, in the Tables Group, Pivot Table Command, a recommended Pivot Tables Command, and a Table Command.  Now note as I hover over those, I’m getting those screen tips that we talked about earlier.  They’ll tell you a little bit about what each of those commands does.  Many of the commands on many of the tabs we’re going to be covering on the course; so I’m not too worried at the moment about exactly a command does.  I just want to show you the principle that you’ve got tabs, within tabs you’ve got groups, within groups you’ve got commands.

Now the next thing I want to point out about the Ribbon is that the commands are in effect context sensitive.  And at the moment, you should be able to see that really all of the commands on this Ribbon, all of the commands in all of the groups on the Insert tab are grayed out.  You couldn’t actually execute any of them at the moment and the reason is that we don’t have a workbook open.  Let’s go to the Home tab.  On the Home tab, same thing, everything is grayed out.  So let’s open that first Sample Workbook, the one that we looked at earlier on. Once that’s open then virtually every command is now enabled.  One or two aren’t.  There’s one on the left, Paste, that’s grayed out.  You couldn’t paste something.  But virtually everything else is.  Go to the Insert tab, most of that.  You notice how the commands take on their color, they get bolder; they get sharper.  You can see them.  As you hover over them, they highlight, you get the screen tips.  You could use those commands once you’ve got a workbook open.  So the ability to use a command is largely dependent on whether that command can be used in a specific situation.  Now that doesn’t only depend on whether you have a workbook open.  It can depend on other things as well.  And we’ll come back to that aspect of using the Ribbon as well a little bit later on.

So, we have the Ribbon.  We have tabs on the Ribbon.  Within the tabs we have command groups and within the groups we have commands.  The commands themselves vary.  They all do different things, but they also have different natures.  Some of them, let’s take the Table Command here for example; if I click on Table what I get is a little dialog inviting me to create a table.  We’ll look at that later on, but that’s a pretty straightforward command.  If on the other hand I go to this one, Pivot Chart, which is in the Charts Group. There are two parts to this; there’s a top part and a bottom part.  And in fact they both have the same screen tip which is a bit confusing.  But one of the notable differences and you’ll see this quite a bit, is that the bottom one has a little arrow.  When you’ve got a little arrow, a little sort of chevron like that, that means there’s going to be a choice.  So if I click on that, click on the drop down I’m given a choice of a pivot chart or a pivot chart and pivot table.  I can choose either of those.  Let me just click away.  If I click on the top part which doesn’t have the arrow, I just get in this case a pivot chart.  So there’s no choice for me to make there; that just makes that thing happen straightaway.  That’s quite a common feature.  So let’s look at another example over here on the right text.  If I click on the drop down under Text, I have a number of options.  Some of them have gone off the edge of the screen actually, but you can see a number of different options that I can choose from.  Now different commands will have different numbers of options or none at all, and the way they work varies as well.

So here I am back on the Home tab.  One of the commands in the Font Group is the Font Size Command and it’s actually a drop down list.  If I click on the arrow next to 11 which is the current font size, the default in this case is Calibri 11 point.  I can choose from one of the available font sizes.  So if I wanted to change to 12 select 12; that is now the font size.  If I want to, I can also edit in situ.  I don’t have to choose one from the available sizes.  So if I wanted say 13 point, I could just type 13 even though it’s not on the available list.  Now in some cases, I wouldn’t be allowed to do that.  In this case, I am.  So you have a choice there between choosing from the drop down list or putting in a value of your own.

Now amongst the other options, amongst the other command types that you’ve got here, again we’ve got various drop downs and so on, but most of these groups and certainly most of the ones on the Home tab have a little symbol in the bottom right hand corner of the group.  You can probably just about see it there.  And that’s what’s called a Dialog Box Launcher.  And if we take Font, for example, the Font Group, if I click on the Dialog Box Launcher, it brings up a dialog.  Now the dialog is the Format Cells dialog that we’ll be looking at later on.  But within that dialog, there is a specific tab selected and that is the Font tab.  And basically with this we can go through and select Font, Style, Size, Color, whether we have Underline, various other options rather than using the individual commands in the Font Group on the Ribbon we can use the more conventional dialog approach.  And some people prefer to use the dialog than taking the individual commands one at a time in the Font Group.  So if you know exactly what you want to do but you’ve got to change four or five things to do it sometimes using the dialog will give you a quicker result.

 

Office 2013 courses

 

Now one disadvantage of the Ribbon is that it does take up quite a bit of space on the screen.  But you can control this is a couple of ways.  When you’ve been using the Ribbon for a while, you’ll find that you tend to remember where the commands are and therefore if you wanted to do a particular thing on a spreadsheet, you may know that in order say to make a particular cell bold or to add up a column of figures, you need to go to a particular place on the Ribbon.  It may be then that you only need to be able to see the tab names to select the tab that you want.  Now if you look at the top right hand corner of the Excel workspace, you’ve got the Close, Maximize, Minimize buttons.  You’ve got the question mark symbol there to go to Help and in between there’s another symbol, Ribbon Display Options.  If you click on Ribbon Display Options, you have the three options for the Ribbon Display.  There’s Show tabs and Commands which is basically where it is now.  You can see the tabs, you can see the commands.  There’s Show tabs and then there’s Auto-Hide Ribbon.  Now let’s, first of all, look at Show Tabs.  Now if you select Show Tabs, what happens you now only see the names of the tabs.  You don’t see the commands at all.  Now you may see a bit of a problem there and you think, well, how am I going to use the dommands if I can’t see them?  And the point is that when you click on a tab, the Ribbon appears, you use it for a period of time and then it disappears again.  So, let’s suppose I select that cell there, F7.  I type something into it.  Let’s say I type the word Hello and I want to make that bold.  I know that to make it bold I need to go to the Home tab.  So click on Home, click on bold to make the content of that bold, and then as soon as I finished on that cell I’ve gone somewhere else, the Ribbon disappears again.  Now I can always bring it back by clicking on a tab.  Most of the time that I’m working the Ribbon is not in view and I just bring it into view when I need to use a Command.

Now the other option you can choose here, of course, is Auto-Hide Ribbon.  I’ll leave you to try this one yourself, but basically with Auto-Hide Ribbon, you hide the Ribbon and the tabs.  And in order to see them again, all you do is click at the very top of the application.  So at the top of the visible Window, click there and the tabs and the Ribbon will reappear.  This is very useful when you’ve got a large area of worksheet to work on and you don’t particularly need to access any of the commands on the Ribbon for a while.  You can give yourself pretty much the maximum amount of space to work with.

Now, one of the features of the Ribbon that’s new in Excel 2013, although it may not be that obvious to you, particularly if you’ve not used it before, is that many of the commands have been spaced out a little bit more and arranged a little bit more carefully to allow access on touch devices.  So, people who have fairly fat fingers like me will find that they can access the commands more easily if they’re using a touch screen.  One other aspect of using the Ribbon when you have so many commands on it, of course, is if you actually prefer to use the keyboard or if you’re limited to using a keyboard.  Now there’s a facility with the Ribbon called key tips you can use which will help you if you need those shortcuts.  And all you need to do on a conventional keyboard, if you’re going to use the keyboard I’m assuming you’ve got a keyboard, so you press the Alt key and what appears are this set of key tips.  So you can see them along there.  So for example Home, the tab for Home has got an H on it.  Insert has got an N, Page Layout has got a P, and so on.  And you can use those keyboard shortcuts to access one of the tabs.  So for instance if I wanted to access the Data tab, I just press the A key.  Now not only does that open up the Data tab but it gives me a similar set of keyboard shortcuts, key tip shortcuts, for all of the commands on that tab.  Now, that can be an extremely useful facility for the Ribbon if you are restricted to using the keyboard or if you just prefer to use the keyboard.  When you finish with the key tips, you just need to press the Alt key to hide them again.

Now there’s just one other thing I’d like to tell you about in relation to the Ribbon and that is I’ve mentioned that you can customize it.  Now customizing the Ribbon we won’t have time to cover on this course, but I’m going to quickly show you where you can find the facility to customize the Ribbon.  There are a couple of places actually, but the easiest way is to go into Options from Backstage View and then one of the options is Customize Ribbon.  Now from there, you can pretty much choose any tab on the right including creating a New tab for yourself and including creating new group or groups within a tab.  And you can add just about any command that’s available in Excel 2013 and believe me there are a lot of commands you can add to that new tab and that new group.  Now there are limits to what you can do to existing tabs and groups but usually the best bet is to create your own tab with your own groups to put the commands that you use the most on it.

In the next section, we’re going to talk about Quick Access Toolbar and in there I’m going to show you a little bit about customizing the Quick Access Toolbar.  And if you follow that I think you’ll find it enough to come back to this and customize the Ribbon if you want to.  But for now that’s it on the Ribbon.  We’re going to be using it throughout the course.  It’s time to look at the Quick Access Toolbar in the next section, so I’ll see you then.

 

Excel 2013 online training by Simon Sez IT

 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

START LEARNING 3 The Ribbon Is Large and in Charge in Excel 2013 ON SIMONSEZIT.COM

START MY MEMBERSHIP

Similar Posts

How to Apply a Formula to an Entire Column in Excel? 6 Ways

How to Use Layer Masks in Photoshop Elements 15

How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)

Using Research Tools in PowerPoint 2010

How to Use the Excel NOW Function? 3 Examples

How to Make a Pareto Chart Excel Dashboard? 4 Easy Steps

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)