The Ribbon
- 03:57
Understand how to navigate the Ribbon in Excel
Downloads
No associated resources to download.
Glossary
Accelerator Keys Keyboard Shortcuts RibbonTranscript
The ribbon is the main way of changing things within the table of Excel underneath the ribbon. If you are used to older versions of Excel, the toolbar at the top would be familiar to you and the menus were hidden within it. When it comes to the ribbon, everything's on show. Now you might be thinking, oh, I knew where everything was in Old Excel, but you might be quite familiar with a lot of things that are now on show. Here we're on the home ribbon and I can see that I've got the clipboard section on the left hand side, and in there I've got paste, I've got the scissors for cut, and the two pages underneath for copy. To the right of that in the font section, I've got the capital B for bold, the capital I for italics, and U for underline. In the alignment section, I can see I've got a line left, middle and right, and there are many other ribbons to go into as well. At the top we can see we've got home, insert, draw, and so on. Let's go into Excel and explore a bit more. Here. We're on the home ribbon, and I can see in the bottom right hand corner of each section there's an options arrow. If you click on this options arrow, I'm going to do it in the font section here. It gives you access to more detail. So this dialogue box has been brought up and I'm on the font tab, and this gives me access to some things that aren't in the ribbon, such as strikethrough, superscript, and subscript. I could press cancel and do exactly the same thing in the alignment section, and now I'm on the alignment tab within the Format Cells dialogue box. Other things on the home ribbon include the number section styles, cells, editing and more. A few things we'd like to point out on the insert ribbon. You can insert charts on the page layout ribbon.
You can change the orientation from portrait to landscape and vice versa, and you can also turn your grid lines off and on.
On the formula's ribbon, we've got functions grouped by type and on the data ribbon you can sort and filter.
On the review ribbon spelling and inserting a new comment might be of interest. And last but not least, on the view ribbon, you can change from normal view to page break view. Now if I do that at the moment, it's not selecting anything because I haven't put anything in my spreadsheet, but here if I just start typing title, name and let's just insert some numbers, we can see that the area that's going to be printed is shown and if I go to file and print, I get a preview of what's been included.
So that's a brief introduction to the ribbon. If you find yourselves with a bit of time, do delve in. There are lots of things to find.