What is located at the bottom of worksheet?

The worksheet tabs in Excel are rectangular tabs visible on the bottom left of the Excel workbook. The “Activate” tab shows the active worksheet available to edit. By default, there can be three worksheet tabs opened. We can insert more tabs in the worksheet using the plus button provided at the end of the tabs. We can also rename or delete any of the worksheet tabs.

Nội dung chính Show

#1 Change No. of Worksheets by Default Excel Creates
#2 Create Replica of Current Worksheet
#3 – Create Replica of Current Worksheet by Using Shortcut Key
#4 – Create New Excel Worksheet
#5 – Create New Excel Worksheet Tab Using Shortcut Key
#6 – Go to the First Worksheet & Last Worksheet
#7 – Move Between Worksheets
#8 – Delete Worksheets
#9 – View All the Worksheets
Things to Remember
Recommended Articles
What is the bottom of an Excel sheet called?
What appears at the bottom of the workbook window?
What are the parts of the worksheet?
Where is the worksheet footer?

Worksheets are the platform for Excel software. In addition, these worksheets have separate tabs. Every Excel file must contain at least one worksheet in it. We have many more things with these worksheets tab in Excel.

We can find the worksheet tab at the bottom of every Excel worksheet tab.

In this article, we will take a complete tour of worksheet tabs regarding how to manage worksheets, rename, delete, hide, unhide, move or copy, the replica of the current worksheet, and many other things.

Worksheet Tab in Excel
- #1 Change No. of Worksheets by Default Excel Creates
- #2 Create Replica of Current Worksheet
- #3 – Create Replica of Current Worksheet by Using Shortcut Key
- #4 – Create New Excel Worksheet
- #5 – Create New Excel Worksheet Tab Using Shortcut Key
- #6 – Go to the First Worksheet & Last Worksheet
- #7 – Move Between Worksheets
- #8 – Delete Worksheets
- #9 – View All the Worksheets
- Things to Remember
- Recommended Articles

You are free to use this image on your website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Excel Worksheet Tab (wallstreetmojo.com)

#1 Change No. of Worksheets by Default Excel Creates

You may have observed while opening the Excel file that it gives you three worksheets named “Sheet1,” “Sheet2,” and “Sheet3.”

We can modify this default setting and make our settings. Follow the below steps to change the settings.

We must first go to the “FILE.”
Then, go to “OPTIONS.”
Under “GENERAL,” go-to “When creating new workbooks.”
Under this, we must choose “Include this many sheets.”
Here, we can modify how many worksheets tab in Excel must be included while creating a new workbook.
Click on “OK.” We will have a 5 Excel worksheets tab whenever we open a new workbook.

#2 Create Replica of Current Worksheet

When you are working on an Excel file, you want to have a copy of the current worksheet at a certain point. For example, assume below is the worksheet tab you are working on at the moment.

Step 1: First, we must right-click on the worksheet and select “Move or Copy.”

Step 2: In the below window, click the checkbox “Create a copy.”

Step 3: Click on “OK.” We will have a new sheet with the same data. The new worksheet name will be “2017 Sales (2).“

#3 – Create Replica of Current Worksheet by Using Shortcut Key

We can also create a replica of the current sheet by using this shortcut key.

Step 1: We must select the sheet and hold the “Ctrl” key.

Step 2: After holding the “Ctrl” key, hold the left button of the mouse key, and drag it to the right side. As a result, we would have a replica sheet now.

#4 – Create New Excel Worksheet

Step 1: To create a new worksheet, we must click on the “plus” icon after the last worksheet.

Step 2: Once we click on the “PLUS” icon, we will have a new worksheet to the right of the current worksheet.

#5 – Create New Excel Worksheet Tab Using Shortcut Key

We can also create a new Excel worksheet tab using the shortcut key. For example, the shortcut key to insert the worksheet is “Shift + F11.”

If we press this key, it will insert the new worksheet tab to the left of the current worksheet.

#6 – Go to the First Worksheet & Last Worksheet

Assume we are working with the workbook, which has many worksheets. Furthermore, we are moving between sheets regularly. Therefore, if we want to move to the last and first worksheets, we need to use the below technique.

To come to the first worksheet, we must hold the “Ctrl” key and click on the arrow symbol to move to the first sheet.

#7 – Move Between Worksheets

Going through all the worksheets in the workbook is a tough task if we move manually. So, we have shortcut keys to move between worksheets.

Ctrl + Page Up: This would go to the previous worksheet.

Ctrl + Page Down: This would go to the next worksheet.

#8 – Delete Worksheets

Like how we can insert new worksheets, we can delete the worksheet. To delete the worksheet, we must right-click on the required worksheet and click on “DELETE”.

If you want to delete multiple sheets simultaneously, we must hold the “Ctrl” key and select the sheets we want to delete.

Now, we can delete all the sheets at once.

We can also delete the sheet using the shortcut key, “ALT + E + L.”

If we want to select all the sheets, we can right-click on any worksheets and choose “Select All Sheets.”

Once all the worksheets are selected, and if we want to unselect again, we must right-click on any worksheets and choose “Ungroup Worksheets.”

#9 – View All the Worksheets

If we have many worksheets and want to select a particular sheet, we do not know where exactly that sheet is.

We can use the below technique to see all the worksheets. But, first, we must right-click on the move buttons at the bottom.

Consequently, we would see below the list of all the worksheets tab in the Excel file.

Things to Remember

We can also hide and unhide sheets by right click on the sheetsUnhide Sheets By Right Click On The SheetsThere are different methods to Unhide Sheets in Excel as per the need to unhide all, all except one, multiple, or a particular worksheet. You can use Right Click, Excel Shortcut Key, or write a VBA code in Excel. read more.
The shortcut key is “ALT + E + L.”
For creating a replica sheet, the shortcut key is “ALT + E + M.”
The shortcut key to select left side worksheets is “Ctrl + Page Up.”
The shortcut key to select right side worksheets is “Ctrl + Page Down.”

What is the bottom of an Excel sheet called?

The status bar at the bottom of Office programs displays status on options that are selected to appear on the status bar. Many options are selected by default. If you want to customize the status bar, right-click it, and then click the options that you want.

What appears at the bottom of the workbook window?

The Status bar appears at the very bottom of the Excel window and provides such information as the sum, average, minimum, and maximum value of selected numbers. You can change what displays on the Status bar by right-clicking on the Status bar and selecting the options you want from the Customize Status Bar menu.

What are the parts of the worksheet?

Worksheet - rectangular grid of rows (numbers) and columns (letters).

Cell - intersection of row and column..

Cell reference - unique address, coordinates of the intersection of a column and row (B7).

Gridlines - horizontal and vertical lines..

On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.