Page 276 - Excel 2013 All-in-One For Dummies

258 Working with Multiple Workbooks
When you want to resume normal, full-screen viewing in the workbook window, click the Maximize button in one of the windows. To get rid of
a second window, click its button on the taskbar and then click its Close Window button on the far right side of the menu bar (the one with the X). (Be sure that you don’t click the Close button on the far-right of the Excel title bar, because doing this closes your workbook file and exits you from Excel!)
Working with Multiple Workbooks
Working with more than one worksheet in a single workbook is bad enough, but working with worksheets in different workbooks can be really wicked. The key to doing this successfully is just keeping track of “who’s on first”; you do this by opening and using windows on the individual workbook files you have open.
With the different workbook windows in place, you can then compare the data in different workbooks, use the drag-and-drop method to copy or move
data between workbooks, or even copy or move entire worksheets.
Comparing windows on different workbooks
To work with sheets from different workbook files you have open, you manu- ally arrange their workbook windows in the Excel Work area, or you click the View Side by Side command button on the View tab of the Ribbon or press Alt+WB. If you have only two workbooks open when you do this, Excel places the active workbook that you last opened above the one that opened earlier (with their active worksheets displayed). If you have more than two workbooks open, Excel displays the Compare Side by Side dialog box where you click the name of the workbook that you want to compare with the active one.
If you need to compare more than two workbooks on the same screen, instead of clicking the View Side by Side button on the View tab, you click the Arrange All button and then select the desired Arrange option (Tiled, Horizontal, Vertical, or Cascading) in the Arrange Windows dialog box. Just make sure when selecting this option that the Windows of Active Workbook check box is not selected in the Arrange Windows dialog box.
Transferring data between open windows
After the windows on your different workbooks are arranged onscreen the way you want them, you can compare or transfer information between them. To compare data in different workbooks, you switch between the different windows, activating and bringing the regions of the different worksheets you want to compare into view.