|  

» Selecting a Sheet from a Sorted Sheets List

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
Selecting a Sheet from a Sorted Sheets List


Rate This Tip
12 34 5
Rating: 3.38     Views: 16501
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments