Worksheets in Excel

Operations on Worksheets

As a user, you can perform many operations on the worksheet. In this part of the blog, we will discuss all the functions.

Select a Worksheet

By default, when you open Excel, Sheet1 is selected for you. The name of the worksheets appears at the bottom of the page. Like in the image below, Sheet1 is selected.

Create a New Worksheet

You can create as many worksheets as you want. There are two methods for creating a new worksheet. Let’s discuss the long one first.

1. Right-click on any current worksheet. Then click on the insert as shown below:
   
2.  Now a dialog box will appear in it. Click on the worksheet, and then ok.
3. Now a new sheet will appear along with the old sheets.
   

Now let’s discuss method 2 

1. Just click on the plus icon on the right-hand side of your worksheet name.
   
2. Now a new sheet will be created.
   

Rename a Worksheet

Follow the given steps to create a new sheet.

1. Right-click on the worksheet whose name you want to change and select Rename.
   
2. Now type any name according to your wish. In this example, I have used change.
   

Move a Worksheet

To move a worksheet, click and hold the sheet, then drag the sheet to the position where you want your sheet. As shown below:

Delete a Worksheet

You can delete the unnecessary worksheet by following the following steps:

1. Right-click on the worksheet that you want to delete. And then click on delete as shown below:
   
2. Now the sheet will be deleted.
   

Copy a Worksheet

Often, there is a situation when you want to create a new worksheet of precisely similar format as previous but with different data. So making one from scratch is a waste of time, so we prefer to copy-paste the worksheet. Follow the below steps to copy a worksheet.

1. Right-click on the sheet you want to copy and click on the Move or Copy option as shown below:
   
2. Now a dialog box will appear in this, select the move to end.
   
3. Now select create a copy box and click on ok, then the sheet will appear.
   

Color a Worksheet

Sometimes there are many sheets, and identifying each by name is very difficult, so we can have different colors for different sheets to identify them quickly and faster. Follow the following steps to color your worksheet.

1. Right-click on the worksheet you want to color and click on tab and color. 
   
2. Now select the color accordingly, and your sheet name will be colored.
   

FAQs

1. Can you group different worksheets?
Yes, we can group different worksheets by selecting them with the shift key.
 

2. What is the number of cells present in a single worksheet?
Cells are present in each row and column. The total number of cells present in a single worksheet is 1,048,576 x 16,384.
 

3. Can you add a new worksheet in the same workbook?
Yes, you can add as many worksheets as you want in the same workbook.
 

4. Can a worksheet have more than one workbook?
No, but we can copy the same worksheet in different workbooks.

Key Takeaways

In this article, we have extensively discussed the worksheets, their different characteristics, the difference between worksheets and workbooks, and operations that we can perform on worksheets with proper steps to understand better.

We hope that this blog has helped you enhance your knowledge regarding excel and if you would like to learn more, check out our articles on Code studio. Do upvote our blog to help other ninjas grow.

 “Happy Coding!”