And when working with multiple sheets, you may sometimes need to change their names. In this Excel tutorial, I will show you some simple ways to rename a sheet in Excel (including a keyboard shortcut). And in case you want to rename all the sheets as one go (such as adding a prefix or suffix to all the sheets), check out the section on using VBA to do this (it’s not complicated). So let’s get started!
Rename Sheets with a Simple Double Click
Using a mouse is the easiest way to change the name of a sheet in Excel. Below are the steps to rename a sheet using the mouse double-click:
If you want to rename multiple sheets, you need to do these above steps for all the sheets. Also, if you want to add a prefix/suffix to the sheet name, you the arrow keys to move the cursor when you’re in the edit mode in the tab. Once you have the cursor where you want to add the text, enter in manually.
Rename Sheets with a Keyboard Shortcut
If you prefer using the keyboard and don’t want to switch to a mouse just to rename a sheet, you can also use the following keyboard shortcut (for Windows). You need to press these keys one after the other in a succession. While this is not one of the easy keyboard shortcuts, once you get used to it, you may find it a better way to rename sheets in Excel.
Rename Sheets Using the Format Option in the Ribbon
You can also access the option to rename sheets through the Excel ribbon: This method would only allow you to change the name of the current sheet. To change the name of some other sheet, you first need to activate it and then use the above steps. While this method exists, I always prefer using the mouse double-click technique to change the name of the sheet.
Rename Sheets Using VBA – Add Prefix/Suffix to All Sheet Names in One Go
Sometimes, you may have a need to add a prefix or a suffix to all the sheets in your workbook. While you can do this manually (using the methods shown above) if you only have a few worksheets. But in case you have a lot many, this could be tedious and error-prone. In such a case, you can use a simple VBA code in the immediate window to get this done in a snap. Below is the VBA code that will add the prefix “2020 – ‘ in front of all the sheet names: The above code uses a VBA loop (the For Next loop) to go through each sheet in the workbook and change the name by adding the specified prefix. Below are the steps to use this VBA macro code in Excel: As soon as you hit the Enter key, the code is executed and it adds the specified prefix in all the sheet names. Note that this will rename all the sheets – visible as well as hidden. Similarly, if you want to add a suffix to all the sheet names, you can use the below code: You can even go a step further and also change the name of some specific sheets (let’s say only the ones where the text 2020 appears). This can easily be done by editing the code.
Sheet Naming Rules in Excel
When renaming a sheet in Excel, there are some naming rules you need to follow: I hope you found this Excel tutorial useful. You may also like the following Excel tips and tutorials:
How to Unhide Sheets in Excel (All In One Go) How to Get the Sheet Name in Excel? How to Sort Worksheets in Excel using VBA (alphabetically) Combine Data From Multiple Worksheets into a Single Worksheet in Excel How to Compare Two Excel Sheets Count Sheets in Excel (using VBA) How to Change the Color of the Sheet Tab in Excel
