How to make sheet tab name equal to cell value in Excel?

Sometimes, you may need to rename a worksheet to match a specific cell value. In this article, we will show you methods of making sheet tab name equal to cell value in Excel.

Make sheet tab name equal to cell value with VBA code
Make sheet tab name equal to cell value with Kutools for Excel

Make sheet tab name equal to cell value with VBA code

With the following VBA code, you can make sheet tab name equal to cell value automatically.

1. Right click the sheet tab which you want to make the sheet name equal to cell value, then click "View Code" from the right-clicking menu. See screenshot:

2. Copy and paste below code into the Code window, and then press "Alt" + "Q" keys simultaneously to close the Microsoft Visual Basic for Applications window.

VBA code: Make sheet tab equal to cell value

Private Sub Worksheet_Change(ByVal Target As Range)
'Updated by Extendoffice 20230130
    On Error Resume Next
    If Not Intersect(Target, Range("A1")) Is Nothing Then
        ActiveSheet.Name = ActiveSheet.Range("A1")
    ElseIf Not Intersect(Target.Dependents, Range("A1")) Then
        ActiveSheet.Name = ActiveSheet.Range("A1")
    End If
End Sub

Note: In the code, A1 is the cell which contains the value you need to use as sheet name. You can change it as you need.

From now on, when the value in cell A1 changes, the sheet tab name will automatically update to match it.

Make sheet tab name equal to cell value with Kutools for Excel

In this section, we introduce you the "Rename Multiple Worksheets" utility of "Kutools for Excel". With this utility, you can easily rename worksheets based on the value of specific cells in Excel.

1. Click "Kutools Plus "> "Worksheet" > "Rename Multiple Worksheets". See screenshot:

2. In the "Rename Multiple Worksheets" dialog box, you need to do as follows.

You can see the selected worksheets are renamed by the specified range value immediately as below screenshot shown.

Notes:

Make sheet tab name equal to cell value with Kutools for Excel