Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Move Or Copy Worksheets Or Worksheet. You can select multiple sheets by holding down the Shift or Ctrl key while clicking on the sheets you want to work with. Hello Val_L Make sure the workbook is not protected.
On the Move or Copy dialog box select the workbook into which you want to copy the worksheet from the To book drop-down list. Select a sheet from the Before sheet to move the current sheet in-front to it. This is a limitation of Excel.
Right-click on the worksheet tab and click on the Move or Copy option.
Select the worksheets that you would like to move or copy. Select a sheet from the Before sheet to move the current sheet in-front to it. Excel will then display a list of all worksheets in the workbook. Nothing but a Built-in excel feature.