» Selecting a Sheet from a Sorted Sheets List

CATEGORY - Excel Worksheet, Workbook VERSION - All Microsoft Excel Versions

To select a sheet from a list of sheets sorted in ascending order,
install the ChooseSheet.xla Add in:

1. Download the ChooseSheet.xla add-in by join to ExcelTip newsletter (see left column).
2. Save the downloaded ChooseSheet.xla file in any folder.
3. From the Tools menu, select Add-Ins, and then click Browse.
4. Locate and select the ChooseSheet.xla file and click OK.
5. From the Add-ins available, check the ChooseSheet.xla box, and then click OK.
6. To select a sheet from the sorted sheets list, click the new Choose Sheet icon (number 7 in the Regular toolbar).
Screenshot // Selecting a Sheet from a Sorted Sheets List