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

260 Working with Multiple Workbooks
3. Select the sheet tab of the worksheet or worksheets to be moved or
copied.
To select more than one worksheet, hold down the Ctrl key as you click the individual sheet tabs.
4. Click the Format button on the Home tab and then choose Move or Copy Sheet from the drop-down menu or press Alt+HOM.
Doing this opens the Move or Copy dialog box, as shown in Figure 4-12.
5. From the To Book drop-down menu, choose the filename of the work- book into which the selected sheets are to be moved or copied.
If you want to move or copy the selected worksheets into a new work- book file, choose the (New Book) item at the very top of this drop-down menu.
6. In the Before Sheet list box, click the name of the sheet that should immediately follow the sheet(s) that you’re about to move or copy into this workbook.
If you want to move or copy the selected sheet(s) to the very end of the destination workbook, click (Move to End) at the bottom of this list box.
7. If you want to copy the selected sheet(s) rather than move them, select the Create a Copy check box.
If you don’t select this check box, Excel automatically moves the selected sheet(s) from one workbook to the other instead of copying them.
8. Click OK to close the Move or Copy dialog box and complete the move or copy operation.
Figure 4-12:
Copying a worksheet to another workbook using the Move or Copy dialog box.
Saving a workspace
Excel’s Workspace feature enables you to save the window arrangement that you’ve set up in a special workspace file (given the filename extension .xlw, which stands for Excel workspace). In a workspace file, Excel saves all the