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

Working with Multiple Workbooks 259
To move data between workbook windows, arrange the worksheets in these windows so that both the cells with the data entries you want to move and the cell range into which you want to move them are both displayed in their respective windows. Then, select the cell selection to be moved, drag it to the other worksheet window, drag it to the first cell of the range where it is to be moved to, and release the mouse button. To copy data between work- books, you follow the exact same procedure, except that you hold down the Ctrl key as you drag the selected range from one window to another. (See Book II, Chapter 3 for information on using drag-and-drop to copy and move data entries.)
When you’re finished working with workbook windows arranged in some manner in the Excel Work area, you can return to the normal full-screen view by clicking the Maximize button on one of the windows. As soon as you max- imize one workbook window, all the rest of the arranged workbook windows are made full size as well. If you used the View Side by Side feature to set up the windows, you can do this by clicking the View Side by Side command button on the View tab again or by pressing Alt+WB.
Transferring sheets from one workbook to another
Instead of copying cell ranges from one workbook to another, you can move (or copy) entire worksheets between workbooks. You can do this with drag- and-drop or by choosing the Move or Copy Sheet option from the Format command button’s drop-down menu on the Ribbon’s Home tab.
To use drag-and-drop to move a sheet between open windows, you simply drag its sheet tab from its window to the place on the sheet tabs in the other window where the sheet is to be moved to. As soon as you release the mouse button, the entire worksheet is moved from one file to the other, and its sheet tab now appears among the others in that workbook. To copy a sheet rather than move it, you perform the same procedure, except that you hold down the Ctrl key as you drag the sheet tab from one window to the next.
To use the Move or Copy Sheet option on the Format command button’s drop-down menu to move or copy entire worksheets, you follow these steps:
1. Open both the workbook containing the sheets to be moved or copied and the workbook where the sheets will be moved or copied to.
Both the source and destination workbooks must be open in order to copy or move sheets between them.
2. Click the workbook window with sheets to be moved or copied.
Doing this activates the source workbook so that you can select the sheet or sheets you want to move or copy.
Book II Chapter 4
Managing Worksheets