How to rename sheet in Excel using formula

While working in Excel, often we have to rename a sheet. Properly named and organized worksheets are important for the look of the spreadsheet. In this article, we will discuss some easy and quick methods to rename sheets in Excel. Besides, we will show renaming sheets using VBA.

Download Excel Workbook

1. Rename Excel Sheets with Simple Double Click

The easiest way to rename Excel sheets is with a simple double click. The steps involved are:

📌 Steps:

• Just double-click the regarding sheet you want to change.

• Press Enter after you type the desired sheet name and get the following renamed sheet:

Read More: How to Search Sheet Name in Excel Workbook (2 Methods)

2. Use Simple Right Click to Rename Excel Sheet

Another quick way to rename an Excel sheet is the use of mouse right-click. Here are the steps involved:

📌 Steps:

• Put the mouse cursor on the regarding sheet name and right-click. Upon clicking, Rename option will appear, click it.
• Rename the sheet as you want and press Enter.

3. Rename Sheets Using Format Option of Home Tab

Till now, we have discussed the most common ways to rename Excel sheets. However, there are some other ways to do the task. For example, you can use Excel Ribbons for renaming. Following are the steps associated:

📌 Steps:

• Select the sheet you want to rename.
• Go to Home > Cells Group > Format.
• Click the Rename Sheet option from Format, it will bring the cursor to the sheet name.
• Finally, rename the sheet and press Enter.

4. Use Keyboard Shortcut to Rename Sheet

If you want to use only the keyboard to rename the Excel sheet then keyboards shortcuts can be used. Here are the steps you will require:

📌 Steps:

• We will use the combination of these keys:

• Pressing the Alt key will show up the shortcuts. You will have to press keys one after another.
• Rename the sheet as you want and press Enter.

We can rename excel sheets from Check Accessibility. But, by using this method you can only rename sheets that are not renamed before. The following steps are used for this method:

📌 Steps:

• Firstly, go to the Review tab from the ribbon.
• Then, click Check Accessibility > Check Accessibility. 

• The Accessibility window will open up.
• Expand Default Sheet Names.
• Click the sheet name and select Rename Sheet from the drop-down.
• Lastly, rename the sheet and press Enter.

6. Rename Excel Sheet Using VBA

If you do not want to use traditional ways to rename Excel sheets, renaming using VBA might be an option. The steps involved in this method are:

📌 Steps:

• First, go to the sheet you want to rename.
• Right-click and select the View Code option.

• Then, use the following code in the code window.

Option Explicit
Sub rename_sheet()

Dim Sheet As Worksheet
Set Sheet = Worksheets("Sheet2")
Sheet.Name = "Records"

End Sub

• Run the code, you will get the sheet renamed “Records”.

Read More: Use Excel Sheet Name From Cell Value (Three Ways)

Conclusion

In the above discussion, we have explained most of the easy and quick sheet rename methods in Excel. Hopefully, these methods will be sufficient enough to rename sheets when necessary. Let us know if you have any questions or recommendations.

Related Articles

• Apply Sheet Name Code in Footer in Excel (3 Ways)
• How to Search Sheet Name with VBA in Excel (3 Examples)
• Select Sheet by Variable Name with VBA in Excel (2 Ways)
• How to Use Sheet Name Code in Excel (4 Applications)
• List Sheet Name in Excel (5 Methods + VBA)
• How to Get Excel Sheet Name (2 Methods)