Microsoft Office Tutorials and References
In Depth Information
Rearranging your worksheets
Rearranging your worksheets
You may want to rearrange the order of worksheets in a workbook. If you have a separate
worksheet for each sales region, for example, arranging the worksheets in alphabetical
order might be helpful. You can also move a worksheet from one workbook to another and
create copies of worksheets, either in the same workbook or in a different workbook.
You can move or copy a worksheet in the following ways:
Right-click the sheet tab and choose Move or Copy to display the Move or Copy
dialog box (see Figure 14.4). Use this dialog box to specify the operation and the
location for the sheet.
FIGURE 14.4
Use the Move or Copy dialog box to move or copy worksheets in the same
or another workbook.
To move a worksheet, drag the worksheet tab to the desired location. When you
drag, the mouse pointer changes to a small sheet, and a small arrow guides you. To
move a worksheet to a different workbook, the second workbook must be open and
not maximized.
14
To copy a worksheet, click the worksheet tab, and press Ctrl while dragging the
tab to its desired location. When you drag, the mouse pointer changes to a small
sheet with a plus sign on it. To copy a worksheet to a different workbook, the
second workbook must be open and not maximized.
You can move or copy multiple sheets simultaneously. First, select the sheets by clicking their sheet tabs while
holding down the Ctrl key. Then you can move or copy the set of sheets by using the preceding methods.
If you move or copy a worksheet to a workbook that already has a sheet with the same
name, Excel changes the name to make it unique. For example, Sheet1 becomes Sheet1 (2).
Search JabSto ::




Custom Search