See all How-To Articles

How to Rename a Worksheet in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on April 14, 2023

This tutorial demonstrates how to rename a worksheet in Excel and Google Sheets.

 

rename sheet 3

 

Rename a Worksheet in Excel

There are a few easy ways to manually change a worksheet name in Excel.

Note: To learn how to use VBA to rename worksheets with a macro, see VBA Get Sheet Name or Rename Sheet.

Use the Ribbon to Rename a Sheet

  1. To rename a worksheet, in the Ribbon go to Home > Format > Rename Sheet.

 

rename sheet 7

 

  1. After that, the sheet name is in edit mode. Type in the new name for your worksheet in the bottom-left corner of the Excel file.

 

rename sheet 5

 

  1. When you’re done, just press ENTER or click anywhere in the worksheet, and your worksheet is renamed.

 

rename sheet 6

 

Right-Click to Rename a Sheet

  1. To rename a worksheet, rest the cursor on the sheet name in the bottom-left corner of the Excel window, right-click on the name, and choose Rename from the menu.

 

rename sheet 1

 

  1. The sheet name goes into edit mode. Type in the new name and press ENTER.

 

rename sheet 5

 

As a result, you have a sheet with a new name.

 

rename sheet 6

 

Double-Click to Rename a Sheet

Another way to rename a worksheet is to put the cursor on the original sheet name, double-click it, and then enter a new name.

 

rename sheet 4

 

As a result, you have a worksheet with a different name.

 

rename sheet 6

 

Use a Keyboard Shortcut to Rename a Sheet

If you prefer using the keyboard, you could change the name of the sheet with a shortcut. To do that, press ALT + O > H > R (one after the other).

Rename a Worksheet in Google Sheets

Easy Excel Automation

Add Excel automation to your workbook with just a few clicks.

Learn More

Right-Click

  1. In the bottom-left corner, right-click on the sheet name (or click on the arrow next to the sheet name), and choose Rename from the menu.

 

rename sheet 8

 

  1. That takes the sheet name into edit mode. Type in a new name for the worksheet and press ENTER.

 

rename sheet 9

 

Now the sheet displays a new name (here, Annual Report).

 

rename sheet 12

 

Double-Click

Alternatively, place the cursor on the sheet name and double-click it. This brings you to edit mode, so see Step 2 above.

 

rename sheet 13

 

The result is the same as with right-clicking.

 

rename sheet 11

 

Tips

  • It’s particularly helpful to name new worksheets you add to your file so they are easy to read and organize.
  • Renaming files is also great for version control and identifying files in a folder quickly.
  • You can view a list of worksheets with their new names. For files with several tabs, having descriptive names for each sheet makes navigating the file easier; you can see what you need from the list instead of clicking into each sheet (Sheet1, Sheet2, Sheet3, etc.) with an autogenerated name.

See all How-To Articles