Log in
x
or
x
x
Register
x

or
0
0
0
s2sdefault

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


Click Enterprise >> Worksheet >> Rename Worksheets. See screenshot:


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 Enterprise > 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 200 Advanced Functions for Excel 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

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

Designed for Excel(Office) 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 months 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.