In our third Where Is it Wednesday, I will take a look at the changing face of the ribbon, including the point where the ribbon completely disappears. Episode 818 will show you how your co-workers ribbon may appear completely different than your ribbon.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey. Alright. Welcome back to Where Is It Wednesday, and here's a great question.
Where did the ribbon go?
Check out this tiny version of Excel over here and there's no ribbon at all.
Well, you know, for all of Microsoft's spin on the ribbon and how great it is and how everyone has the exact same user experience, the ribbon really looks different from computer to computer depending on how wide of a monitor you have.
In fact, it really looks best on a widescreen monitor, a big huge 1440 wide, and I've switched most of my main computers over.
Now, this podcast is recorded on a laptop and so this is about as wide as we can go here.
So, take a look at our HOME ribbon.
You'll see that they've already started to collapse.
So, for example, on a widescreen monitor, WRAP TEXT has the words wrap text.
We've already started to collapse, and as your monitor gets smaller and smaller and smaller, you're going to see more and more things collapse.
Like, for example, here, in the STYLES group, we have nice big icons with dropdowns for CONDITIONAL FORMATTING, FORMAT AS TABLE, and CELL STYLES, but as we get just a little bit more narrow, those change to smaller icons, still with dropdowns, and as we keep collapsing, various pieces lose the words and become smaller icons.
Eventually, though, it gets so small that entire groups have to be switched out to a dropdown that leads to those icons, and, sooner or later, you get down to the point where each group is itself just a single dropdown.
Eventually, though, you get to the point where it is so small, their theory is no one could possibly be working in Excel anymore, and so they actually remove the entire ribbon and just leave you the spreadsheet.
So, if you've minimized Excel in order to maybe see, you know, a Word document next to it, you may eventually lose the entire ribbon.
The only thing you can do to get that back is to resize the window, at least to the point where we can see the various ribbon tabs appear.
So, the ultimate Where Is It Wednesday -- sometimes, the entire ribbon will simply just disappear.
Well, I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
Where did the ribbon go?
Check out this tiny version of Excel over here and there's no ribbon at all.
Well, you know, for all of Microsoft's spin on the ribbon and how great it is and how everyone has the exact same user experience, the ribbon really looks different from computer to computer depending on how wide of a monitor you have.
In fact, it really looks best on a widescreen monitor, a big huge 1440 wide, and I've switched most of my main computers over.
Now, this podcast is recorded on a laptop and so this is about as wide as we can go here.
So, take a look at our HOME ribbon.
You'll see that they've already started to collapse.
So, for example, on a widescreen monitor, WRAP TEXT has the words wrap text.
We've already started to collapse, and as your monitor gets smaller and smaller and smaller, you're going to see more and more things collapse.
Like, for example, here, in the STYLES group, we have nice big icons with dropdowns for CONDITIONAL FORMATTING, FORMAT AS TABLE, and CELL STYLES, but as we get just a little bit more narrow, those change to smaller icons, still with dropdowns, and as we keep collapsing, various pieces lose the words and become smaller icons.
Eventually, though, it gets so small that entire groups have to be switched out to a dropdown that leads to those icons, and, sooner or later, you get down to the point where each group is itself just a single dropdown.
Eventually, though, you get to the point where it is so small, their theory is no one could possibly be working in Excel anymore, and so they actually remove the entire ribbon and just leave you the spreadsheet.
So, if you've minimized Excel in order to maybe see, you know, a Word document next to it, you may eventually lose the entire ribbon.
The only thing you can do to get that back is to resize the window, at least to the point where we can see the various ribbon tabs appear.
So, the ultimate Where Is It Wednesday -- sometimes, the entire ribbon will simply just disappear.
Well, I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
