PlayInfoBox

Home /Utilities /How to Copy an Excel Sheet into a New Workbook

How to Copy an Excel Sheet into a New Workbook

Follow these steps in order to move a sheet into a brand-new file.

  1. Right-click the sheet tab to copy

    Right-click the tab of the sheet you want to move into a new file.

  2. Choose "Move or Copy"

    Click "Move or Copy" in the menu.

  3. Choose "New Book" as the destination

    In the dropdown list, select "(new book)."

  4. Check "Create a copy"

    If you want to keep the original sheet in place, check "Create a copy" before clicking OK.

  5. Why it is useful

    It is useful when you want to pull just one sheet out of a large file to share with someone else.

When you only want to share one sheet

Instead of sending an entire multi-sheet file, pulling out just the one sheet the other person needs as its own file keeps things cleaner and shrinks the file size.

Sheet tab colors are worth managing too

Once you are working across several separated sheet files, color-coding and hiding sheet tabs in the source workbook makes it much easier to keep track of which sheet went where.

Frequently Asked Questions

What happens if I do not check "Create a copy"?

If left unchecked, the sheet is not copied β€” it is fully moved out of the original file and disappears from it, so be careful.

Can I move several sheets into a new file at once?

Yes β€” hold Ctrl to select multiple sheet tabs together, then follow the same steps to move them all at once.