Help Menu

Save Worksheets to Separate Files

The Save Worksheets to Separate Files tool will take each worksheet, move it to a separate file and save it under its own workbook.

Form Fields

  • Worksheet listing grid: Includes a checkbox for indicating whether to extract each worksheet, the sheet name, and the output file name (double-click the name to edit it).
  • Save to folder: Allows you to specify where to save the extracted sheets.
  • Remove saved workbooks: Indicates whether to make a copy of the extracted sheets or to fully remove them from the current workbook.

Note: If you choose to remove the sheets from the current workbook, there must be at least one sheet remaining in the workbook. Spreadspeed will default to retaining the first sheet.