Manage Worksheets application of Optipe Data Tools Suite incorporates different options for managing sheets from one or more of Excel workbooks.

Use this application to:

• Group spreadsheets of different Excel workbooks into a single workbook.
• Show and hide sheets.
• Sort sheets alphabetically.
• Protect and unprotect multiple sheets simultaneously.
• Rename sheets with a cell value of each sheet or a text and a serial number.
• Save sheets on individual files.

Features:

• Allows you to manage sheets from active workbook or all open workbooks.
• You can pick the sheets on which to perform the action, or select them all at once.
• You can also select the sheets whose name matches a given text.
• Show all available sheets indicating whether they are protected if they are visible.
• To select a consecutive group of sheets, click the first item, press and hold down the Shift key, and then click the last item.
• To select non-consecutive sheets, press and hold down the Ctrl key, and then click each item that you want to select.

Examples

Video Example. Rename sheets.

Video Example. Show/Hide and Protect/Unprotect sheets.