Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Customizing the Ribbon bar

Customizing the Ribbon bar provides you with in-depth training on Business. Taught by Bob Flisser as… Show More

Excel 2010 New Features

with Bob Flisser

Video: Customizing the Ribbon bar

Customizing the Ribbon bar provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features
please wait ...
Customizing the Ribbon bar
Video Duration: 6m 59s 1h 51m Appropriate for all


Customizing the Ribbon bar provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features

View Course Description

In Excel 2010 New Features author Bob Flisser demonstrates the powerful new characteristics and capabilities in Excel 2010. This course covers Excel's Backstage view, improved sharing and collaboration capabilities, its graphics features, and enhanced data analysis and visualization tools. Exercise files accompany the course.

Topics include:
  • Using the Slicer feature for dynamic PivotTable filtering
  • Sharing workbooks via e-mail, the Excel Web App, and SharePoint
  • Using Paste Preview for more effecient copying and pasting
  • Inserting Sparklines to see patterns in data
  • Taking advantage of enhancements to the Conditional Formatting feature
  • Analyzing data from multiple sources using the PowerPivot for Excel add-in
  • Maintaining file compatibility with older versions

Customizing the Ribbon bar

When the Ribbon bar made its first introduction in the Office 2007 applications, everybody either really liked it or they really hated it, and to tell you the truth, I wasn't so crazy about it myself. People were saying, 'Gee! I knew where all my commands were, everything that I needed to know, but now they took away the menus and the toolbars, I don't know where everything is anymore.' So the good news is that in the 2010 version, and not just Excel but all of the other Office applications, this Ribbon bar is now completely customizable.

So I want to show you how to do a couple of neat things with it. The first thing is let's go up to the File menu to go into Backstage view, and down here towards the bottom choose Options, and in our Options dialog box we'll go over here to Customize the Ribbon. Now it's a lot of work to get in here. So I' just going to cancel out for a second, or you could press Escape. A much easier way of going in is whichever of these tabs is selected - it doesn't matter which one - right-click anywhere and from the pop-up menu choose Customize the Ribbon.

And now we are right back. So it's just a much easier way to get in here. First thing is let me just tell you about turning things on and off and rearranging things. Let's say, for example, the View tab is something that you use often, so you can select it and hit that up arrow a bunch of times, and now I have the View tab at the very top. Now I'm just going to move the dialog box out of the way. Notice the View tab hasn't changed just because we haven't clicked OK yet, and this is something also that's changed since the last version. Click OK, and now the View tab is right up there.

We're going to right-click and go back to Ccustomize the Ribbon. Another way to move it is you can simply take it and drag it. So let me drag it down here, just below Page Layout, and hit OK so you can move that here. So there are few ways that you can deal with that. Well, let's say I decide that maybe I don't need the View tab at all. I'm just going to deselect it. Now when I click OK, you see the View tab isn't even there. So let me right-click and go back to Customize, and I'll just turn that back on.

Well, what about that stuff that's in it? I'm just going to close up Formulas and open Home. Well, I want to add something to it. So I'm going to go over here to Popular Commands, click that down arrow, and I'll go here to the Tool Tabs. Let's say some of these Drawing tools are things that I need in there. So I'm going to open up that format. Notice, Home is still selected so I'm going to choose Insert Shapes and Add. Notice that gets added to the bottom. Maybe sizing is something I want, and maybe Headers & Footers a thing I need to use ever so often.

So I'll choose Header & Footer and add that. So I've added these three groups to the bottom. By the way - I'm just going to open one of these - you'll notice that the items in the groups are grayed out. You can't customize that. You cannot change the content of what's in a group; you can only put the groups in or take them out. So I'll click OK, and now you see these three things I've put in. Insert Shapes, Size, and Header & Footer are there, and I will just right-click over here and go to Customize the Ribbon. The same thing like with the tabs. I could take those, and I can move them, or I can use the Up arrow and move them.

So let me click OK. So now I've moved them over here to the left. So that sort of thing is very customizable. So I'm just going to right-click on the Ribbon bar and go back here to Customize. So I'm going to create my own tab here. It will be a list of maybe some of the favorite things that I need to use often. So I'm going to go down here and choose New Tab, and it gives me kind of this default name of New Tab and New Group. So I'm just going to choose that New Tab, choose Rename, and I'll call this Bob's faves.

Click OK. I'm going to go back here to this dropdown. I'll go back here to the Tool Tabs. I like the stuff that's under there. I'll go here back under Drawing tools, let's say Insert Shapes. Now you notice this Bob's faves is selected. So I'll choose Insert Shapes and click Add, and it goes in there. Now if I choose New Group, go here under Size and maybe choose Height, notice that goes in there - Width also while we are it. Let's put that in there. But this New Group isn't much of a name either, so I'm going to choose that Rename, and I'll call this Dimensions.

I'll put a couple of other things in here. I will reselect that Bob's faves, and maybe here under Header & Footer I'll put a couple of things in there, maybe one more. I will go to Options. I'll put one more in here. Notice right now Bob's faves is the second item in this list. So when I click OK, there it is. It's now the second item in the list, and here's all that stuff that I put in it and all of these are the tabs are unaffected. Of course, I could always go right-click and Customize. If I decide that I want Bob's faves down towards bottom, I can take that, and I can drag that here. OK it.

So I could put that really anywhere that I want. So this is really very nice and customizable. Customize the Ribbon again. Well, I could also rename some of the existing tabs. So, for example, Formulas. Maybe I really don't like formulas, or maybe I don't know how to use them. I can take that and rename an existing tab and call this, Formulas I don't understand. If I decide that, oh, here is some stuff under Review and maybe Language, I only do stuff in English, I don't have to worry about French or Spanish or anything. Or maybe I'm not using a tablet here, so I don't need Ink.

So, see I could really ruin this completely. But let's say this is the way that I like it. I don't want somebody else to be able to use my tabs, or maybe I'm doing this on my office computer, and I want to bring this back home and use this on my laptop. So whichever you want to do it is go down here to Import/Export, and I am going to choose Export all customizations, and I'll give this a name. I will delete that. You notice it gives you an extension of exported user interface. I'll call this bob's set of tabs.

Click Save or press Enter. Now let's say I'm now on another computer, and this is maybe my laptop. I can come back in here, go to Import > customization, and there it is, and then I can simply double-click this and import this to my other computer. I'm not actually going to do it now, because it's obviously the same computer, but you see it's a fairly easy thing to do. Now, let's say that I have done all of this, and I decided, gee, I have renamed things, I've removed things, I've really ruined in this; I want to get back to the way Excel was when I first installed it. Really easy to do.

All you have to do is hit this Reset button, choose Reset all customizations. Confirm Yes. That's what I really want to do. When I click OK, now here it is. It's all back to its original state with none of those changes. So that's a really great handy thing, and I do highly recommend that you play around with customizing the Ribbon. So things that you need to use often, you can put them there, literally right at your finger tips.

There are currently no FAQs about Excel 2010 New Features.






Don't show this message again
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Mark all as unwatched Cancel


You have completed Excel 2010 New Features.

Return to your organization's learning portal to continue training, or close this page.


Upgrade to View Courses Offline


With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

Become a Member and Create Custom Playlists

Join today and get unlimited access to the entire library of online learning video courses—and create as many playlists as you like.

Get started

Already a member?

Log in

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

You started this assessment previously and didn’t complete it.

You can pick up where you left off, or start over.

Resume Start over

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.