Add Multiple Worksheets
The Add Multiple Worksheets tool lets you add one or more sheets to the current workbook.
- 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).