Three new blank sheets always open when you start Microsoft Excel. Below steps explain you how to create a new worksheet if you want to start another new worksheet while you are working on a worksheet, or you closed an already opened worksheet and want to start a new worksheet.

Step 1 − Right Click the Sheet Name and select Insert option.

How to Create and Copy Worksheet in Excel

Step 2 − Now you’ll see the Insert dialog with select Worksheet option as selected from the general tab. Click the Ok button.

Now you should have your blank sheet as shown below ready to start typing your text.

You can use a short cut to create a blank sheet anytime. Try using the Shift+F11 keys and you will see a new blank sheet similar to the above sheet is opened.

Copy Worksheet in Excel

Copy Worksheet

First of all, let us create some sample text before we proceed. Open a new excel sheet and type any data. We’ve shown a sample data in the screenshot.
Order Date Region Rep Item Units Unit Cost Total
1/6/2010 East Jones Pencil 95 1.99 189.05
1/23/2010 Central Kivell Binder 50 19.99 999.5
2/9/2010 Central Jardine Pencil 36 4.99 179.64
2/26/2010 Central Gill Pen 27 19.99 539.73
3/15/2010 West Sorvino Pencil 56 2.99 167.44
4/1/2010 East Jones Binder 60 4.99 299.4
4/18/2010 Central Andrews Pencil 75 1.99 149.25
5/5/2010 Central Jardine Pencil 90 4.99 449.1
5/22/2010 West Thompson Pencil 32 1.99 63.68
6/8/2010 East Jones Binder 60 8.99 539.4
6/25/2010 Central Morgan Pencil 90 4.99 449.1
7/12/2010 East Howard Binder 29 1.99 57.71
7/29/2010 East Parent Binder 81 19.99 1,619.19
8/15/2010 East Jones Pencil 35 4.99 174.65

Here are the steps to copy an entire worksheet.
Step 1 − Right Click the Sheet Name and select the Move or Copy option.

Step 2 − Now you’ll see the Move or Copy dialog with select Worksheet option as selected from the general tab. Click the Ok button.

Select Create a Copy Checkbox to create a copy of the current sheet and Before sheet option as (move to end) so that new sheet gets created at the end.

Press the Ok Button.

Now you should have your copied sheet as shown below.

You can rename the sheet by double clicking on it. On double click, the sheet name becomes editable. Enter any name say Sheet5 and press Tab or Enter Key.

So, this brings us to the end of blog. This Tecklearn ‘How to Create and Copy Worksheet 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

564