How to Rename Sheet in Excel (6 Easy and Quick Methods)

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.

Rename Excel Sheets with Simple Double Click

  • 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.

Use Simple Right Click to Rename Excel Sheet


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.

Rename Sheets Using Format Option of Home Tab


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:
ALT + O + H + R
  • 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.

5. Use Accessibility Menu to Rename Sheet 

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. 

Use Accessibility Menu to Rename Sheet 

  • 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.

Rename Excel Sheet Using VBA

  • 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

Rename Excel Sheet Using VBA

  • 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

Hosne Ara

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo