In Excel 2016, when we open up a new workbook, it now includes only one worksheet. There can be the max of 1,048,576 rows and 16,384 columns in an excel worksheet.

Worksheet

Excel files are known as workbooks. Each workbook holds one or more worksheets (also called a “spreadsheetsx”).

Whenever we create a new Excel workbook, it will include one worksheet named Sheet1. A worksheet is a framework of columns and rows where column are identified by letters running across the top of worksheet, and rows are identified by numbers running down the left side of the worksheet.

When working with a high amount of data, we can create multiple worksheets to help organize our workbook and make it easier to find content. We can also group worksheets to quickly add data to multiple worksheets at the same time.

To rename a worksheet

Whenever we create a new Excel workbook, it will include one worksheet named Sheet1. We can rename a worksheet to reflect its content better. In this example, we will develop a training log organized by month.

1. Right-click the worksheet we wish to rename, then select Rename from the worksheet menu.

2. Type the desired name for the worksheet.

3. Click anywhere outside of the worksheets, or press the Enter on our keyboard. The worksheet will be renamed.

To insert a new worksheet

1. Locate and select the new sheet button.

2. A new, blank worksheet will occur.

Note: To change the default number of worksheets, navigate to backstage view, click Options, and then choose the desired amount of worksheets to contain in each new workbook.

To delete a worksheet

1. Right-click the worksheet you wish to remove, then select Delete from the worksheet menu.

2. The worksheet will be deleted from our workbook.

Alternatively, Home Tab in the Cells Group, click on Delete and select Delete Sheet.

Note: The Undo button will not undo the deletion of the worksheet.

To copy a worksheet

If we need to duplicate the content of one worksheet to another, Excel allows us to copy an existing worksheet.
1. Right-click the worksheet we want to copy, then select Move or Copy from the worksheet menu.

2. The Move or Copy dialog box will occur. Choose where the sheet will occur in the Before sheet: field. In this example, we’ll choose (move to end) to place the worksheet to the right of the current worksheet.

3. Check the box next to generate a copy, then click OK.

4. The worksheet will be copied. It will have a similar title as the original worksheet, as well as a version number.

Note: We can also copy a worksheet to a fully different workbook. We can choose any workbook that is now open from the To book: drop-down menu.

To move a worksheet

Sometimes we may want to move a worksheet to rearrange our workbook.

1. Select the worksheet we wish to move. The cursor will develop into a small worksheet icon
2. Hold and drag the mouse until the small black arrow emerge above the desired placed.

3. Release the mouse. The worksheet will be changed.

To change the worksheet color

We can change a worksheet’s color to help organize our worksheets and make our workbook easier to navigate.

1. Right-click the desired worksheet, and the mouse over Tab Color. The Color menu will emerge.
2. Choose the desired color. A live preview of a new worksheet color will develop as the mouse over different options. In this example, we’ll choose Red.

3. The worksheet color will be modified.

The worksheet color is significantly less noticeable when the worksheet is selected. Select another worksheet to view how the color will emerge when the worksheet is not selected.

The Scrolling Buttons

These buttons scroll the show of sheet tabs one at a time or to show the first and last grouping of sheet tab and are placed to the left of the sheet tabs.

The Scroll Bars

Our spreadsheet may frequently have more data than we can view on-screen at once. Click, hold, and drag the vertical or horizontal scroll-bar depending on what part of the page we want to view.

So, this brings us to the end of blog. This Tecklearn ‘How to create Worksheets in Excel’ blog helps you with commonly asked questions if you are looking out for a job in Microsoft Excel. If you wish to learn Excel and build a career in Business Intelligence domain, then check out our interactive, Microsoft Power BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Microsoft Power BI Training

Microsoft Power BI Training

About the Course

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

Why Should you take Microsoft Power BI Training?

• The average annual pay for a Power BI Professional is $114,000 . -PayScale.com.
• Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc, Brillio and 45,000 MNCs across 185 countries use Power BI and it has a market share of around 7% globally.
• Microsoft Power BI has been ranked at No.1 position in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 13 consecutive years.

What you will Learn in this Course?

Introduction to Microsoft Power BI

• Microsoft Power BI Introduction
• Power BI Products
• Power BI Architecture
• Installing Power BI
• Connecting to Data Sources

Power BI Workflow

• Key features of Power BI workflow
• Power BI Vs MSBI
• History of Power BI
• Power BI Products
• Data modelling and relationships

Power Query for Data Transformation

• Power Query for Data Transformation
• Learning about Power Query for self-service ETL functionalities
• Working with Excel data
• Introduction to Query Editor
• Data transformation
• Pivot and UnPivot
• Merge Join, relational operators, date, time calculations, working with M functions
• Summary Tables
• Writing custom functions and error handling
• M advanced data transformations

Filters and Drill Down Report

• Visualization Filter
• Page Level Filter
• Report LEVEL Filter
• DRILL Through Filter or Report
• BookMark Report

Power Pivot for Data Modelling

• What is SSAS
• Data Modelling
• Star Schema
• Snowflake Schema
• Introduction to MDDB and Tabular
• Data Access Modes
• Tabular with DAX
• Power BI with DAX
• DAX Functions

Data Analysis Expression – DAX Queries

• TABULAR with DAX
• Power BI with DAX
• Calculated Members, Row, Filter & Evaluation Context
• Cumulative Charts
• Calculated Tables, ranking and rank over groups
• DAX advanced features

Power BI Desktop & Administration

• Reports and Visualization
• Learning about data modelling and data relationships
• Deploying data gateways
• Reports and Dashboards
• On Premises Data Gateway
• Gateway Clusters

Introduction to Power Q & A

• Power Service
• Power Q & A best practices
• Integrating with SaaS applications
• Gateway

597