How to Export an Excel Tab to a New Workbook

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, right-click the worksheet tab, choose Move or Copy, select (new book) in the To book list, and click OK. Select Create a copy first if you want to keep the tab in the original workbook. Excel opens the new workbook with the sheet; save it as a separate file to complete the export.

This method transfers a whole worksheet, including its cell contents and much of its formatting, rather than simply copying a range of cells. Before you begin, decide whether the original should retain the sheet, and consider whether the sheet relies on formulas, names, charts, or other sheets in the source workbook. Those dependencies may affect how the exported workbook behaves.

What You’ll Need

  • A desktop copy of Microsoft Excel and the workbook containing the worksheet. The instructions below use Excel for Microsoft 365 on Windows.
  • A location and file name for the new workbook, such as a project folder or shared drive. Check that you have permission to save there.
  • A quick plan for whether you intend to copy the sheet or move it. Copying preserves the original tab; moving removes it from the source workbook.
  • If the sheet uses formulas linked to other tabs, external files, macros, or data connections, access to those dependencies and time to check them after export.

Step-by-Step

  1. Open the source workbook. Open the Excel file that contains the tab you want to export. If the workbook has unsaved edits, save them first with Ctrl+S on Windows. This gives you a reliable starting point and reduces the chance of exporting an earlier version of the sheet. If the file is read-only or opened in Protected View, use the appropriate editing option or save an editable copy before continuing.
  2. Identify the correct worksheet tab. Look along the bottom of the Excel window and find the tab name. If the tab names are truncated, use the navigation arrows at the lower left to move through the sheet tabs, or widen the Excel window. Click the intended tab once to make that sheet active. Check its contents before proceeding; similarly named tabs are easy to confuse in a large workbook.
  3. Open the sheet’s move or copy command. Right-click the worksheet tab and choose Move or Copy from the context menu. If you use a touchpad, use the configured secondary-click gesture. Do not choose a cell-level Copy command from the Home tab: that copies selected cells, not the entire worksheet. Excel opens a dialog with a To book list and a list of sheet positions.
  4. Select the new-workbook destination. In the Move or Copy dialog, open the To book list and choose (new book). This tells Excel to create a separate workbook for the sheet. If you instead select the name of another open workbook, Excel will send the tab there, which is a different result. The position list controls where the sheet appears when placing it into an existing workbook; for a new book, it is usually enough to leave the default position.
  5. Choose whether to move or copy. Tick Create a copy to leave the source tab in place and make a duplicate in the new workbook. This is usually the safer choice when you are exporting a report, sharing a working version, or may need the original later. If you leave the box unticked, Excel moves the tab: it will appear in the new workbook and be removed from the source workbook. Make this choice deliberately; a move is not the same as saving a duplicate file.
  6. Confirm the operation. Click OK. Excel creates and opens the new workbook with the selected sheet. If you chose to copy, check that the original workbook is still open and still contains its tab. If you chose to move, verify that the sheet is now in the new workbook and no longer in the source. The source workbook may show an unsaved-change indicator after a move because its sheet structure changed.
  7. Review the exported sheet. Check the visible values, formulas, layout, column widths, number formats, charts, and print layout. Click a few formula cells and inspect the formula bar. A formula that referred only to cells on the copied sheet may work as before, while one that relied on another tab or file may still depend on the original workbook. Look for error values such as #REF! and test any important filters or drop-downs.
  8. Save the new workbook with a clear name. In the new workbook, select File > Save As, choose a folder, enter a distinct file name, and select the appropriate file type before saving. For a standard workbook without VBA, Excel Workbook (*.xlsx) is typical. If the workbook needs to retain VBA macros, use a macro-enabled format such as Excel Macro-Enabled Workbook (*.xlsm); saving macro content as .xlsx removes it. Make sure the title bar or Save As location shows the new file, not the source file.
  9. Save the source workbook if you moved the tab. If you moved rather than copied the sheet, return to the source workbook and save it if you want the removal to persist. If you meant to preserve the original and accidentally moved the sheet, use Ctrl+Z immediately while the operation is still undoable, or close the source without saving and reopen it. On Mac, use Command+Z to undo. Do not rely on undo after closing or making many additional changes.
  10. Confirm both files are usable. If you copied the tab, save and reopen the new file, then confirm the sheet is present and the source remains intact. If the new file is for someone else, consider whether they will also need linked workbooks, data access, or instructions to refresh connections. A quick reopen check can reveal an unsaved file, an unexpected extension, or a prompt about links before you share it.

Mac and web notes: In Excel for Mac, Control-click or right-click the sheet tab and choose Move or Copy; then select (new book) and choose whether to create a copy. Save the resulting workbook using File > Save As. In Excel for the web, if the sheet-tab menu does not offer the move-or-copy-to-new-workbook option, open the file in the desktop app and use the steps above. A cell-range copy and paste in the browser is not equivalent to exporting a complete worksheet.

Common Mistakes

  • Forgetting Create a copy. With the box unticked, Excel moves the sheet and removes it from the original workbook. If you need both versions, tick the box before confirming.
  • Choosing the wrong destination. Selecting another open workbook instead of (new book) places the tab in that workbook. Verify the To book selection in the dialog before clicking OK.
  • Assuming every formula becomes independent. A copied sheet can retain references to other sheets or files. For example, a formula that draws a value from a separate source tab may continue to depend on that source after export. Check formulas and links before sharing the new workbook.
  • Saving over the source file. Give the new workbook a distinct file name and confirm the save location. Otherwise, it is possible to replace the original file or mistake one open workbook for another.
  • Using the wrong file format. Saving a workbook that needs macros as .xlsx removes VBA content. Choose .xlsm when macros must be retained, and review any Excel warning about unsupported features.
  • Expecting the tab to carry every workbook feature. A worksheet transfer is not a complete copy of the entire source workbook. Other sheets, workbook-level names, connections, and supporting data may not be included or may behave differently. Review anything the exported sheet depends on.

Tips

  • Copy first when uncertain. Creating a copy is a low-risk way to export while keeping a source version. You can verify the new file before deciding whether the original tab should be removed.
  • Keep related sheets together when necessary. If the sheet contains formulas that refer to other tabs, export those supporting tabs too, or plan to replace the references with self-contained values or data. Do not convert formulas to values until you have a backup and know that the results no longer need to update.
  • Use a descriptive name. Rename the sheet tab if a clearer name will help the recipient, then use a file name that describes the content and date or reporting period. Avoid names that make the new file look like the original master workbook.
  • Check hidden content. A sheet may contain hidden rows or columns, hidden objects, or filtered-out records. Review the sheet before export if the recipient should see all data. Hiding rows or columns is not the same as removing sensitive information.
  • Protect confidential information. Exporting a single tab does not guarantee that every trace of other workbook content is absent. Check the new workbook for links, comments, hidden data, and workbook properties before distributing sensitive material. Share only what the recipient is authorized to receive.
  • Keep a backup before a major change. This is especially useful if you intend to move the tab, alter formulas, or remove supporting content. A backup gives you a fallback if the new workbook does not behave as expected.

Troubleshooting

Move or Copy is missing or unavailable: Confirm that you right-clicked the worksheet tab rather than a cell. If the workbook structure is protected, the command may be disabled; ask the workbook owner or use Review > Protect Workbook to check its protection state. You may need permission to unprotect it. In Excel for the web, open the workbook in the desktop app if the command is not available there.

The new workbook does not appear: Look for a new Excel window behind the source workbook or check the taskbar for another open workbook. If you selected a different open workbook in To book, the sheet may have gone there instead. Repeat the operation with (new book) selected, checking the destination before you click OK.

Formulas show errors or external references: Inspect the formula bar and use Data > Workbook Links if Excel displays workbook links for the file. The exact link tools shown can vary with the workbook and Excel build. If the sheet depends on other tabs, copy those tabs too or update the formulas so they point to valid data in the new workbook. Do not delete the original file until you have verified the new workbook.

Charts, drop-downs, or formatting look different: Compare the new sheet with the source and check whether its source ranges or named ranges were on another tab. Some chart series and data validation lists rely on data beyond the exported sheet. Restore the required source data or edit the chart and validation references to point to content that exists in the new workbook.

Excel warns about links or unsupported features when saving: Read the prompt before choosing a format. Keep .xlsm if the workbook needs VBA, and preserve links only if they are intentional and the recipient can access their targets. If a feature will be lost in the selected format, cancel, save a separate copy in a compatible format, and verify that copy before replacing or sharing anything.

Frequently Asked Questions

Does exporting a tab delete it from the original workbook?

Only if you move the sheet. In the Move or Copy dialog, tick Create a copy to keep the original tab. If you leave it unticked, Excel moves the sheet to the new workbook and removes it from the source.

Will formulas work in the new workbook?

Formulas that use data on the transferred sheet generally have the needed cells available, but formulas that refer to other sheets or files may rely on links to the source. Check key formulas and look for errors before you share the exported file.

Can I export more than one tab at once?

Yes. Select multiple sheet tabs first, then right-click one of the selected tabs and choose Move or Copy. Use Ctrl-click to select separate tabs on Windows, or Shift-click to select a consecutive range. On Mac, use Command-click for separate tabs and Shift-click for a range. Choose (new book), decide whether to create a copy, and review the resulting workbook. Take care not to include tabs that should remain private.

Can I export a tab in Excel for the web?

Available sheet-management options can differ in the browser. If the sheet-tab menu does not include the required Move or Copy destination, choose the option to open the workbook in the desktop app and export it there. Copying and pasting cells in the browser will not preserve a complete worksheet in the same way.

What happens to macros when I make a new workbook?

A sheet transfer is not a reliable way to bring every macro in the source workbook into a separate file. If the new workbook must retain VBA, save it as .xlsm and check that the necessary code is present. Excel removes VBA content if you save as .xlsx.

Can I undo a sheet move?

Usually, you can undo the operation immediately with Ctrl+Z on Windows or Command+Z on Mac. If you have already closed the workbook or made further changes, undo may no longer be available. If you moved the tab by mistake, closing the source workbook without saving and reopening it can restore the prior version.

Related

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.