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.
Step 3: Click the drop-down menu under To book, then click the (new book) option.
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.
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. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
