Using View Side by Side to Work with Two Workbooks
To be a true Excel pro, you need to be comfortable working not only with the spreadsheet data on different sheets of the same workbook but on sheets of different workbooks as well. One way in which Excel facilitates this is through the program’s ability to open side-by-side windows on two different workbooks that you have open at a time.
When you are only dealing with two open workbooks (which is most often the case as any more than two open at a time are pretty hard to keep track of), you can create horizontal windows (one on top of the other), each displaying a part of a different workbook simply by clicking the View Side by Side button on the View tab or pressing Alt+WB.
While the two workbook windows are open in Excel, you can select different worksheets and scroll to different regions in either one by using its sheet tabs and scroll bars that appear at the edge of the window when you make its workbook active (either by clicking the window’s title bar or one of the cells of its worksheets).
To move or copy data between the open workbook files, you have a choice between using the drag-and-drop or copy-and-paste method. To use drag-and-drop, select the data to be moved or copied in the worksheet of one window and then drag the outline of the cell selection to the desired cell in the worksheet displayed in the other window. If you want to copy the cell selection, rather than move it, to the workbook in the other window, you must remember to hold down the Ctrl key as you drag its outline to its new position, releasing the Ctrl key only when you are in position and ready to drop the copied data into place.