A basic task in Excel: Renaming worksheets. Just changing the name is quite simple. But what if you have to do it for dozens of sheets? And what rules are there for worksheet names? What character can you use? In this article we’ll have a close look at how to rename Excel worksheets.
Changing a worksheet name in Excel is quite straight forward. There are actually three ways:
Double click on the sheet name and type a new name.
Right click and the sheet name and click on ‘Rename’.
For Mac users: Click on ‘Format’ in the Mac menu bar. Next click on Sheet and then on ‘Rename’.
Rename worksheets with keyboard shortcuts
But what do you do, if you have to rename several worksheets in Excel? Renaming a worksheet can be troublesome, especially when you have to double-click on each sheet name separately. There is a keyboard shortcut (on Windows):
Press these keys on your keyboard one after another:
–> –> –> .
With a little bit of practice, you can save some time. Especially as you don’t have to grab the mouse.
There is another related keyboard which might help you in this context. Insert new worksheets:
+ + .
Hold on a second. Was this information helpful so far?
Connect with me on LinkedIn...
Boost your Excel skills: Learn the best Excel tricks and tutorials!
There are some general requirements for worksheet names:
The sheet names can not have more than 31 characters.
A worksheet name must be unique, there can’t be two sheets with the same name.
You can’t leave the name blank. There must at least be one character. But you can use just a space character.
You can’t use the name ‘History’ as Excel needs this for the Track Changes function.
There are certain characters you are not allowed to use (see next chapter).
Characters you can’t use in worksheet names
Error message when you try to use a character in worksheet names, which is not allowed.
You can’t use any of the following character. In newer versions of Excel you can’t even type these character. In older version, you’ll get an error message similar to the one on the right hand side.
:
\
/
?
*
[
]
That’s it for the strict conditions of worksheet names in Excel. However, there are some more recommendations for worksheet names.
Recommendations and best practice
General recommendations
Let’s start with some obvious recommendations:
Use consistent naming. E.g. let all input data sheet names begin with “Input_” (“Input_ERP_2016”).
Make sheet names self-explanatory. E.g. don’t just call it “Sheet1” but better “Calculation_of_szenarios”.
Therefore we recommend using complete words and prepositions (“of”) if it makes it easier to understand the file.
Admittedly, a little bit contradicting: Keep worksheet names short wherever possible. Especially for large Excel files it’s nice to see as many sheet tabs as possible at the same time.
The workbook structure should be consistent and easy to understand. Use proper names reflecting the structure.
Characters you should not use in worksheet names
Many special characters (here: “-“) in worksheet names create single quotation marks around the worksheet name.
We usually advise not to use character as spaces or special characters as ‘!’, ‘%’ or ‘-‘. The reason is, that if you link to a sheet with such name, Excel will insert single quotation marks. Formulas like INDIRECT will be more difficult to create. So why not omit such character from the beginning?
– (minus)
,
!
“
$
%
&
(
)
=
`
+
#
@
{
}
(space)
~
|
<
¢
^
Special characters that don’t generate single quotation marks
There are characters in worksheets names which don’t generate single quotation marks (here: _ (underscore)).
You really want to use special characters for worksheet names in Excel? What about the following one? Any of them suitable for you? The advantage of these characters: They don’t require or add the single quotation mark.
_
.
§
¡
¶
≠
¿
±
‘
– (en dash)
∞
≤
°
…
Summary
Renaming Excel worksheets is simple. Every Excel user has to deal with it. But there are some strict rules and requirements. Furthermore there are recommendations which should simplify your work in Excel.
Professor Excel is a fictional person with one passion: Microsoft Excel. He is devoted to pass on his vast experience and help all future generations to excel in Excel!
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Yes, I want to be an Excel expert!
Subscribe to our popular Excel newsletter! You get all this:
Excel tips, tricks and tutorials. 1x per month. No spam. Promised.