To export one Excel tab as a separate file, right-click its sheet tab, choose Move or Copy, select (new book) in the To book list, check Create a copy, and click OK. Excel opens a new workbook containing that worksheet; use File > Save As to save it as its own Excel file. This keeps the original workbook intact and is the practical way to give one tab its own workbook.
A worksheet tab is already a sheet inside a workbook, so exporting it usually means copying that sheet into a new workbook rather than creating another sheet in the same file. The steps below are for Excel for Microsoft 365 on Windows. The same basic approach works in desktop Excel on Mac, although some menu labels and shortcuts differ.
What You’ll Need
- The source Excel workbook, saved in a location you can access.
- Excel for Microsoft 365 desktop on Windows or Mac. You can use Excel for the web for some sheet-copy tasks, but the desktop app provides the most dependable options for transferring a worksheet and saving it as a separate file.
- A folder and filename for the exported workbook. If the sheet contains sensitive information, choose a secure location before sharing it.
- Optional: a backup copy of the source file, especially if the worksheet contains macros, queries, links, charts, or other workbook-dependent features.
Step-by-Step
- Open the source workbook. Start Excel and open the file that contains the tab you want to export. If the workbook is read-only, protected, or opened from a shared location, check whether you have permission to make a copy. If you have unsaved changes to the sheet, save the source workbook first so the new copy includes the latest version. For a shared workbook, confirm with collaborators that you are exporting the intended version.
- Identify the correct tab. Look along the bottom of the Excel window and locate the worksheet tab. If the tab is hidden, right-click a visible tab and choose Unhide, select the worksheet, and click OK. If there are many tabs, use the sheet navigation controls at the lower-left of the window or the tab list to locate it. Confirm the sheet name and contents before continuing; worksheets with similar names are easy to mix up.
- Open the Move or Copy dialog. Right-click the tab you want to export and choose Move or Copy. In Excel for Microsoft 365 on Windows, this opens the Move or Copy dialog. Do not choose Delete, Rename, or Hide by mistake. If right-clicking is unavailable on your device, select the sheet and use Home > Format > Move or Copy Sheet. On a Mac, Control-click or right-click the sheet tab and choose Move or Copy; the exact placement of the command can vary slightly by Excel release.
- Choose a new workbook as the destination. In the To book list, select (new book). This tells Excel to create a separate workbook for the selected sheet. The list can also show other workbooks that are open, so make sure you choose (new book), not another file, if you want a distinct export. The Before sheet list controls where the sheet is placed in the destination; for a new workbook, it is usually sufficient to leave the default selection.
- Check Create a copy. Tick the Create a copy box before confirming. This is essential if you want to retain the sheet in its original workbook. With the box unchecked, Excel moves the worksheet out of the source workbook instead of duplicating it. A move can change how the source file works, particularly when other sheets contain formulas that refer to the tab being moved. Check the box even if you expect to save the new workbook immediately.
- Create and inspect the copied sheet. Click OK. Excel opens a new workbook containing a copy of the selected worksheet. Look at the new workbook’s title bar or window to verify that you are working in the new file, not the source. Check the sheet name, visible data, column widths, number formats, formulas, and any charts or objects that matter. If the source sheet has hidden rows, columns, or objects, consider whether those should remain hidden in the exported version.
- Save the new workbook under a clear name. Choose File > Save As, browse to the folder where the separate file should go, type a descriptive filename, and select the file type. For a standard workbook without macros, choose Excel Workbook (*.xlsx). Click Save. Excel may display a format or compatibility notice; read it before accepting, especially if the sheet includes features that may not be supported in the selected format. Saving with a new name helps avoid overwriting the source workbook.
- Verify the saved file. If practical, close the new workbook and open the saved file from its folder. Confirm that the exported sheet is present and that its key content displays correctly. Check that the file has the intended extension and is in the intended location. This final check catches mistakes such as saving the wrong workbook, choosing an unintended folder, or leaving the export unsaved. Keep the original workbook until you are satisfied with the separate copy.
For a one-time transfer, these steps are usually safer than selecting cells and pasting them into a blank workbook. Copying the worksheet carries more of its sheet-level layout with it, including formatting, widths, and many objects. It does not guarantee that every feature will work independently, so inspect the result before distributing it.
Common Mistakes
Forgetting Create a copy. This is the most consequential mistake. If the box is not checked, Excel moves the sheet, removing it from the original workbook. If you notice immediately, you may be able to undo the move with Ctrl+Z on Windows or Command+Z on Mac, but do not rely on undo after closing files or making other changes. Restore the source from a backup if needed.
Choosing an open workbook instead of (new book). The To book list may contain several filenames. Selecting one of them transfers the sheet into that workbook rather than creating a standalone file. If you already copied it to the wrong destination, repeat the operation and select (new book); then close the unintended destination without saving if you do not want to keep that change.
Assuming the copied sheet is fully independent. Formulas on the sheet may refer to other tabs in the original workbook. After copying, those formulas can still refer to the original workbook, or Excel may show references that need attention. Named ranges, data validation lists, PivotTables, queries, and charts can also depend on workbook-level data or settings. Review important features rather than assuming a visually correct sheet is self-contained.
Saving in a format that removes features. A workbook with macros needs a macro-enabled format such as Excel Macro-Enabled Workbook (*.xlsm). Saving it as .xlsx removes VBA macros. Similarly, older or non-Excel formats may not preserve all Excel features. Choose a format that supports the content you need to keep.
Overwriting the source file. When using Save As, check both the folder and filename before clicking Save. A similar filename can make it hard to tell the export from the original. Use a name that identifies the sheet or its purpose, and do not replace the original unless that is intentional.
Tips
Give the exported file a name that is clear outside the context of the original workbook. For example, if the source is a quarterly report and the tab is named West Region, a filename such as Quarterly Report – West Region.xlsx is more useful than Sheet1.xlsx. Include a date or version only if it helps people distinguish copies, and keep the naming style consistent across related exports.
Before exporting, decide whether recipients need formulas or just the current displayed values. A copied worksheet generally retains formulas, but formulas that refer to other sheets may not produce the intended result when those sheets are absent. If recipients only need a static report, you can make a separate copy of the exported file and replace formulas with values there. Select the relevant cells, copy them, then use Home > Paste > Paste Values. Keep an untouched export if you may need to revise formulas later.
Check the sheet for hidden or private information before sharing it. Hiding rows or columns does not remove their contents. Also inspect comments or notes, hidden objects, and any data visible through filters. If the exported workbook contains sensitive material, remove information that recipients should not receive rather than merely hiding it.
If you need to export several tabs, repeat the Move or Copy process for each one, choosing the same new destination workbook if you want them together. If each tab needs to be a separate file, create a new workbook for each sheet and save each under a distinct name. For a one-off task, using the dialog is usually clearer than trying to automate the process.
On Windows, Ctrl+S saves the active workbook; on Mac, use Command+S. These shortcuts save the current file but do not create a separate export by themselves. Use File > Save As for the new workbook, then use the appropriate save shortcut for later changes.
Troubleshooting
The Move or Copy command is unavailable. Check whether the workbook structure is protected. In Excel for Windows, open Review and look for Protect Workbook; if workbook structure protection is enabled, you may need the password or permission from the file owner to change the sheet structure. A worksheet being protected is different from the workbook structure being protected. If the file is read-only or opened in a restricted shared location, save a permitted working copy first or ask the owner for access.
The copied sheet shows errors or broken references. Review formulas that refer to other sheets, named ranges, or external files. A formula can be intact but still depend on source data that was not copied. If the new workbook is meant to stand alone, bring over the required supporting sheets or data, adjust the formulas, or replace formulas with values if live calculations are not needed. Check charts and PivotTables too, since their source ranges may be elsewhere in the original workbook.
Formatting, charts, or controls look different. Reopen the exported workbook in desktop Excel and compare it with the original. Some features rely on workbook themes, add-ins, linked data, or objects that do not transfer as expected. If a chart is blank, inspect its data source; if a control or button no longer works, it may depend on a macro or code that was not carried over. Recreate the affected item in the new workbook or retain the required supporting content.
The new workbook was created, but you cannot find the file. Creating the copy opens a new workbook but does not necessarily save it. Use File > Save As to choose a location, then check Excel’s recent files or the folder you selected. If you closed the new workbook without saving, repeat the copy and save it before closing.
You are using Excel for the web. The browser version’s available sheet-copy options can vary with the workbook and service features. If you do not see a way to copy the tab to a new workbook, open the file in the desktop Excel app and use the Move or Copy dialog. If you must stay in the browser, check whether your version offers a sheet tab context-menu option for moving or copying, and verify the result in a separate saved file.
Frequently Asked Questions
Does exporting a tab delete it from the original workbook?
No, not when you check Create a copy in the Move or Copy dialog. If you leave that box unchecked, Excel moves the sheet and removes it from the original workbook.
Can I export a worksheet without its formulas?
Yes. Copy the worksheet to a new workbook, then select the cells whose formulas should become fixed values and choose Home > Paste > Paste Values. Do this only in the exported copy if you want to preserve the original formulas in the source workbook.
Will formulas that refer to other tabs still work?
Not always. If a formula depends on a sheet that was not copied, it may keep an external reference or return an error. Copy the dependent sheets too, update the formulas, or convert the results to values if the export does not need to recalculate.
Can I export a tab as a PDF instead of an Excel file?
Yes. First select the worksheet, then choose File > Export or File > Save As and select PDF, depending on the options shown in your Excel version. Check the print area, orientation, scaling, and page breaks first, since a PDF captures a print-style layout rather than an editable worksheet.
Can I export a tab to another workbook that is already open?
Yes. In Move or Copy, choose the open workbook in the To book list, then choose where the sheet should appear and check Create a copy if the original must remain. This adds the sheet to that workbook; it does not create a separate file unless you save that destination workbook under its own name.
Does this method work for a macro-enabled worksheet?
The sheet can be copied, but macros are stored in a VBA project associated with the workbook, not simply as ordinary cell content on one tab. Save the destination as .xlsm if it must retain VBA, and verify that the required macro code and any buttons or controls are available in the new workbook.
Related
- How to Duplicate a Page in Excel and Keep Its Layout
- Duplicate a Sheet in Excel: Keyboard Shortcut and Steps
- How to Double Freeze Panes in Excel: Rows and Columns
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Dotted Line in Word: 3 Easy MethodsTo insert a dotted line in Microsoft Word, use a paragraph border for a divider that stretches across…
- How to Lock Cells in Excel While Scrolling a WorksheetTo keep headings or columns visible while you scroll in Excel for Microsoft 365 on Windows, select the…
- How to Subtotal Multiple Rows in Excel by GroupTo subtotal multiple rows in Excel by category, sort your data by that category, select a cell in…
- How to Delete a Page With Content in Microsoft WordTo delete a page that contains text, pictures, or other content in Microsoft Word for Microsoft 365 on…
- Group Rows in Excel by Values: A Practical How-ToTo group rows in Excel by matching values, sort the list by the column you want to group,…
- Excel File Merge Online Free: Safe Ways to Combine WorkbooksYes, you can merge Excel files online for free, but the best method depends on what you mean…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.