Download Power Utility Pak - The Spreadsheet Page

Choose Strict alphanumeric to override the "intelligent" sheet sorting. If this option is enabled, the sorting will be
strict (but may not be logical). For example, Sheet12 will appear before Sheet2.
When the View sheet option is enabled, selecting a sheet in the sheet list will activate the sheet.
Sorting sheets cannot be undone.
Save With Backup
The Save With Backup utility performs two operations with a single command:
It saves a backup copy of your workbook to a specified directory.
It saves your workbook to its original location.
Normally, saving a workbook to a backup location is a cumbersome procedure since Excel "remembers" the backup location
as the workbook's new location. When you save your file again, it is saved to the backup location -- unless you remember to
use the Save As command on the File menu to redirect the save back to its original location.
Using Save With Backup
1.
2.
3.
4.
5.
Activate the workbook to be saved and backed up.
Select Save With Backup from the PUP v7 - Workbooks and Sheets - Workbook Tools menu.
Specify the location for the backup file (use Browse to specify a drive and directory). The location can be a
removable device, a network directory, or a different directory on your hard drive.
If you'd like the backup file to use "bak" for the file extension, select the Use BAK extension checkbox. This option
will not affect the file name at the original location.
Click OK to save the workbook to the backup location, and then back to its original location.
Save With Backup Tips
If you last saved your file to a floppy disk, this utility will not let you make a backup. It's not a good practice to save
files directly to a floppy disk.
You won't be able to use this utility if you haven't yet saved your file (that is, it has a name like "Book1").
Create Workbook Contents Sheet
This utility adds a new worksheet, which serves as a table of contents for quick navigation to other sheets in the workbook.
You have two choices for the style of the table of contents sheet. These are summarized below.
Style
Description
Navigate to chart sheets?
Adds macros to your workbook?
Hyperlinks
Clickable hyperlinks
No
No
Buttons and Macros
Clickable buttons
Yes
Yes
Using Create Workbook Contents Sheet
To create a workbook contents sheet:
1.
2.
3.
Activate the workbook that will contain the table of contents sheet.
Select Create Workbook Contents Sheet from the PUP v7 - Workbooks and Sheets - Workbook Tools menu.
Choose the Style.
Page 40