At times you may need to move your worksheets to other locations. Perform the following to move a single worksheet or multiple worksheets to another location in the same workbook. For moving multiple worksheets, you have to first select the worksheets.
Selecting adjacent worksheets: Click on a worksheet and then press the Shift key. Keep the Shift key in pressed state, click to select the last worksheet.
Selecting non-adjacent worksheets: Click on a worksheet and then press the Ctrl key. Keep the Ctrl key in pressed state, click to select other worksheets.
Once the selection is over (a single worksheet or multiple worksheets), perform the following to move the worksheet(s):
1. On the
Home tab, in the
Cells group click
Format and click
Move or Copy Sheet... to open the
Move or Copy dialog box.
2. You have the option to move the worksheet(s) to the end in the sheet tab area or before a particular worksheet. To move the worksheet(s) to a location, say between
Sheet2 and
Sheet3, click
Sheet3.
3. Click
OK.
0 comments:
Post a Comment