Tip # 15 A change of scenery: Move or copy a worksheet

You may know that you can just drag and drop a worksheet to a different spot in the workbook. But for you folks who get joy from dialog boxes (and truthfully, this one gives you more options), here you go:

To move or copy a worksheet

Right-click a tab, and then click Move or Copy on the shortcut menu.

In the Move or Copy dialog box, you have options: To move the worksheet to a spot within its own workbook, select a sheet in the Before sheet box.

To move the worksheet to another open workbook, select the workbook in the To book list and then click OK.

To keep a copy of the worksheet you're moving in this workbook (rather than just moving it), select the Create a copy box.