Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
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.
Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.