Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
The Ribbon menu system in Excel 2010 takes up a good deal of space at the top of the screen. There is no question that it's vital and we need it there most of the time, but sometimes it gets in the way. We would like to show more rows of data perhaps. Maybe we're making a presentation. We can easily collapse the Ribbon in one of two ways. Simply by double-clicking a tab. I'm about to double-click the View tab here. It collapses the Ribbon. We're not seeing the commands. So for the moment, maybe we're viewing the data. That's the focus.
How do we get the Ribbon back? Simply double-click it again. Any tab of course. It makes no difference which one. You can also do this from the keyboard. It's Ctrl+F1, a new keystroke shortcut as of Excel 2007, Ctrl+F1, and that's a toggle back and forth, Ctrl+F1. You can have an even more collapsed view if you go to the View command and choose Full Screen under the Workbook Views group, and that hides the Ribbon entirely.
First time you try this, you might be in panic mode because you don't see any other button to choose up there to get back, but that all-purpose panic button is the Escape key and surely this does bring back the view that we saw just before going here. So you can go that route as well. So, easy fast ways to see more data and less of that Ribbon when you don't need to see it.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74239 Viewers
80 Video lessons · 129582 Viewers
52 Video lessons · 63857 Viewers
59 Video lessons · 49650 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.
Your file was successfully uploaded.