How to Add New Worksheets with Customized Names in Excel?

The data storage, organisation, and manipulation capabilities of Microsoft Excel are the primary motivations for the software's creation and development. Excel Worksheet plays an important part by providing many features to alleviate the laborious process of managing data. Read through this tutorial to find out how you can add new worksheets in Excel with customized names.

Follow the steps given below.

Step 1

When you first launch Microsoft Excel, you are presented with a menu that gives you the choice between a number of different worksheets, as is seen below.

Step 2

You have the option of picking one that corresponds to the prerequisites. Make a blank worksheet for the time being. The blank worksheet appears as shown down below.

Step 3

It is possible that you may get into a position in which you will need to append an additional worksheet to the side of the one that is already there. Excel Workbooks are collections of Excel worksheets that are kept together in one location. Right-clicking on the sheet name in the bottom sheet tracker tray allows you to insert a new worksheet into the document. This is shown in the following image.

Step 4

Create a new worksheet like the one shown below by choosing the "new worksheet" option from the list of choices that are now accessible to you.

Step 5

You will see a new dialogue box emerge on the screen, in which you will have the opportunity to pick the option to add a new sheet.

Step 6

You can give the Excel Worksheet a new name by right-clicking on the sheet's name and choosing the rename option from the dialogue box, as is shown in the following image.

You are free to rename this sheet, for example Sheet1, to anything you would like.

Sheet1 will be renamed as "New Sheet", as shown in the following image.

Step 7

If you want to get rid of the Excel Worksheet, you have to right-click on the worksheet tab and choose the delete option from the dialogue box, as seen below. This will get rid of the worksheet.


In this tutorial, we explained how you can add new worksheets in Excel with customized names.

Updated on: 10-Sep-2022


Kickstart Your Career

Get certified by completing the course

Get Started