Display multiple worksheets and workbooks Excel 2013

show more Displaying multiple worksheets and workbooks provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training show less
please wait ...

Displaying multiple worksheets and workbooks

If you're working with a workbook that has more than one sheet, you sometimes want to see a portion of each of these sheets at the same time. If you're working with different files at the same, you might want to see a portion of each of those files at the same time. In this movie, we need to be viewing the file 09-01-RegionalSales and two other files. When you do you have more than one file open, on the View tab in the Ribbon, the Switch Windows button shows you currently open files. The other two files we need to see are 09-01-Home Product Line and 09-01-EmployeeTable.

In this workbook RegionalSales, suppose we want to see a portion of the Midwest and the South and the West sheets as well as the East sheet that's currently showing. On the View tab, if we want to see additional windows, we need to Click New Window three times. Back to the View tab, New Window, Back to the View tab, New Window. We now have four windows available, View tab, Arrange All and we do want to make sure in this case, we want to view windows of the active workbook. There are four choices here, Tiled is usually the best. Click OK.

We now have four windows. It's looking very crowded. One thing we can do to see more of each worksheet is to Double-Click any of the tabs, for example, the View tab and that collapses the view. I'll do this in the window on the right side too, Double-Click View in each case here. Lower right-hand corner, Double-Click View and lower left corner, Double-Click View. It's quite possible we're looking at the same worksheet in each window so that's not so helpful so in the upper right window, let's just Click there and view the Midwest sheet. In the lower left corner, Click there and Click the South sheet, lower right corner, Click the West sheet.

So now we're seeing four of the different sheets at the same time and this layout might be ideal if we're simply comparing the information, looking back-and-forth or if we need to copy information, it's best to have the sending and receiving areas all visible on the screen at the same time. Now we don't always want to see four windows. Maybe we only want to view two, so we can close down these windows. It seems like we're closing a file if we Click the X in the upper right-hand corner of one of these windows. I'm about to do this in the lower right-hand corner. So just Click the X and if there are other files in the background, we might be seeing a portion of them, I'll go to the upper right, Click the X there and now I want to view just these two windows so I'll back to the View tab in the ribbon and choose Arrange All.

We might possibly want to arrange these windows in a horizontal arrangement. Click OK and now we see the windows this way. At other times maybe it's more advantageous to view these vertically, View tab>Arrange All>Vertical. You'll be the best judge of which layout works best for you. Now we do have two other files open. Sometimes we want to see portions of each of those files. Currently, we see two windows of the same workbook. We can close either one of these and we're back to one window here.

Now, let's consider viewing a portion of each workbook. Back to the View tab, we don't need additional windows here, simply Arrange All, this time make sure that you un-check the box for Windows of active workbook. You can choose any arrangement you want. Tiled tends to work best most of the time. Click OK and now we're seeing portions of three separate workbooks. Whenever there's an odd number, one of these will get a larger share of the screen and so if for example here, if we want the Employee Table, which is now on the lower right-hand corner to have greater dominance here, just Click there and then go to the View tab, choose Arrange All>Tiled>OK and that's now going to be on the left-hand side.

And here too, when you're comparing information in different files or you want to copy-paste information from one file to another, this is the ideal arrangement. At any time, if you simply want to focus on one of these, just maximize using the box just to the left to the X in the upper right-hand corner, the Maximize button, to make that particular file become full screen. So as we've seen, you can see different sheets of the same workbook by first creating new windows and then arranging the layout or you can see portions of multiple workbooks simply by clicking the Arrange All button.

Displaying multiple worksheets and workbooks
Video duration: 4m 17s 6h 32m Appropriate for all


Displaying multiple worksheets and workbooks provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training

Business Education + Elearning
please wait ...