Microsoft Excel Tutorial: How To Rename A Worksheet

Microsoft Excel Screen

Microsoft Excel Tutorial: How To Rename A Worksheet

In this Microsoft excel tutorial, I am going to be showing you how to rename a worksheet in excel. Worksheet can be renamed using different methods, and in this tutorial, you learn how to use all the methods. Renaming worksheet makes it easier to keep track of individual sheets in a very complex workbook and that it makes one understand the formula that contains multiple worksheets in a particular project. All the four ways of renaming excel worksheet will be categorized into two, the first is using the Ribbon and the second is using the worksheet tab.

What you will learn in this tutorial is outlined here:

Also Read:
How To Move Around In Microsoft Excel Worksheet
Microsoft Excel Tutorials For Beginners-Introduction

Renaming Excel Worksheet With The Ribbon

1. Using the     mousse
2. Using the hotkeys

Renaming Excel Worksheet Using The Worksheet Tab

1. By right-clicking the worksheet tab
2. By double-clicking the worksheet tab

To Rename Excel Worksheet Using The Ribbon

Method one: using the mouse:

Microsoft Excel Home Tab

Select Rename Sheet

1. Click on the tab of the worksheet you want to rename
2. Click on the  Home tab
3. Select  Format option, a drop-down menu opens
4. Click on Rename sheet to highlight the worksheet
5. Type any name for the worksheet
6. Press Enter key to effect the Renaming

Method two: using the Hot Keys

With this method, you will use a combination of keys to carry out this task. To use this method, make sure Num Lock key is turned off so that the key combination will work as we want.

1. Press Ctrl + Pg Dn or Ctrl + P Up to move to the sheet on the left or right.
2. Press this keyboard Hotkeys Alt + H to display the shortcuts for Home tab elements.
3. Enter letter O to open the Format drop-down menu. Then, select Rename from the list.
4. Type the new name for the worksheet.
5. Press Enter key to effect the Renaming of the worksheet.

NOTE: This method is used by excel expert because it makes use of the only keyboard in a situation where there is no mouse.

Renaming Excel Worksheet By Using Worksheet Tab

Method 1 : By right-clicking on the worksheet tab

Right-click On The Sheet Name

1. Right-click on the tab of the worksheet to be renamed.
2. From the context menu, select Rename to highlight the selected worksheet.
3. Type the required name for the worksheet.
4. Press Enter to effect the change.

Method 2: By double-clicking on the worksheet tab

Double-click On The Sheet Name

1. Double-click on the tab of the worksheet to be renamed.
2. Type the name you want.
3. Press Enter to effect the renaming.

Conclusion

It is very important to note that Microsoft excel does not accept any just pattern or manner of writing worksheet name, there are a few restrictions and rules you must follow when naming a worksheet. Your worksheet name cannot be left blank, name cannot be more than 31 characters, certain characters and symbols are not allow(for example characters like ?,{,],;,/,\,etc.).