Skip to main content

Quickly rename multiple worksheets in Excel

Author: Sun Last Modified: 2024-12-10

Kutools for Excel

Boosts Excel With 300+
Powerful Features

If you have a bundle of worksheets need to be renamed, what will you do? Will you manually rename the multiple worksheets one by one? Kutools for Excel has embodied a sophisticated Rename Worksheets feature for you. It really saves you time from manually renaming a bundle of worksheets in Excel. With this feature you can rename multiple worksheets much easier.

Rename multiple worksheets with specific data
Rename multiple worksheets with selected cell values
Rename multiple worksheets with specific cell value in each worksheet of active workbook


Click Kutools Plus >> Worksheet >> Rename Worksheets. See screenshot:

shot-rename-multiple-sheets-1


Rename multiple worksheets with specific data

With this utility, you can easily rename the worksheets with a specific value which you can put it before or after the original worksheets name, also you can replace the original with the specific value. Do as follows:

1. Apply this utility by clicking Kutools Plus > Worksheet > Rename Worksheets.

2. Go to the Rename Multiple Worksheets dialog box, in the Worksheets list box, specify the worksheets which you want to rename, and input the specific value into the From an input box. And then select one type which you want to rename the worksheets under Rename Options.

shot-rename-multiple-sheets-2

3. Click OK. The worksheet name has been renamed. See screenshots:

shot-rename-multiple-sheets-13


Rename multiple worksheets with selected cell values

If you have a range of cell values, and now you need to rename the worksheet name with the cell values, you can do as this:

1. Select the range of cell values that you want to use.

2. Go to the Rename Multiple Worksheets dialog box, in the Worksheets list box, specify the worksheets which you want to rename. And select one type which you want to rename the worksheets under Rename Options, then select From specific range option.

shot-rename-multiple-sheets-3

3. Click OK. The worksheet name has been renamed. See screenshots:

shot-rename-multiple-sheets-14


Rename multiple worksheets with specific cell value in each worksheet of active workbook

If there are cell values in cell A1 of each worksheet within the current workbook, now, you want to rename the worksheets by using the cell value A1 of each worksheet, don’t worry, the Rename Worksheets feature also can do you a favor.

1. Click the cell value which you want to rename the worksheets by using.

2. Go to the Rename Multiple Worksheets dialog box, in the Worksheets list box, specify the worksheets which you want to rename. And select one type which you want to rename the worksheets under Rename Options, then select Rename worksheets with specific cell option.

shot-rename-multiple-sheets-4

3. Then click OK, the worksheets have been renamed as follows:

shot-rename-multiple-sheets-15


Notes:

1. This utility supports Undo.

2. If the worksheet name contains one or more invalid characters, either to input the worksheet name from input box or range, this tool will fail to process the rename operation.

3. By using this feature, you can also filter some certain worksheets that you want to rename only, such as only the worksheet names begins with Ja, in the Rename Multiple Worksheets dialog box, check Filter option, and then enter Ja, and only the worksheets which names begin with Ja are listed in the Worksheets list box, and then you can rename them as above steps.

shot-rename-multiple-sheets-5


Demo: Quickly rename multiple worksheets in Excel

 
Kutools for Excel: Over 300 handy tools at your fingertips! Enjoy permanently free AI features! Download Now!

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs β€” no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages
βœ… Trusted by 500,000+ users and 80,000+ businesses worldwide
πŸš€ Compatible with all modern Excel versions
🎁 30-day full-featured trial β€” no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon