Sort all Sheets in a  File                We are so used to sorting Excel Data in various ways. If only we could sort the sheet names so that they appear alphabetically so as to help us find any sheet very quickly. Well, Help is at hand, use this function to quickly sort the Sheets.

Create clickable Index sheet of all sheets in File Besides sorting, when we have files with multiple sheets say around 30-40, wouldn't it be great to have a Index sheet where all the sheet names would appear in Rows and also be clickable. Thereafter you could write comments about each sheet in the next column for easy understanding of what the sheet contains. The hyperlink may not work properly with some type of Sheet names.

Create clickable Index sheet of all Range names in a File If you have a lot of Range names used in a file and you want to have a sheet where all the Range names are put along with their cell reference use this program. It will add a new sheet with a default name of "Index Sheet" where all the Range names will be put along with reference. The names will be hyperlinked so that by clicking on the Range name you will be transported to the actual range to which it refers too.

Remove all empty Sheets Removes all blank Sheets from the file. Specially useful when there are many sheets with default names like Sheet1, Sheet2 … and you do not know which are useless and which are empty and just creating confusion.

Copy Multiple instances of a sheet within a file

In case you have a well formatted sheet and this need to be copied multiple times in the same workbook use this program which will easily make as many copies as you want.

Unhide sheets in a File
Use this program to unhide all hidden sheets in a file. It cannot open password protected sheets.

Insert File Path, File Name & Sheet Name in Cell                Sometimes you would like to put the details of the File name, Path and sheet name in a particular cell within the worksheet. Just use this function to do the same.

Insert File Name in Active Cell                Put the File Name in the Cell.

Insert Sheet name in Active Cell                    Put the Sheet Name in the Cell.

Insert File Name & Sheet Name in Active Cell     Put the File Name and Sheet Name in the Cell.

Delete all Pagebreaks in selected sheet                Sometimes finding a page break can be tiring if you do not know where it is. Use this function to delete all page breaks in the current sheet.

Delete all Pagebreaks in all sheets    Sometimes finding a page break can be tiring if you do not know where it is. Use this function to delete all page breaks in the all the sheets of the file.