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
Note: kutools for Excel 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 that contains multiple worksheets.
- Go to the Kutools Plus Tab, select the Worksheet option, then choose the Rename Worksheets option from the menu.
- 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.
- Finally, hit the OK button. It will open a prompt box to tell you how many worksheets have been renamed.
- Click OK to close the prompt box.
- You can see that the worksheet name has been renamed as shown in the below image.
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.
- On the Kutools Plus Tab, select the Worksheet option, then choose the Rename Worksheets option from the menu.
- 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.
- 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.
- At last, you will see the renamed worksheets as shown in the below screenshot.
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.
- Then, go to the Kutools Plus Tab, select the Worksheet option, then choose the Rename Worksheets option from the menu.
- 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.
- After that, you need to click the OK button to get the result as shown in the below image.
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. Keep Learning!
Top comments (0)