How to Rename Multiple Worksheets in Excel Office 365?
Tags: kutoolsexceltutorial, renamemultipleworksh, kutools
Published: 2020-11-24 09:27:53

---
title: How to Rename Multiple Worksheets in Excel Office 365?
published: true
date: 2020-11-24 06:11:16 UTC
tags: KutoolsExcelTutorial,RenameMultipleWorksh,Kutools
canonical_url: https://geekexcel.com/how-to-rename-multiple-worksheets-in-excel-office-365/
---

Here we come up with the simple instructions to **Rename Multiple Worksheets in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Rename Multiple Worksheets with Specific Data:

If you want to rename multiple worksheets with specific data in Excel, do as follows.

- [Open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that contains multiple worksheets.

![Multiple Worksheets](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-35.png)<figcaption id="caption-attachment-17962">Multiple Worksheets</figcaption>

- Go to the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Rename Worksheets** option from the menu.

![Select Rename Worksheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Rename-Worksheets-option.png)<figcaption id="caption-attachment-17958">Select Rename Worksheets option</figcaption>

- It will open the **Rename Multiple Worksheets Dialog Box**.
- **Worksheets list box –** You need to **select** the **worksheets** that you want to rename.
- **Rename Options –** Here, you need to **select one type** that you want to rename the worksheets. We **choose** the **Insert before original sheet name** option.
- **From an input box –** You need to enter the specific value that you want to insert.

![Rename Multiple Worksheets Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-41.png)<figcaption id="caption-attachment-17959">Rename Multiple Worksheets Dialog Box</figcaption>

- Finally, **hit** the **OK** button. It will open a prompt box to tell you how many worksheets have been renamed.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-40.png)<figcaption id="caption-attachment-17960">Prompt box</figcaption>

- **Click OK** to close the prompt box.
- You can see that the worksheet name has been renamed as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-39.png)<figcaption id="caption-attachment-17961">Result</figcaption>

## Steps to Rename Multiple Worksheets with Selected Cell Values:

To rename multiple worksheets with the selected cell values in Excel, follow the below steps.

- First, you need to **select the range of cell values** that you want to use.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-30.png)<figcaption id="caption-attachment-17963">Select a range</figcaption>

- On the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Rename Worksheets** option from the menu.

![Select Rename Worksheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Rename-Worksheets-option.png)<figcaption id="caption-attachment-17958">Select Rename Worksheets option</figcaption>

- It will display the **Rename Multiple Worksheets Dialog Box**.
- **Worksheets list box –** You need to **select** the **worksheets** that you want to rename.
- **Rename Options –** Here, you need to **select one type** that you want to rename the worksheets. We **choose** the **Insert before original sheet name** option.
- **From specific range –** you need to select the range using the given browse button.

![Rename Multiple Worksheets Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-28.png)<figcaption id="caption-attachment-17964">Rename Multiple Worksheets Dialog Box</figcaption>

- Then, **click** the **OK** button.
- It will display a **prompt box** to show you how many sheets are renamed. **Click OK** to close the prompt box.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-26.png)<figcaption id="caption-attachment-17965">Prompt box</figcaption>

- At last, you will see the renamed worksheets as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-25.png)<figcaption id="caption-attachment-17966">Output</figcaption>

## Rename Multiple Worksheets with Specific Cell Value in Each Worksheet:

You can also rename multiple worksheets with specific cell values in each worksheet of the current workbook. To do this, you need to follow the below steps.

- You need to **click** a **cell value** that you want to use for renaming worksheets.

![Click a cell value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-22.png)<figcaption id="caption-attachment-17970">Click a cell value</figcaption>

- Then, go to the **Kutools Plus Tab, select** the **Worksheet** option, then **choose** the **Rename Worksheets** option from the menu.

![Select Rename Worksheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Rename-Worksheets-option.png)<figcaption id="caption-attachment-17958">Select Rename Worksheets option</figcaption>

- It will open the **Rename Multiple Worksheets Dialog Box**.
- **Worksheets list box –** You need to **select** the **worksheets** that you want to rename.
- **Rename Options –** Here, you need to **select one type** that you want to rename the worksheets. We **choose** the **Insert after original sheet name** option.
- **Rename worksheets with specific cell – **** Select **the** specific cell** with the help of the browse button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-19.png)<figcaption id="caption-attachment-17972">Click OK button</figcaption>

- After that, you need to **click** the **OK** button to get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-13.png)<figcaption id="caption-attachment-17973">Output</figcaption>

## Summary:

In this article, you can easily understand the steps to **Rename Multiple Worksheets in Excel Office 365** using **Kutools** with examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Configure Cells to be Locked or Unlocked When Protecting Worksheet!!](https://geekexcel.com/configure-cells-to-be-locked-or-unlocked-when-protecting-worksheet/)
- [How to Insert a Monthly or a Yearly Calendar in Excel Office 365?](https://geekexcel.com/how-to-insert-a-monthly-or-a-yearly-calendar-in-excel-office-365/)