Home Screenshots 10 Languages Why use it?

Tip of the Day | Monday April 20th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Insert Multiple Sheets Using Cell Values as Names...

Quickly create multiple worksheets using the values from your selected cells as sheet names.

Each cell in your selection creates a new worksheet, using the cell's content as its name. Optionally, the new sheet's tab color matches the cell's color for better organization.

Options:

Use an existing worksheet in your workbook as a template so all new sheets start with the same layout.

Apply the cell's background color to the sheet tab for easy identification.

How to use:

Select a range of cells containing the names for your new sheets.

Run this tool, choose your options, and each cell in your selection creates a new worksheet.

Tip: To quickly create a list of names that you can use for the worksheets, use ASAP Utilities' 'Auto Numbering and Labeling of Selected Cells...' or Excel's built-in tools, such as Fill Series, Flash Fill, Auto Fill, or the SEQUENCE function.

Screenshots

Sheets › Insert Multiple Sheets Using Cell Values as Names...

Starting this tool

Click ASAP Utilities › Sheets › 2. Insert Multiple Sheets Using Cell Values as Names...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.