Excel: Copy an Entire Worksheet to a New Workbook Safely

To copy an entire worksheet into a new workbook in Excel for Microsoft 365 on Windows, right-click the worksheet tab, choose Move or Copy, select (new book) under To book, check Create a copy, and click OK. Excel opens a new workbook containing that sheet; save the new workbook separately so the original remains unchanged.

What copying a worksheet means

A worksheet is one tab inside an Excel workbook, while a workbook is the whole file. Copying a worksheet to a new workbook creates a separate file with the selected tab in it. It does not duplicate every tab in the original file, and it does not normally remove or alter the source sheet. The Create a copy checkbox is important: without it, Excel moves the sheet out of its original workbook instead.

This is useful when you need to send someone one report tab without sharing all the other sheets, create a standalone copy before making changes, or separate a monthly or departmental sheet from a larger workbook. It is different from copying a range of cells: a sheet copy can preserve layout and sheet-level features that a cell selection would not include.

Think of the result as a new workbook built around one sheet, not necessarily a fully independent copy of every resource the sheet uses. Formulas, names, charts, connections, and macros can depend on other parts of the original workbook. Those dependencies are the main reason to inspect the new file before relying on it or sharing it.

Windows steps: copy the sheet to a new workbook

Open the source workbook in the Excel desktop app and select the worksheet you want to copy. If you are unsure which tab is active, click its tab once.
Right-click the sheet tab at the bottom of the window and choose Move or Copy. You can also use Home > Format > Move or Copy Sheet.
In the dialog, open the To book list and choose (new book). This tells Excel to create a separate workbook for the copied sheet.
In the Before sheet list, choose where the sheet should appear. For a one-sheet new workbook, the default position is usually suitable.
Check Create a copy. Confirm that it is checked before proceeding; leaving it unchecked moves the sheet instead.
Click OK. Excel creates and activates a new workbook containing the copied worksheet.
Use Ctrl+S to save the new workbook. Choose a folder and a clear filename, then confirm the file type in the Save As dialog if Excel asks.

The source workbook usually remains open, along with the new workbook. If you want to keep the new version distinct, give it a descriptive name such as Regional-Sales-Review.xlsx rather than saving over the original. The new workbook may initially have a generic name such as Book1 until you save it.

What the copied sheet usually brings with it

The operation copies the worksheet as a sheet, rather than just its visible values. That generally includes cell contents and formulas, number formats, fonts, fills, borders, column widths, row heights, merged cells, and the sheet’s general layout. Sheet-level items such as charts, shapes, filters, conditional formatting, data validation, and print settings can also be carried over. What appears in the new file depends on how each item is set up and whether it depends on something outside the copied sheet.

For example, a formatted sales report with a chart and a filter is more likely to retain its visual structure through Move or Copy Sheet than through selecting cells and pasting them into a blank workbook. The copied sheet also keeps its tab as a worksheet, so you can still rename it, change its tab color, or edit its contents in the new workbook.

However, a worksheet is only one part of a workbook. Workbook-level settings, other worksheets, custom workbook names, connections, and supporting data may not come across as a self-contained set. A pivot table or chart might display in the new workbook but still rely on a source range, cache, or external connection. If the sheet uses features that depend on other tabs or workbook settings, test those features in the copy rather than assuming that the appearance proves every dependency is intact.

Check formulas and links to other sheets

A formula that refers only to cells on the copied sheet can often continue working as expected. The risk is a formula that refers to another worksheet in the original workbook. Because that other tab was not copied, Excel may preserve the reference as a link back to the source file. A formula that originally referred to a tab named Data, for example, may now refer to Data in the original workbook. If the source file is renamed, moved, or unavailable, that link may need attention.

Review formulas in important totals and summaries, especially those that draw from other tabs. Select a formula cell and inspect the formula bar for a workbook name in square brackets, or use Data > Workbook Links if that command is available for the links in your file. Excel’s link-management options can vary with the type of connection and the version of the app. Do not break a link just to remove a warning unless you understand the effect: breaking a workbook link can replace formulas with their current values, which prevents later updates from the source.

Defined names can also refer to cells beyond the copied sheet. Check Formulas > Name Manager if the copied sheet relies on named ranges. Look at data-validation lists, charts, and conditional-formatting rules too; their source ranges may point to another sheet. For a report that should work independently, either bring required source tabs into the new workbook or deliberately replace external dependencies with suitable local data. Keep a copy of the original before making broad changes.

Common problems and how to avoid them

The original sheet disappeared. The Create a copy box was probably left unchecked, so Excel moved the sheet. If the original workbook is still open, use Ctrl+Z promptly or copy the sheet back. Undo may not be available after later actions, so check the source workbook before closing it.
The new workbook shows link warnings. Some formulas, names, or objects may still refer to the source workbook. Inspect the dependencies and decide whether to keep, update, or remove each link; do not assume the warning means the sheet itself failed to copy.
A chart or pivot table does not update as expected. Check its data source and any external connection. A copied object can remain visible even when its underlying data source is not included in the new workbook.
The new file looks different when printed. Review Page Layout settings, print area, page breaks, scaling, and selected printer settings. A screen view is not a guarantee that the copied sheet will paginate identically on another computer or printer.
The sheet tab is unavailable. If the sheet is hidden, unhide it first through the workbook’s sheet controls, if permitted. A workbook structure or file-protection setting may also prevent moving or copying sheets; you may need permission or to remove protection through an authorized process.

One important misconception is that copying the visible worksheet guarantees a portable, self-contained report. It guarantees a copied sheet, not necessarily a copy of every workbook resource that supports it. Treat formulas, connections, and linked objects as dependencies to verify.

Save format, macros, and workbook security

For a standard workbook without macros, .xlsx is the usual format. If the sheet depends on VBA, check whether the required code is present in the new workbook and choose a macro-enabled format such as .xlsm when appropriate. Copying one worksheet should not be treated as a reliable way to duplicate every macro or every piece of workbook-level VBA. Excel projects can include code associated with a sheet as well as code stored elsewhere, so inspect the actual result and retain the original file. Macro-enabled files can run code; open them only when you trust their source and content.

Before distributing the new workbook, remove information the recipient should not see. A copied sheet may contain hidden rows or columns, comments or notes, formulas revealing assumptions, or links to other files. Review the sheet and its workbook links, and consider whether the source workbook contains confidential material that should not be included. Copying only one tab reduces what is shared, but it is not a substitute for a privacy review.

Excel for Mac and Excel for the web

In Excel for Mac, the desktop workflow is similar: Control-click or right-click the worksheet tab, choose Move or Copy, select (new book) in the destination list, check Create a copy, and confirm. A Mac trackpad may use a two-finger click for the context menu. Keyboard shortcuts differ by platform: Ctrl+S saves on Windows, while Command+S saves on Mac.

Excel for the web has fewer options for transferring a complete worksheet between workbooks, and the desktop Move or Copy dialog may not be available for that task. If the browser version does not offer the required destination workbook, open the file in the Excel desktop app and use the steps above. Copying and pasting a cell range in the browser is an alternative for basic data, but it may not preserve all sheet-level settings and objects.

When to use another method

Use Move or Copy Sheet when you want the whole tab and its layout in a separate workbook. If you only need the displayed results and want to avoid links to the source workbook, copying the relevant range and pasting values into a new sheet may be more appropriate. That approach does not preserve all formulas or sheet features, so choose it only when fixed values are acceptable.

If the recipient needs several related tabs, copy each required sheet into the new workbook rather than copying only the summary tab. Then inspect formulas between those sheets, names, charts, and data sources. If the goal is to create a reusable template, remove or replace sample data carefully and save as an Excel template file rather than treating an ordinary copied workbook as a template automatically.

Frequently Asked Questions

How do I copy an Excel sheet without changing the original? Right-click its tab, choose Move or Copy, select (new book), and check Create a copy before clicking OK. The checked box tells Excel to keep the source sheet and create a duplicate in the new workbook.

Can I copy a worksheet into an existing workbook instead? Yes. In the Move or Copy dialog, choose the destination workbook from To book instead of (new book), choose a position in Before sheet, and check Create a copy. Make sure the destination workbook is open so it appears in the list.

Will formulas still work after I copy one sheet? Formulas that depend only on content carried with the sheet may continue to work, but references to other tabs or workbook resources can remain linked to the source file. Check important formulas, names, and chart or validation sources in the new workbook.

Does copying a sheet copy the entire workbook? No. It copies the selected worksheet, not all the other tabs and workbook-level resources. If the sheet depends on other sheets, copy those too or review the resulting external references.

Can I copy a worksheet in Excel for the web? The web app may not provide the desktop option for copying a sheet into a separate workbook. For a complete worksheet transfer, use Excel for Windows or Mac if the browser interface does not show the needed destination option.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.