For this lesson you need to open the sample file The Wealth of Nations from your Sample Files Folder (if it isn't already open).
Most desktop computers have large display screens. The space taken by the Ribbon and Formula Bar isn't usually a problem.
As you'll discover in Session 8: Cloud Computing, it's now possible to run Excel 2013 on tablet computers and even on Smartphones. These devices often have a very small display screen, meaning that the Ribbon and Formula Bar take up too much valuable screen space.
When screen space is limited, you may wish to hide the Formula Bar, Ribbon or even both in order to maximize the number of cells visible on the screen.
You can see that on my screen, 21 rows are currently visible. Of course, on your own screen you may see more or fewer rows, depending on the size of your screen.
The first thing we can do to increase the number of rows visible is to hide the Formula Bar. To do that, I click View on the Ribbon and, in the Show group, you can see there's a Formula Bar checkbox. I'll now click that checkbox to hide the Formula Bar, and I can now see 23 rows of information on screen. But the Ribbon's taking up a lot of screen space.
We're now going to use the Ribbon Display Options button. This is a brand new feature for Excel 2013. The Ribbon Display Options button is at the top right of the screen. And when I click the button, you can see that there are three options. The first one is: Auto-hide the Ribbon, the second is to Show the Ribbon tabs, and the last shows the screen as it is now, with the Ribbon tabs and commands visible all of the time.
We'll begin with the second option: Show Tabs. I click: Show Tabs, and the Ribbon is reduced to a row of tabs.
You can still access the Ribbon. It now pops up when you click on any tab, and disappears when you click back onto the worksheet. Let's try that.I'll click the Home tab on the Ribbon, and the Home Ribbon appears. And if I click back onto the worksheet, the Ribbon disappears again.
And you can see that 27 rows of information are now visible on the screen, but what about if even 27 rows isn't enough? Well we can completely hide both the Ribbon and the Ribbon tabs. To do that, I click the Ribbon Display Options button at the top right of the Excel window, and then I click: Auto-hide Ribbon on the Rich Menu. This time both the Ribbon and Ribbon tabs disappear. The worksheet itself fills the entire screen. This is called Full Screen View.
When you're in Full Screen View, you can temporarily bring back the Ribbon by double clicking at the very top of the screen. Let's try that now, I move the mouse cursor to the very top of the screen and then double click, and the Ribbon returns. To make the Ribbon disappear again, I simply click back inside the body of the worksheet.
Now let's restore the Ribbon to its default state: the way in which we normally want to work with Excel. So to do that, I'll click the Display Options button and select Show Tabs and Commands, to show the Ribbon tabs and commands all of the time. I'll click, now, and the Ribbon's back to normal.
But we're still missing the Formula Bar, so let's bring that back as well, by clicking the View tab on the Ribbon. And in the Show group, I'll check the Formula Bar checkbox. And this is the normal way of working with Excel: with the Ribbon on display all of the time, along with the Formula Bar.
You've now completed Lesson 1-17: Hide and Show the Formula Bar and Ribbon.