Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Worksheet tabs in excel are rectangular tabs visible on the bottom left of the excel workbook, the active tab shows the active worksheet available to edit, by default there can be three worksheet tabs opened and we can insert more tabs in the worksheet using the plus button provided to the end of the tabs also we can rename or delete any of the worksheet tabs.
Worksheet Tab in Excel (Table of Contents)
- Change No. of Worksheets by Default Excel Creates
- Create Replica of Current Worksheet
- Create Replica of Current Worksheet by Using Shortcut Key
- Create New Worksheet
- Create New Excel Worksheet Tab Using Shortcut Key
- Go to the First Worksheet & Last Worksheet
- Move Between Worksheets
- Delete Worksheets
- View All the Worksheets
Worksheet Tab in Excel
Worksheets are the platform for Excel software. These worksheets have separate tabs and every excel file must contain at least one worksheet in it. We have many more things to do with these worksheets tab in excel.
Worksheet tab can be found at the bottom of the every excel worksheet tab.
In this article, we will take a complete tour about worksheet tabs in excel regarding how to manage worksheets, rename, delete, hide, unhide, move or copy, the replica of the current worksheet and many other things.
#1 – Change No. of Worksheets by Default Excel Creates
If you have observed when you open excel file at first excel gives you 3 worksheets named Sheet1, Sheet2, and Sheet3.
We can modify this default setting and make our own settings. Follow the below steps to modify the settings.
Step 1: Go to FILE.
Step 2: Go to OPTIONS.
Step 3: Under GENERAL, go to when creating new workbooks.
Step 4: Under this Include this many sheets:
Step 5: Here you can modify how many worksheets tab in excel need to be included while creating a new workbook.
Step 6: Click on OK. We will have 5 excel worksheets tab whenever you open a new workbook.
#2 – Create Replica of Current Worksheet
When you are working in an excel file, at a certain point you want to have a copy of the current worksheet. Assume below is the excel worksheet tab you are working on at the moment.
Right click on the worksheet and select Move or Copy.
In the below window click the checkbox Create a copy.
Click on OK, we will have a new sheet with the same data. 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. Select the sheet and hold the Ctrl key.
After holding the control key hold the left button of the mouse key and drag to the right side. We would have a replica sheet now.
#4 – Create New Worksheet
In order to create a new worksheet, you need to click on the plus icon after the last worksheet.
Once you click on the PLUS icon we would 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 by using the shortcut key. The shortcut key to insert worksheet is Shift + F11.
If you press this key it would insert the new worksheet tab in excel 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. We are moving between sheets regularly, if you want to move to the last and first worksheets then we need to use the below technique.
In order to come to the first worksheet, hold the control 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 the tough task if you are moving manually. We have a shortcut key 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 worksheet similarly we can delete as the worksheet as well. In order to delete the worksheet right click on the required worksheet and click on DELETE.
If you want to delete multiple sheets at once hold the control key and select the sheets you want to delete.
Now can delete all the sheets at once.
We can also delete the sheet by using the shortcut key i.e. ALT + E + L.
If you want to select all the sheets you can right click on the any of the worksheets and choose Select All Sheets.
Once all the worksheets are selected and if you want to unselect again right click on the any of the worksheet and choose Ungroup Worksheets.
#9 – View All the Worksheets
If you have many worksheets and you want to select a particular sheet but don’t know where exactly that sheet is.
You can use the below technique see all the worksheets. Right click on the move buttons at the bottom.
We will see below list of all the worksheets tab in the excel file.
Things to Remember While Using New Worksheet Tab in Excel
- We can also hide and unhide sheets by right click on the sheets.
- ALT + E + L is the shortcut key.
- ALT + E + M is the shortcut key to create a replica sheet.
- Ctrl + Page Up is the shortcut key to select left side worksheets.
- Ctrl + Page Down is the shortcut key to select right side worksheets.
This has been guided to Worksheet Tab in Excel. Here we discuss how to manage worksheets, rename, delete, hide, unhide, move or copy and use shortcut keys along with practical examples and downloadable excel template. You may learn more about excel from the following articles –