Moving Worksheets

Business needs change—the data that was so important yesterday might be of only passing significance today. In fact, if a new customer sends a big order your way, you might spend most of your time adding to and reading from a worksheet you hadn’t looked at more than twice in the previous month. If that worksheet is at the back of your workbook, you can move it to the front to make it easier to find in the workbook. Or, if you keep every other worksheet relating to that customer in a separate workbook, you can move the worksheet from its current spot to its rightful place in the other workbook.

Move Worksheets within the Workbook

  • Drag the sheet tab of the worksheet you want to move.

    Move Worksheets within the Workbook

Move Worksheets to Another Workbook

  1. Open the workbook that will receive the worksheets.

  2. Switch to the workbook that contains the worksheets you want to move, hold down the Ctrl key, and click the sheet tabs of the worksheets you want to move.

  3. Right-click the selection.

  4. Choose Move Or Copy from the shortcut menu.

  5. Click the To Book down arrow.

  6. Click the workbook to which you want to move the worksheets.

  7. Click OK.

    Move Worksheets to Another Workbook

    Tip

    Tip

    If you want to position a worksheet last in a workbook, right-click the worksheet you want to move, choose Move Or Copy from the shortcut menu, click Move To End, and click OK.

    Tip

    Tip

    If the destination workbook has a different Office theme applied to it, selecting the Match Destination Theme check box causes the copied worksheet to take on the target workbook’s formatting.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.202.27