Add new sheets

Sheet > Add new sheets from selection

This utility quickly adds new worksheets based on information in a selected data range.

A new worksheet will be created for each selected cell, and the cell contents will be used as the name of the new worksheet.

For example, you need to quickly add sheets for each quarter of 2023.

Screenshot

Running this tool

Click YLC Utilities > Sheet > Add new sheets from selection :

Excel:

LibreOffice Calc:

Do you recognize any of these situations?

• Is it possible to insert 100 new worksheets at once or do I need to click "insert sheet" 100 times?
• We need to insert 30 worksheets, each with different names, into an existing workbook. Excel (Calc) . Is there a quick way to do this?

Decision

Simply select the cells that contain the names for the new sheets and select the following tool from the menu Excel (Calc) :

YLC Utilities » Sheet » Add new sheets from selection

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel (Calc) , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Add new sheets from selection by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel (LibreOffice Calc) .