How to Rename Sheet in Excel

HomeExcel BasicsHow to Rename Sheet in Excel

In Excel, there are multiple ways to rename a sheet, and, in this tutorial, we are going to learn all these methods.

Rename a Sheet from Option Menu

The default way to rename a sheet is to use the right-click options menu. See the steps below:

rename-sheet-from-option-menu
  1. First, activate the sheet that you want to rename.
  2. Next, right click on the sheet tab.
  3. After that, click on “Rename” option from the list of options.
  4. Now, delete the old name and type the new name that you want to fix.
  5. In the end, hit enter.

Keyboard Shortcut to Rename a Sheet

There is also a keyboard shortcut that you can use to rename a sheet in Excel. To use this keyboard shortcut, you first need to activate the sheet that you want to rename and after that, press the following keys:

Alt ⇢ H ⇢ O ⇢ R

keyboard-shortcut-to-rename-sheet

When you press this shortcut key it edits the name of the sheet and then you can enter the new name that you want to specify and then hit enter.

Double Click of Rename a Sheet

You can also use a double click with the mouse to edit the name of the sheet and then rename it later.

  1. First, activate the sheet that you want to rename.
  2. Double click on the sheet tab to edit it.
  3. Delete the old name that you already there.
  4. Type the new name then hit enter.

Using the Format Options

In the same way, you can rename a worksheet using the format option from the ribbon.

rename-sheet-using-format-option
  • First, go to the home tab and locate the format options drop down.
  • Next, click on the drop down to get the list of options there.
  • After that, click on the “Rename Sheet” option to edit the name of the sheet.
  • In the end, enter the new name and hit enter.

Just like all the other methods you need to activate the sheet first to use this method.

Note: You can also use VBA to rename a sheet.

Rules You Need to Know (Naming a Sheet)

There are a few rules that you need to take care of while renaming a sheet.

  1. You can name two different sheets with the same name.
  2. A sheet name can’t be a blank value.
  3. Maximum 31 characters can be used is the name of a sheet.
  4. An apostrophe (‘) can’t be used in the start and end of the name but can used in the somewhere at middle.
  5. There’s are some characters that can’t be used in the name, like, [ ] \ / ? : *
  6. You can’t use the word “History” as the name of a sheet, that’s reserved by Excel.