Manage Worksheets in Excel 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.
See also:
Examples
Video Example. Group sheets of different workbooks.
