How to Copy a Worksheet to Its’ Own Workbook in Excel 2010


When you work with Excel 2010 often for work or school, you may eventually find that you are using the same data over and over again. When this occurs, you can find that you are copying and pasting a lot of data between old files and new ones. If your important data exists in only one worksheet, however, there is a quick way to copy that worksheet from its’ original workbook to a new one.

Our tutorial below will show you the steps that you need to follow in order to make a copy of a worksheet in an old Excel workbook and move it to a new workbook.

 

Creating a new Workbook from an Existing Worksheet in Excel 2010

The steps in this article will show you how to copy a worksheet from an existing workbook to its’ own, new workbook in Excel 2010. This will leave a copy of the worksheet in it’s original workbook, plus create a new workbook that consists only of the selected worksheet.

 

Step 1: Open the workbook in Excel 2010 that contains the worksheet you want to copy.

 

Step 2: Right-click the worksheet tab at the bottom of the window, then click the Move or Copy option.

right-click, then click move or copy

 

 

Step 3: Click the drop-down menu under To book, then click the (new book) option.

choose a new book

 

 

Step 4: Click the box to the left of Create a copy, then click the OK button. If you do not elect to create a copy, then the worksheet will be removed from the original workbook, and will exist only in the new workbook.

create a copy

 

 

This will create a new workbook. The only worksheet in this new workbook will be the one that you just elected to copy. Be sure to save this new workbook before closing it.

 

Are the sheet tabs not displaying at the bottom of your workbook? It’s possible for these to be hidden by adjusting a setting in Excel 2010. This guide will show you how to unhide all of your sheet tabs if they are not visible. If some of your tabs are visible, then this article will show you how to unhide any hidden ones.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.