Header Ads

Microsoft Excel Tutorial: How To Rename A Worksheet

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 to understand formula that contain 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 hot keys

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 Tutorial How To Rename A Worksheet1
Microsoft Excel Home Tab



Microsoft Excel Tutorial How To Rename A Worksheet2
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 pn 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 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 Cttrl + P Up to move to the sheet on the left or right.
  2. Press this keyboard Hot keys 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 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

Microsoft Excel Tutorial How To Rename A Workshee4
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

Microsoft Excel Tutorial How To Rename A Workshee6
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.).

7 comments:

Olukoya said...

Thank you a lot. I have being trying to do this for a long time,but I came across this site today.This post is very simple and easy to understand.I will be looking forward to seeing another related tutorials from you,especially simple one for a basic learner like me.I want to know how to insert/create and delete a worksheet using different methods.

Bunmi Are said...

I will not let you. Very soon you will get all the tutorials you have requested for. Thank you.

shohan tim said...

this is good but need more information like this tutorial this is really good tutorial you can see and you can also add this tutorial in your blog.
An absolute URL: excel tutorial
A relative URL: microsoft tips

Bunmi Are said...

shohan tim, thank you for the comment. I will keep you updated on the improved article on the same topic.

E-mon the money-key said...

this is good but need more information like this tutorial this is really good tutorial you can see and you can also add this tutorial in your blog.
An absolute URL: excel tutorial
A relative URL: microsoft tips

christyjames said...

Well said, Microsoft Office Word and Excel have their own distinct advantages. There are people out there like me that keep track of users through templates!
Business templates | Excel templates

Bunmi Are said...

You are welcome.Thank you for the comment.

Powered by Blogger.