How to Save One Sheet in Excel as a Separate File

To save one sheet in Excel as its own file, right-click the sheet’s 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 only that sheet, which you then save with File > Save or Ctrl + S. The original workbook keeps all of its sheets.

These steps are for Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 on Windows, and they match Microsoft’s support pages. Excel for Mac uses the same dialog. Excel for the web needs a workaround. Both are covered below.

Why Save As Doesn’t Work for One Sheet

An Excel file is a workbook, and each tab inside it is a worksheet. File > Save As always saves the whole workbook, even if you’ve clicked on one tab first. To end up with a file that holds a single sheet, you first copy that sheet into a new workbook and then save the new workbook.

Save One Sheet as a New Workbook on Windows

1. Open the workbook and save it, so you have a clean starting point.
2. At the bottom of the window, right-click the tab of the sheet you want to save. A menu appears.
3. Click Move or Copy. The Move or Copy dialog box opens.
4. Click the To book drop-down and choose (new book).
5. Check the Create a copy box at the bottom of the dialog. If you skip this, Excel moves the sheet out of your original workbook instead of copying it.
6. Click OK. A new Excel window opens, named something like Book1, with your sheet as its only tab.

7. Press Ctrl + S (or click File > Save), choose a folder, type a file name, and leave the type as Excel Workbook (*.xlsx).
8. Click Save.

Microsoft describes this method in its Save a worksheet article. The copy keeps the sheet’s data, formatting, column widths and formulas.

To confirm it worked, look at the tab bar of the new window. It should show one tab with your sheet’s name, and the title bar should show the file name you just typed. Switch back to the original workbook and check that its tabs are all still there.

To save several sheets together, hold Ctrl and click each tab before you right-click, then follow the same steps. All of the selected sheets go into one new workbook. Afterward, click any single tab in the original workbook to ungroup the sheets so your next edits only affect one sheet.

Save One Sheet in Excel for Mac

1. Click the tab of the sheet you want.
2. Click Edit > Sheet > Move or Copy Sheet in the menu bar. You can also right-click the tab and choose Move or Copy.
3. In To book, choose (new book). If your version doesn’t list it, click Cancel, create a blank workbook with File > New Workbook, return to the original file, and choose the blank workbook in To book instead.
4. Check Create a copy and click OK.
5. Press Command + S, name the new workbook, and click Save.

Microsoft’s guide to moving or copying a sheet in Excel for Mac covers the Edit > Sheet menu and the Create a copy box.

Save One Sheet in Excel for the Web

Excel for the web can’t put a sheet into a new workbook file by itself. Depending on your version, right-clicking a tab offers Duplicate, which copies the sheet inside the same workbook, or a Move or Copy command without a (new book) choice. Use one of these options:

• Open it in the desktop app. Click the Editing drop-down in the upper-right corner, choose Open in Desktop App, and follow the Windows or Mac steps above.
• Copy the cells. Click the box above row 1 and left of column A to select the whole sheet (or press Ctrl + Spacebar, then Shift + Spacebar), and press Ctrl + C. Create a new blank workbook, click cell A1, and press Ctrl + V. This removes conditional formatting, and items like column widths may not carry over either, so check the result before you share it.

If you would rather keep one sheet by clearing out the rest of a copy, here is how to remove a worksheet tab in Excel Online. To keep every sheet together instead, you can download a copy of the whole workbook from Excel Online.

Check Formulas That Point to Other Sheets

If the copied sheet has formulas that pull data from other tabs, those formulas now point back to the original workbook file. When someone else opens your one-sheet file, Excel may show a security warning about external links, or the numbers may not update. Charts using data from other sheets and 3-D references (formulas that span several sheets) can also change or break when a sheet is moved or copied.

To see whether that’s happening, go to Data > Workbook Links in the new workbook. It sits in the Queries & Connections group; older versions call it Edit Links. If any links appear, use the break option at the top of the pane (or Break Link in the older dialog) to replace those formulas with their current values. Microsoft’s Manage workbook links page warns that breaking a link can’t be undone, so do this only in the copy, never in your original workbook.

If you only need to send the numbers, a quicker option is to copy the cells and use Home > Paste > Values in a blank workbook. That pastes results instead of formulas.

Save One Sheet as a PDF or CSV

You don’t always need a new workbook. Excel can export just the active sheet in other formats:

• PDF: Click the sheet tab, go to File > Save As (or Save a Copy), choose PDF as the file type, click Options, select Active sheet(s), and click OK, then Save. File > Export > Create PDF/XPS Document opens the same Options button.

• CSV: Click the sheet tab, go to File > Save As, and choose CSV UTF-8 (Comma delimited) or CSV (Comma delimited). Saving as CSV only saves the active sheet and removes all formatting. After saving, close the file and reopen your original .xlsx to keep working, since the open window is now the CSV version.

A PDF keeps the sheet’s look but can’t be edited in Excel. A CSV keeps only the values, which suits importing into another program. Choose the new workbook method when the recipient needs to work with formulas and formatting.

Before you create a PDF, it helps to fit the spreadsheet on one page in Excel.

Troubleshooting

• Move or Copy is grayed out. The workbook’s structure is protected. Go to Review > Protect Workbook and enter the password if you have it, then try again.
• The sheet disappeared from the original workbook. Create a copy wasn’t checked, so the sheet was moved. Moving can’t be undone with Ctrl + Z, but you can close the original workbook without saving and reopen it, and the sheet will be back. If you already saved, try the steps to restore a deleted worksheet in Excel.
• Macros are missing from the new file. The .xlsx format can’t store VBA macros. Save the new workbook as Excel Macro-Enabled Workbook (*.xlsm) instead, and note that macros stored in a module aren’t copied with the sheet.
• Formulas show #REF! or old numbers. The formulas pointed to sheets that didn’t come along. Break the links as described above, or copy the missing sheets into the new workbook too.

Frequently Asked Questions