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.

Editor's Picks