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:
- 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.
With just a few clicks, you can quickly reposition sheets.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays