How to Rename a Sheet in Excel: Step-by-Step Guide (2024)

An Excel workbook has a maximum of 1,048,576 sheets!

Right, we all (or most of us) know that. But let’s say you have added tens of sheets to your book. Now how can you distinguish them🤔

By name. The tutorial below will teach you how to rename sheets in Excel. So let’s dive in straight now.

Rename sheet tab

Here is an Excel file with three sheets to it.

Whenever you add a new sheet to Excel, it is named “Sheet + the next serial number” by default.

So we have Sheet1, Sheet2, and Sheet3 in our workbook here. Let’s begin renaming them.

Here we go🚀

We are renaming Sheet 1 right now.

You’d see a context menu of options launches.

We are setting the name of the sheet to Spreadsheeto. You can set it to anything✍

There you go! The sheet is now renamed as Spreadsheeto. That was easy💪

You cannot name multiple sheets in Excel by the same name. That also means that you cannot rename multiple sheets (or all the sheets) simultaneously.

Kasper Langmann, Microsoft Office Specialist

For example, if I try to rename Sheet2 as Spreadsheeto too, Excel will raise the following prompt🚩

Pro Tip!

The keyboard shortcut to rename sheets in Excel is as follows:

Press the Alt Key > H > O > R

Hope you enjoyed and found renaming sheets in Microsoft Excel easy. It’s only a matter of a few clicks.

With this, let me tell you there’s so much more that you can do in Excel using the features, tools, and functions offered by Excel✌

The VLOOKUP, SUMIF, and IF functions are some of the most dynamic functions of Excel that’ll help you work out big datasets.

Or if you no longer need those sheets, just delete them. Learn to hide and delete sheets in Excel in our blog here.

I'm the co-founder of Spreadsheeto, a certified Microsoft Office Specialist, and a Microsoft MVP.

With over 10 years of experience, I’ve taught Excel to millions of people worldwide.

I spent over 5 hours researching and writing this tutorial.

Last updated on August 28th, 2024.