Toggle Help Topics Menu >

Add Multiple Worksheets

The Add Multiple Worksheets tool lets you add one or more sheets to the current workbook.

Form Fields

  • Import names: Clicking the button will prompt for the range to import the names. If any of the cells have a back fill color, the color will automatically be assigned as the sheet tab color.
  • Enter sheet names: You can type in new sheet names, one per line, and then click the add button.
  • New Worksheets: This listing shows the new sheet names and tab colors. You can double-click the sheet name to edit it. Any rows with blank sheets names will not be added to the workbook.
  • Change tab color: Opens a dialog to select a new tab color for the selected row(s).