Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Quickly rename multiple worksheets in Excel

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

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words...
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum...
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns...
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Create Mailing List and Send Emails by Cell's Value...
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

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

shot rename multiple sheets 001


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.

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


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.

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


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.

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


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.



Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    jonathan · 2 years ago
    I use, Batch Rename Files Tool. You can easily found hier BatchRenameFiles.org
    that allows you to quickly rename all the files in a specified directory.