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

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.

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

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

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

##7. Click "Run Subprocess" in "Run" in the menu bar.

10. At this time You will find that the original worksheet names have been renamed in batches.

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!