Module"; 5. Enter the rename command in the pop-up window; 6. Click "Run Subprocess" in the running window."/> Module"; 5. Enter the rename command in the pop-up window; 6. Click "Run Subprocess" in the running window.">

Home  >  Article  >  Topics  >  How to batch rename subscripted sheets in Excel?

How to batch rename subscripted sheets in Excel?

烟雨青岚
烟雨青岚Original
2020-06-20 10:18:397738browse

How to batch rename subscripted sheets in Excel?

#How to batch rename subscript sheets in Excel?

Steps:

1. First open the Excel document that needs to be edited, and then click the New Worksheet button to create a new worksheet

How to batch rename subscripted sheets in Excel?

2. Enter the title in A1 of the newly created worksheet, enter the new name of the worksheet starting from A2, and enter it downwards in sequence.

How to batch rename subscripted sheets in Excel?

3. Press the key combination "Alt F11"——>Open the VBA window;

How to batch rename subscripted sheets in Excel?

##5. Click the "Insert" menu——>Select "Module" in the drop-down option;

How to batch rename subscripted sheets in Excel?

6. Next, enter the code

Sub 重命名()
Dim i&
For i = 2 To Sheets.Count
    Sheets(i).Name = Sheets(1).Cells(i, 1)
Next
End Sub
# in the window that opens

How to batch rename subscripted sheets in Excel?##7. Click "Run Subprocess" in "Run" in the menu bar.


How to batch rename subscripted sheets in Excel?10. At this time You will find that the original worksheet names have been renamed in batches.

How to batch rename subscripted sheets in Excel? Recommended tutorial: "

excel tutorial

"

The above is the detailed content of How to batch rename subscripted sheets in Excel?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn