To copy an Excel spreadsheet, choose what you need to duplicate: a worksheet, a selected range of cells, or the entire workbook. In Excel for Microsoft 365 on Windows, right-click a worksheet tab and select Move or Copy to duplicate a sheet, or use File > Save As to create a separate copy of the workbook.
Choose the right kind of copy
People use “spreadsheet” to mean different things in Excel. A workbook is the whole file, usually ending in .xlsx or .xlsm. It can contain several worksheets, which appear as tabs along the bottom of the window. A range is a selection of cells within a worksheet. The best copying method depends on which of those you want to preserve.
- Copy a worksheet to make another tab with the same layout and contents, such as a new monthly report based on last month’s.
- Copy a range to reuse a table or section of a sheet without duplicating the entire tab.
- Copy a workbook to make a separate file containing its worksheets and other workbook-level content.
Before copying, save any recent changes. If you are unsure which method is appropriate, copying the whole workbook is the broadest option; duplicating a worksheet is usually best when you only need another version of one tab.
Copy a worksheet in the same workbook
To duplicate a tab in the workbook you already have open, use Excel’s Move or Copy dialog. It lets you choose where the duplicate goes and helps prevent accidentally moving the original instead.
- Right-click the worksheet tab you want to copy.
- Select Move or Copy.
- In the To book list, select the current workbook.
- Choose where the new tab should appear under Before sheet.
- Check Create a copy, then select OK.
Excel adds a new tab, usually with a number appended to the original sheet name. Rename it by double-clicking the new tab, typing a distinctive name, and pressing Enter. For example, you might copy a tab called January and rename its duplicate February. Check dates and other month-specific labels before entering new information; copying does not automatically update every title or value.
On Windows, you can also hold Ctrl and drag a sheet tab to another position in the tab bar. A plus sign indicates that Excel will make a copy. If you want a dependable, clearly labeled method—or need to put the copy in another workbook—the Move or Copy dialog is easier to verify.
Copy a worksheet to another workbook
To copy a tab into a different workbook, first open both workbooks in Excel. Then right-click the source sheet tab and select Move or Copy. Choose the destination file in the To book list, select the position for the new tab, check Create a copy, and click OK. The destination workbook needs to be open to appear in the list. Choose (new book) if you want Excel to put the copied sheet in a new workbook.
After the copy appears, save the destination workbook. If the copied sheet contains formulas that refer to other tabs, charts, or named items, inspect them in the new location. Some references may still point to the original workbook, especially when the source workbook is closed or the referenced material was not copied. A formula that looks normal can still rely on data outside the new file.
On Mac, the Move or Copy dialog is also a reliable way to copy a worksheet between open workbooks; menu wording or window layout can differ slightly by Excel release. In Excel for the web, use the sheet-tab context menu and select Duplicate to copy a tab in the current workbook. Desktop Excel offers more options for moving a sheet between workbooks.
Make a separate copy of the whole workbook
If you want a separate file with the workbook’s full set of sheets, use File > Save As in Excel for Microsoft 365 on Windows. Choose a different folder or enter a new file name, then save. The original file remains in its original location, while the new file becomes the one you are editing. Check the title bar or use File > Open to confirm which file is active before making substantial changes.
For a workbook stored in OneDrive or SharePoint, the available command may appear as Save a Copy or Save As, depending on how you opened it and the interface version. You can also save the current file, then use File Explorer to copy and paste it into another folder or give the duplicate a new name. In either case, save first so the duplicate includes your latest edits.
Keep the file type in mind. An .xlsx file does not store VBA macros; a macro-enabled workbook generally uses the .xlsm format. If Excel warns that a feature may be lost when saving in a different format, pause and select a format that supports the content you need. A file copy is not the same as exporting a worksheet to PDF or saving a plain-text copy of its values.
Copy cells or a table without copying the sheet
To copy part of a worksheet, select the cells, press Ctrl+C on Windows, click the destination’s upper-left cell, and press Ctrl+V. For example, selecting A1:D12 copies a 12-row, four-column block. You can paste into another area of the same sheet, another worksheet, or another open workbook. On Mac, use Command+C and Command+V instead of Ctrl+C and Ctrl+V.
A standard paste can bring over formulas, formatting, and other cell attributes, not just the visible words and numbers. Relative formula references may change to match the new location. If you only want the displayed results, use Home > Paste > Paste Special > Values. To copy only the appearance, choose the formatting option from the Paste menu. The paste options available can depend on the copied content and Excel version.
For a table that will be updated in the future, consider whether you need a one-time copy or a live connection. A normal copy creates another set of cells; subsequent edits to the original do not automatically update that copy. If the goal is to reuse a layout, copy the range and then review formulas, formatting, and any data validation rules before filling it in.
What a copy preserves—and what to check
A copied worksheet generally brings its cell contents and layout, including formulas, formatting, column widths, and objects such as charts on that sheet. Copying the whole workbook is more appropriate when you also need its other sheets and workbook-level setup. Even then, external data connections, links to other files, permissions, and cloud-sharing arrangements may depend on the original location or account.
Do not assume that every reference is self-contained. A copied formula may refer to another sheet that was not copied, or to a separate workbook. Named ranges and chart data sources can also depend on items outside the copied tab. After copying, inspect important formulas and charts, and look for Excel’s warning that links to other workbooks need updating. If the new copy is meant to stand alone, confirm that its required source data is present and that links point where you intend.
It is also easy to mistake a move for a copy. In the Move or Copy dialog, leaving Create a copy unchecked moves the original sheet out of its current position or workbook. If preserving the source matters, check that box before clicking OK.
Common problems and quick checks
- The destination workbook is missing from the list: Open it in Excel first, and confirm that it is not blocked by a prompt or an unsaved dialog.
- The new sheet has the wrong name: Rename the copied tab and check headings, dates, and labels inside the sheet too.
- Formulas show unexpected results: Check whether references shifted after a cell-range paste or still point to a sheet or file in the source workbook.
- The copy appears blank or incomplete: Check for filters, hidden rows or columns, and content outside the range you selected. A range copy only includes the cells selected.
- Excel reports a file-format warning: Review the format before saving, particularly if the workbook uses macros or other features that the chosen format may not retain.
For important files, save the original and the copy with clear, different names, such as Sales Report – Original and Sales Report – Draft. That makes it easier to tell which file you are editing and reduces the chance of overwriting your source.
Frequently Asked Questions
How do I copy an Excel sheet to a new workbook?
Right-click the sheet tab, select Move or Copy, choose (new book) in the destination list, check Create a copy, and select OK. Save the new workbook and check whether formulas or charts still rely on the original file.
How do I duplicate an Excel sheet without changing the original?
Use the Move or Copy dialog and check Create a copy before confirming. The unchecked option moves the sheet rather than leaving the original in place.
Can I copy an Excel spreadsheet to another file?
Yes. To copy just one tab, use Move or Copy and select the other open workbook. To copy the entire workbook, use File > Save As and save it under a different name or location.
How do I copy an Excel sheet and keep the formatting?
Use Move or Copy to duplicate a whole worksheet, which generally retains its layout and formatting. For selected cells, use a normal paste; if formatting is missing, use the formatting option in the Paste menu.
Why did formulas change when I copied cells?
Excel adjusts relative cell references when formulas are pasted in a different location. Copying a whole worksheet is different from pasting a range, and references to other sheets or workbooks may still point to their original sources. Review key formulas after copying.
Related
- Export to CSV vs Excel: Which Format Should You Choose?
- Extract Data from Google Maps to Excel: Practical Options
- Export Excel to Word: Methods and Formatting Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Merge Cells Command: Shortcuts, Options, and LimitsIn Excel for Microsoft 365 on Windows, select the cells you want to combine, then choose Home >…
- How to Delete a Blank Page in Word: Step-by-StepTo delete a blank page in Microsoft Word, turn on formatting marks, find the paragraph mark, page break,…
- How to Delete a Page in Microsoft Word Without Losing TextTo delete a page in Microsoft Word, select the page’s contents and press Delete, or remove the page…
- Excel Data Entry Form: Add an Image Box Step by StepTo add an image box to an Excel data entry form, place a picture in a worksheet cell…
- How to Create a Professional Email Signature in OutlookTo create a proper signature in Outlook, open the signature settings for your version of Outlook, write a…
- 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,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.