A Flexible Way to Sort Sheets in Microsoft Excel 2007/2010

Normally Excel does not support you with one click to quickly rearrange the order of sheets, either in alphabetical or numeric order. You may need to drag and drop the sheet tabs to rearrange them in the sheet tab bar one by one if you want to sort the sheets order. There is not a handy way for rearranging sheets in a large workbook. With Kutools for Excel’s Sort Sheets tool, you can quickly: Demo

Sort the sheets in a quite handy way;
Sort sheets in alphabetical, strict alphanumeric or reverse order with one click.

Click "Kutools">>"Worksheets Tools">>"Sort Sheets". See screenshots (Fig.1 and Fig.2).


Fig.1 Sort Worksheets		Fig.2 Sort Worksheets dialog box

Usage:

1. Activate the workbooks you want to sort.

2. Sort sheets according following options:

2.1 Click the Move Up or Move Down button, or drag the sheets in the dialog box to quickly rearrange the sheets order.

2.2 Sort sheets in alphabetical order. For example, there are 7 worksheets with chaotic order in the current workbook, and they are sheet1, treasure, accompany, sheet3, align, agency, sheet2, and compare. When click the “Alpha Sort” in the dialog box, you may get an alphabetical sorting result listing as accompany, agency, align, compare sheet1, sheet2, sheet3, treasure. See Screenshot (Fig. 3 and Fig. 4)

Fig. 3 before sorting worksheets in alphabetical order

Fig. 4 after sorting worksheets in alphabetical order

2.3 Sort sheets in strict alphanumeric order. For example, we have 6 worksheets with the order as accompany5, sheet15, align56, sheet6, agency23, team1. After sorting in strict alphanumeric order, the worksheets will be arranged as the following order accompany5, agency23, align56, sheet15, sheet6, team1. See Screenshot (Fig. 5 and Fig. 6)

Fig. 5 before sorting worksheets in strict alphanumeric order

Fig. 6 after sorting worksheets in strict alphanumeric order

2.4 When check the box before “Reverse Order”, you can get the worksheets displaying in reverse order. Just take the worksheets’ order showing in the Fig. 6 for example, if you choose the “Reverse Order”, then the result will display as team1, sheet6, sheet15, align56, agency23, accompany5. See Screenshot (Fig. 7)

Fig. 7 after sorting worksheets in reverse order

Notes:

1. The order of the sheets listed in the dialog box provides a preview of how the sheets will be sorted. The sheets are not actually sorted until you click OK.

2. The “strict alphanumeric order” and “Reverse Order” require clicking “Alpha Sort” after choosing those options to apply the changes.

See Sort Worksheets feature demo (video 1)

Video 1.Sort Worksheets feature demo.