Excel relies on a number of rules for displaying sheets, but you can put them in the order you like with just a few quick clicks.
When you add an worksheet, Excel positions it between the currently selected sheet and the previous sheet. Regardless of how careful you are adding new sheets, you might want to rearrange them. To do so, simply right-click the tab you want to move and select Move Or Copy from the resulting context menu. Then, in the Before Sheet dialog box, select the appropriate sheet or select the (Move To End) option. For instance, the sheets in the workbook shown below represent the first three months of the year, but they aren't in the customary order: January; February; March.
You can quickly position them in the traditional order:
With just a few clicks, you can quickly reposition sheets.
- Right-click March and choose Move Or Copy.
- In the resulting Move Or Copy dialog box, select (Move To End) and click OK.
- Right-click January and choose Move Or Copy.
- Select February and click OK.