B11.jpg
Professional Applications for Microsoft Excel
EnglishEspañol (spanish formal Internacional)PortuguêsDeutsch

Optipe Data Tools Suite - Manage Worksheets

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

Data Tools Suite Manage Worksheets

Manage WorksheetsUse 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:

BuyNow

Examples

Video Example. Group sheets of different workbooks.


Video Example. Save sheets as individual files.

Video Example. Rename sheets.

Video Example. Sort sheets alphabetically.

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

Copyright © OPTIPE - Optimize Time Performance. Professional Applications for Microsoft Excel 2024

Template by Joomla Themes & Copywriter.