Move worksheets to another location in the same workbook in Excel 2007

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.