Software

Copy an Excel worksheet into a new workbook file

Don't recreate spreadsheets, copy them as new sheets or even into new workbooks.
If you update recurring data, such as monthly sales figures, you might create a copy of a completed sheet to use as a starting point. For instance, when you're ready to start tracking February's sales, you might copy January's sheet, delete January's figures, and start entering February's. Copying a sheet is easy to do. You simply select the sheet you want to copy and choose Move Or Copy Sheet from the Edit menu. This feature quickly makes a copy of the sheet within the same workbook. What you might not realize is that you can use this same feature to copy a sheet from one workbook to another. The capability's pretty obvious, but the truth is, if you don't need it, you don't realize it's there because it's easy to overlook. To copy a sheet into a new workbook file, do the following:

  1. Select the sheet you want to copy (or move).
  2. Choose Move Or Copy Sheet from the Edit menu.
  3. In the Move Or Copy dialog, select (new book) from the To Book list box.

  1. Be sure to check the Create A Copy option if you want to copy instead of move the sheet.
  2. Click OK.

Excel will open a new workbook with the copied sheet. If you're using Excel 2007, do the following:

  1. Select the tab of the sheet you want to copy (or move).
  2. Click the Home tab and then click Format in the Cells group.
  3. In the Organize Sheets section, click Move Or Copy Sheet.
  4. In the Move Or Copy dialog, select new book from the To Book list box.
  5. Be sure to check the Create A Copy option if you want to copy instead of move the sheet.
  6. Click OK.

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

3 comments
dhays
dhays

I know how to do this, I have been using this feature for quite a while, but what I want to do is to copy a sheet with just the data, not the references back to the previous file, I have tried to use the copy special option, when you copy values, the graphs don't come out. I need to copy without references to the previous file, everything within the shhet needs to stay the same. That way the next viewer doesn't have to say don't update the references. I forgot to click alert me for next post. If you have an answer to my question, then email me at david.k.hays@faa.gov

Architect
Architect

You can also copy or move multiple sheets by right clicking on the sheet tab and choosing 'Select All' or pick multiple indivdual sheets by holding down the 'Ctrl' key and clicking on the multiple sheets that you want to move or copy.

ssharkins
ssharkins

Thanks for the additional tip -- I should've mentioned it myself!

Editor's Picks