How to Add, Copy, and Move Worksheets Within Excel Workbooks

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: What is a Workbook in Excel? - Characteristics and Options

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
Your next lesson will play in 10 seconds
  • 0:01 Worksheets in Excel
  • 0:53 Add, Copy, Move
  • 4:50 Combining Documents
  • 6:24 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Login or Sign up


Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Natalie Boyd

Natalie is a teacher and holds an MA in English Education and is in progress on her PhD in psychology.

Excel is a great tool for organizing information and large amounts of data. But, how do you organize different worksheets in Excel? Watch this lesson to find out how to add, copy, and move worksheets in Excel.

Worksheets in Excel

Randy is compiling some data for his team at work, and he's using Microsoft Excel to put the data in spreadsheets. Randy's boss asked him to put the information from different quarters into different worksheets, but the data is in many different documents. What can he do?

An Excel worksheet is an individual spreadsheet. It is part of a workbook, or Excel document. Each workbook can have one or more worksheets. For example, Randy needs to have one document, or workbook, with four different worksheets, one for each quarter.

To help Randy compile all the data he needs into one workbook, let's take a look at how to add, copy, and move worksheets in Excel and how to move or copy worksheets from one Excel document to another.

Add, Copy, Move

Ok, so Randy has some information that he needs to put into an Excel workbook. He knows that he needs four different worksheets in that workbook, one for each quarter, and he already has some information on the last two quarters in different workbooks. But he needs to input the information for the first two quarters into his Excel workbook. How does he do that?

To add a new worksheet in Excel, Randy will want to follow a few simple steps:

  1. Start a new Excel document or workbook. Once Randy opens Excel to start a new document, there are automatically several worksheets (usually three). How can Randy tell which worksheet he's on? Near the bottom of the page, he'll see tabs labeled 'Sheet1,' 'Sheet2,' and so on. These are the different worksheets in the document, and he can toggle between them.
  2. To add more worksheets, click on the tab furthest to the right. This tab has a little icon that looks like a new sheet, and that's exactly what it does; it adds a new worksheet to the ones that already exist.

That's pretty simple so far, but Randy doesn't want his worksheets to be named 'Sheet1' and 'Sheet2,' so he'll want to change the names of the worksheets. To rename a worksheet in Excel, Randy will want to do one of two things:

  1. Right click on the tab for the sheet to be renamed. This allows Randy to type in the new name for the sheet and hit enter to make the change.
  2. Use the ribbon at the top to rename the sheet. The ribbon is the menu along the top of Excel. All Randy has to do is make sure he's on the 'Home' menu, in the 'Cells' section, and click on 'Format' ('Edit' on a Mac) and 'Rename.' He'll be able to rename the worksheet that he's currently viewing.

Either one of those will allow Randy to rename the worksheets so that they are more descriptive. For example, he'll probably want to name one sheet 'Quarter 1' and another sheet 'Quarter 2.' That way, the members of his team are able to know at a glance which worksheet tab to click on.

This is a great idea, but when Randy creates the worksheets, he realizes that he accidentally put the worksheet for the second quarter before the worksheet for the first quarter. Uh-oh! He wants to rearrange the worksheets so that they are in the right order.

To move a worksheet in Excel, Randy can do one of three things:

To unlock this lesson you must be a Member.
Create your account

Register for a free trial

Are you a student or a teacher?
I am a teacher

Unlock Your Education

See for yourself why 30 million people use

Become a member and start learning now.
Become a Member  Back

Earning College Credit

Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it free for 5 days!
Create An Account