Worksheets in Excel

Updated on April 3, 2024
Article byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Worksheets in Excel

Excel Worksheets

As soon as we open blank excel, the screen on which we are going to work is termed as a worksheet. By default, the new excel workbook has three worksheets and you can refer to them using worksheet tabs in excel at the bottom as shown below: We are going to learn about these tabs and how to add a new one, rename it and many more things.

Examples of Worksheets in Excel

We are going to learn about how to insert worksheets in excel with examples.

Example #1 – Insert a New Tab

“How to insert a new tab” is one the most important topic.

Step 1: Click on the tab after which you wish to insert the new tab.

Insert New Tab 1

Step 2: Now, click on the plus button which is at the right-hand side of the tabs

Insert New Tab 1-1

And after you click the button, a new tab will be added after the already selected tab.

Insert New Tab 1-2

The newly added tab is named “Sheet4” though we have added it after “Sheet1”. It is because excel adds the tab in sequential order of the already existing tabs without taking their position in account.

Example #2 – Delete a Tab

Let’s learn about how to delete a tab. One thing you should keep in mind while deleting a tab is that all the data in the excel worksheet will be lost and you will not be able to recover it. So, think before you delete any tab.

Step 1: Right-click on the tab you want to delete and a menu will appear as shown below:

Delete a Tab Step 1

Step 2: Select “Delete” from the menu and the tab will get disappear.

Delete a Tab Step 1-1

Example #3 – Renaming a Tab

Sometimes we want to give our tabs a meaningful name so that it is easy to relate them with the information stored in them. In fact, this also helps the other person who has not worked on a workbook to understand which part of the information is stored where if we use meaningful tab names.

There are two ways by which you can rename a tab as shown in the below steps:

Step 1: Right-click on the tab you want to rename and a menu will appear as shown below:

Worksheets in Excel 3

Step 2: Click on rename and the tab name will get highlighted as shown below:

Worksheets in Excel 3-1

Step 3: You can give any name to the tab according to your will. Just make sure that the name you are providing is relevant to the information stored in it.

Worksheets in Excel 3-2

The another and simplest way to rename your tab is as follows:

Step 1: Double click on the tab you want to rename and the tab name will get highlighted as shown below:

Worksheets in Excel 3-3

Step 2: You can give any name to the tab according to your will.

Worksheets in Excel 3-4

Example #4 – Switch in Between Tabs

When we have multiple tabs, we need to go from one tab to another. The best way to do is to use “PgUp” and “PgDn” keys with “Ctrl” key.

In case you have multiple tabs and they are not getting fit on the tab bar then all you need to do is follow below steps:

Step 1: At the ends of the tab bar, you will see three dots as shown below:

Switch in Between Tabs 1

Step 2: All you need to do is to click on these dots to go right or left and switch between the tabs.

Use can also use arrows at the left-hand corner of the tab bar as shown below:

Switch in Between Tabs 1-1

These arrows will not switch the tab but will help you look at what is in left or right. To switch you have to click on the desired tab as shown below:

Switch in Between Tabs 1-2

Switch in Between Tabs 1-3

You can even right-click on the arrows to see the full list of tabs present in the workbook as shown below:

Switch in Between Tabs 1-4

You can choose the desired tab you want to switch to and then press “OK”.

Switch in Between Tabs 1-5

Switch in Between Tabs 1-6

Example #5 – Hide or Unhide the Tabs

Sometimes you need to hide the sheets so that no one else other than you can have access to them. Similarly, if you need to edit the information present on hidden tabs you have to unhide them to work on them.

Below are the steps that will help you to do the same:

#1 – Hide Tabs

Step 1: Right-click on the tab you want to hide and a menu will appear as shown below:

Hide Tabs Step 1

Step 2: Click on “Hide” option available in this menu and the tab will disappear:

Hide Tabs Step 1-1

#2 – Unhide Tabs

Step 1: Right-click on any tab and a menu will appear as shown below:

Unhide Tabs Step 1

Step 2: Click on “Unhide” option and a pop-up box will appear as shown:

Unhide Tabs Step 2

Step 3: Click on the sheet you want to unhide and press “OK” and you will be able to see the sheet:

Unhide Tabs Step 3

Example #6 – Move or Copy Tabs

While doing some repetitive work with some minute difference between the information we tend to copy one tab and modify the information accordingly. Here we will learn how to copy a tab or move it in case we want the tabs in a certain flow. You can also create the copy of tabs or move one tab to another workbook.

Step 1: Right-click on the sheet you wish to Move or Copy as shown below:

Worksheets in Excel 6

Step 2: Click on Move or Copy Option and a pop-up box will appear:

Worksheets in Excel 6-1

We can select the workbook in which we want to copy or move in the “Move selected sheets To book:” dropdown. We can select the sheet in “Before sheet” menu before we want to move or copy the tab.

We have to select the checkbox to create a copy otherwise excel will just move it and then press “OK”.

Worksheets in Excel 6-2

Worksheets in Excel 6-3

Things to Remember

  1. Excel names the newly inserted tabs in sequential order without taking their placement in the account.
  2. If we delete a tab all the information in it will be lost and will not be able to recover
  3. We cannot use special characters like “*” while naming a tab
  4. You can select multiple sheets and hide them altogether, but you cannot unhide multiple sheets in one go.

Recommended Articles

This has been a guide to Worksheets in Excel. Here we discuss how to insert worksheets in excel using shortcut keys along with practical examples. You may learn more about excel from the following articles –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *