Method 1: Open the excel table and find the following worksheet columns: sheet 1, sheet2 and sheet3. Select the worksheet to be renamed, such as sheet 1, and click the "Format → Worksheet → Rename" command. At this point, the name on the worksheet tab will be highlighted, and then enter a new table name on the tab.

Method 2, or you can rename the worksheet label by double-clicking it directly. Note that we name worksheets in excel according to the naming rules: English is case-insensitive.

So how to rename worksheets in batch in excel?

In fact, we need VBA code to realize it. Let's take a simple case for example. For example, we have dozens of worksheets, and now I want to rename these dozens of worksheets to 1, 2, 3 ... in the current order. What is the VBA code entered?

Child XXX ()

DIM I

For I= 1 to Zhang. count

Sheets (1). NAME=I

Next, I

End joint

Enter the VBA code above to rename the worksheet in batches.