Rename an Excel worksheet
How to rename a single Excel worksheet using Excel, VBA and Shortcut methods
| 1. Double-click on the worksheet that you want to rename. Note: in this example we are renaming Sheet2. |
 |
| 2. Enter the name of the worksheet that you want to rename it to and press the Enter key. Note: in this example we are renaming from Sheet2 to Data. |
 |
METHOD 2. Rename an Excel worksheet using the sheet option
EXCEL
| 1. Right-click on the worksheet that you want to rename. Note: in this example we are renaming Sheet2. 2. Click Rename. |
 |
| 3. Enter the name of the worksheet that you want to rename it to and press the Enter key. Note: in this example we are renaming from Sheet2 to Data. |
|
METHOD 3. Rename an Excel worksheet using the ribbon option
EXCEL
| 1. Select the worksheet that you want to rename. Note: in this example we will be renaming Sheet2. |
 |
| 2. Select the Home tab. |  |
| 3. Click Format in the Cells group. 4. Click Rename Sheet. |
 |
| 5. Enter the name of the worksheet that you want to rename it to and press the Enter key. Note: in this example we are renaming from Sheet2 to Data. |
|
Dim ws As Worksheet
ws.Name = "Data"
End Sub
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Worksheet Name: Have a worksheet named Sheet2.
ADJUSTABLE PARAMETERS
Worksheet Selection: Select the worksheet that you want to rename by changing the Sheet2 worksheet name in the VBA code to any worksheet in the workbook.
Rename Worksheet: Rename a worksheet to any name, within Excel limits, by changing the Data worksheet name in the VBA code.
METHOD 2. Rename an Excel worksheet from a list using VBA
VBA
Dim ws As Worksheet
Set wsname = Worksheets("Parameters").Range("C2")
ws.Name = wsname.Value
End Sub
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
Worksheets Names: Have two worksheets named Sheet2 and Parameters.
Minimum Number of Worksheets: Have at least two worksheets, named Sheet2 and Parameters.
Rename Worksheet: Cell C2 in the Parameters worksheet needs to be populated with the name that you want to rename a worksheet to.
ADJUSTABLE PARAMETERS
Worksheet Selection: Select the worksheet where you hold the new worksheet name by changing the Parameters worksheet name in the VBA code.
Worksheet Selection: Select the worksheet that you want to rename by changing the Sheet2 worksheet name in the VBA code to any worksheet in the workbook.
NOTES
Select the worksheet you want to rename, then action the shortcut. The shortcut will highlight the name of an active worksheet and you can then rename the worksheet.
This tutorial explains and provides step by step instructions on how to rename a single worksheet using Excel, VBA and Shortcut methods.
Excel Methods: Using Excel you can rename a worksheet with a ribbon option, sheet option or double-clicking on the worksheet you want to rename.
VBA Methods: Using VBA you can rename a worksheet by directly entering the name that you want to rename the worksheet to or by referencing to a cell that holds the name that you want to rename a worksheet to.
Shortcut Method: Using a Shortcut you can highlight the name of an active worksheet and you can then rename the worksheet.