We'll begin this lesson by opening a new blank workbook.
Excel has helpfully created a workbook, unimaginatively named Book1. If you already have a workbook open called Book1, the new workbook will be called Book2, and so on. Notice that "Book1 - Excel" is displayed on the Title Bar.
We're now going to create another new blank workbook. To do that, I click the File button at the top left of the screen, and then I click the New button on the left hand menu bar. Then I'll click the "Blank workbook" template.
Now you could be forgiven for thinking that nothing had happened, but you can see that the Title Bar now says: "Book2 - Excel", showing that you're now looking at a different new workbook.
We'll now use the Task Bar to move between workbooks. You'll see an Excel icon with two right hand borders at the bottom of the screen. Hover over this icon with the mouse and you'll see a gallery showing two workbooks, Book1 and Book2: the two workbooks that are open at the moment.
If I click on Book1, the window will change to display the Book1 workbook. Now, not much will happen, because both workbooks are empty, but you'll notice the Title Bar changing from Book2 to Book1. I'll click on Book1 now, and I'll click on Book2, and back again to Book1.
At this point I'm going to introduce a Shortcut Key that I use all the time. It makes it very easy to navigate between Excel workbooks when you have several workbooks open. It's not such a timesaver when there's only two workbooks open as there are now, but you may find yourself in a situation where you have a large number of workbooks open, perhaps 20 or 30, and it's very difficult to find the workbook you need.
The Shortcut Key combination is Ctrl-Tab. So I'll now hold down the Control key, and I'll press the Tab key several times. And as I press the Tab key, notice what's happening at the top of the screen. We can see Book1, Book2, Book1, Book2, Book1, Book2. And if there were 30 workbooks, we could quickly scroll through all 30 workbooks until we find the workbook that we need.
You can also find a workbook when many are open using the Ribbon. Here's how this is done. I'll click the view tab on the Ribbon and, in the Window group, I'll click Switch Windows. I'm then presented with a list of all currently open workbooks. At the moment there's only two, so I can quickly change from one workbook, in this case Book2, to another: Book1.
I'll click on Book1 now and, when I do, you'll see the Title Bar change again. I'll click Book1 now, and I'm now viewing the Book1 workbook.
Next I'm going to display both Book1 and Book2 at the same time. To do that, I click View on the Ribbon and, in the Window group: Arrange All. I'm then presented with the Arrange Windows dialog, and I can arrange them in four different ways. Well, I'd like one window to be on top of the other window, so I'll click the Horizontal option and then click OK. And you can see that both workbooks now fill exactly half of the screen each. And I can see both the Book1 and the Book2 workbook, one on top of the other.
Notice that there's a slight difference between them. The Title Bar for Book1 displays normally, but for Book2 the Title and the icons to the right are both greyed out. That's because Book1 is currently the active workbook.
If I click inside Book2, I'll do that now, Book2 becomes the active workbook. The Title Bar lights up and the Title Bar for Book1 is now greyed out.
I'm now going to close Book2 and maximize Book1, to restore the display to a single workbook. You'll remember that we covered maximizing windows back in Lesson 1-4.
So if I want to close Book2 I need to first click in Book2 to make sure it's the active window. Then I can click the Close button at the top right hand corner. And now I'll maximize Book1 to the normal way of working, with the Excel application filling the screen. And to do that I'll click the Maximize button.
You've now completed Lesson 2-2: Create a New Workbook and View Two Workbooks at the Same Time.