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 Kutools Plus >> 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 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.

  Demo: quickly rename multiple worksheets in Excel

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.