Yes. In Excel for Microsoft 365 on Windows, make a separate copy of an entire spreadsheet with File > Save As, copy a worksheet with the sheet tab’s Move or Copy command, or copy selected cells with Ctrl+C and Ctrl+V. Choose the method that matches what you want to duplicate: a workbook, one tab, or just part of a sheet.
What does “copy an Excel spreadsheet” mean?
People use “spreadsheet” to mean different things. An Excel file, usually ending in .xlsx or .xlsm, is called a workbook. A workbook can contain multiple worksheets, each shown as a tab along the bottom of the window. A worksheet contains cells arranged in rows and columns. You can copy any of these levels, but the result is different.
- Copy a workbook: Make another Excel file containing the workbook’s sheets and other saved content.
- Copy a worksheet: Add a duplicate tab to the same workbook or put a sheet into another open workbook.
- Copy cells: Duplicate a selected range, such as a table or a few formulas, within or between sheets.
For example, if you want a safe working version of a monthly report, copy the workbook. If you need a new month’s tab based on the previous month, copy the worksheet. If you only need a customer list from a larger file, copy the relevant cells. These choices matter because formulas, links, formatting, and workbook-level features may behave differently after copying.
Make a copy of the entire workbook
To create a second file while keeping the original, use Save As. In Excel for Microsoft 365 on Windows, open the workbook and select File > Save As > Browse. Choose a folder, enter a different file name, and select Save. Excel saves the workbook under the new name; it does not replace the original as long as you choose a distinct name and location.
If the file is stored in OneDrive or SharePoint, the available labels can vary with the account and location. Excel may show a Save a Copy option, or you can use Save As to choose a new name or folder. Check the destination and name before confirming. A copied file saved in a shared folder may still be visible to the people who have access to that folder.
Another option is to close the workbook and copy the file using File Explorer: select it, press Ctrl+C, open the destination folder, and press Ctrl+V. On a Mac, use Command+C and Command+V in Finder. Rename the new file so it is easy to distinguish from the original. This file-level copy is useful when you want a backup without opening Excel.
With either method, the copy generally includes the workbook’s sheets, formatting, formulas, and charts. Some connected data may still point to the same sources, and permissions are not necessarily made private just because the file has a new name. Review the copy before relying on it.
Copy one worksheet to another workbook
To copy a full worksheet in desktop Excel for Windows, open both the source workbook and the destination workbook. Right-click the worksheet tab you want to duplicate and select Move or Copy. In the dialog, choose the destination workbook from the To book list. Select where the copied sheet should appear, check Create a copy, and select OK. Without Create a copy checked, Excel moves the sheet instead of leaving the original in place.
To duplicate the sheet within the same workbook, choose that workbook in To book, select its position, and check Create a copy. Excel adds a new tab, often with a number in its name. Rename it by double-clicking the tab, typing a clear name, and pressing Enter. In Excel for Mac, the worksheet tab’s context menu also provides Move or Copy; dialog wording or placement can differ slightly by release.
In Excel for the web, you can make a copy of a workbook through File > Save As > Save a Copy. To duplicate a tab within a workbook, use the worksheet tab’s context menu and choose Duplicate if that command is available. If you need to move a sheet to a different workbook or depend on desktop-only options, open the file in the Excel desktop app and use Move or Copy.
Copy selected cells or a table
Select the cells you want, then press Ctrl+C on Windows or Command+C on Mac. Click the destination’s top-left cell and press Ctrl+V or Command+V. You can copy a rectangular range, a table, or a single cell. If the destination is in another workbook, open both workbooks first and select the destination cell before pasting.
Standard paste usually brings over values, formulas, formatting, and other cell content. To choose what to transfer, use Home > Paste, then select a paste option such as Values or Formulas when available. Paste Values is useful when you want the displayed results but not formulas that depend on the original sheet. Paste Special options can also help when you want formatting without replacing existing data.
For instance, copying a formatted sales table into a new workbook with regular paste may bring its formulas along. If those formulas refer to other tabs in the original workbook, the pasted cells might show errors or retain links to that file. If the destination only needs the current figures, choose a values-only paste and check that the totals still make sense.
Which copying method should you choose?
Use Save As or Save a Copy when the goal is an independent workbook with the full contents preserved. Use Move or Copy when you need a complete sheet, including its layout and formulas, in a workbook you already have open. Use copy and paste for a selected range, especially when you need to combine data or transfer only values.
- For a backup: Save a copy under a new name in a separate, appropriate location. A backup kept only beside the original may not help if that storage location becomes unavailable.
- For a template for next month: Copy the worksheet, rename it, and update the period-specific entries. Confirm that formulas point to the intended cells.
- For a static report: Copy the relevant cells and paste values if you do not want to carry over live formulas.
- For a complete handoff: Copy the workbook, then check its links, data connections, macros, and sharing settings before sending it.
Copying is not the same as exporting. Saving a workbook as a PDF, for example, creates a document for viewing or printing rather than another editable Excel workbook. Likewise, copying a worksheet is not necessarily a clean way to transfer only visible information: hidden rows, columns, or other sheet content may also be included.
What happens to formulas, links, and features?
A formula copied within the same workbook may adjust its relative cell references to fit its new location. Absolute references, marked with dollar signs, are designed to remain fixed when copied. If you copy a sheet to another workbook, formulas that refer to other sheets can behave differently depending on whether those referenced sheets are copied too. Excel may preserve a reference to the original workbook or show a prompt about links.
External links and data connections deserve particular attention. A workbook can contain formulas linked to another file, queries that retrieve data, or connections to other sources. Making a copy does not automatically create a separate copy of those sources or change where the workbook retrieves data. Refreshing a connection in the new file may still use the same source, and a link can fail if the referenced file is moved or unavailable.
Most ordinary workbook content—such as cell values, formulas, formatting, charts, and worksheet tabs—can be included in a workbook copy. However, some settings and features are tied to the file, account, or location. Check named ranges, external links, data connections, print settings, hidden sheets, and macros where relevant. A macro-enabled workbook generally needs to remain in a macro-enabled format, such as .xlsm, to retain its VBA project. Saving it as .xlsx can remove macros.
Common problems and how to avoid them
A frequent mistake is moving a worksheet unintentionally. In the Move or Copy dialog, leave Create a copy selected when the original tab must remain. Another is overwriting the source file: when making a workbook copy, verify both the destination folder and the new file name before saving.
Formulas that show unexpected values or errors may refer to cells or sheets outside the copied range. If you pasted only part of a worksheet, inspect formulas that refer to neighboring cells. If the copy should be independent, check for external workbook references rather than assuming that a new file name has removed them.
Formatting can also change when pasting into a destination with a different style, and copying a table into an existing table can affect its layout. If the result looks wrong, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then try a different paste option. Before sharing a copy, check for hidden worksheets, comments, personal details, and information in hidden rows or columns. A visible selection may not represent everything stored in the workbook.
Sharing, privacy, and safe copies
A new file is not automatically private. If you save it in a OneDrive or SharePoint folder shared with other people, those people may retain access through the folder’s permissions. To share with a different audience, review the file’s sharing settings and choose an appropriate location rather than relying on the new file name to control access.
Keep the original unchanged until you have checked the copy. Open the duplicate and confirm its name, important sheets, formulas, and any key totals. If it is a business or regulated document, follow the relevant organization rules for backups, retention, and handling sensitive information. Password protection, workbook protection, and access permissions serve different purposes; duplicating a workbook does not bypass a password or guarantee that the copied file has the same access controls.
Frequently Asked Questions
Can I copy an Excel spreadsheet without changing the original?
Yes. Use File > Save As or Save a Copy and choose a different name or destination. For a worksheet, use Move or Copy and check Create a copy. Confirm that you are not overwriting or moving the original.
How do I copy an Excel spreadsheet to a flash drive?
Save or copy the workbook file to the flash drive using File > Save As, or copy it in File Explorer on Windows or Finder on Mac. Safely eject the drive after the copy finishes, and open the file from the drive to confirm it is readable.
Can I copy only one tab from an Excel file?
Yes. In desktop Excel, right-click the tab, select Move or Copy, choose a destination workbook, check Create a copy, and select OK. If you only need a portion of the tab, select and copy those cells instead.
Why did formulas change after I copied a sheet?
Relative references can adjust when formulas are copied, while links to sheets or other workbooks may continue to point to their original locations. Review formulas and workbook links in the copy. Paste Values instead if you need fixed results rather than formulas.
Can I make a copy of an Excel spreadsheet online?
Yes. In Excel for the web, use File > Save As > Save a Copy to create another workbook. For a duplicate worksheet within a workbook, use the sheet tab context menu’s Duplicate command when available; use desktop Excel for sheet transfers that need Move or Copy.
Related
- Autofit Pictures in Excel: Fit Images to Cells
- Autofit Page in Excel: Fit a Worksheet to One Page
- Excel Autofit Shortcut Key: Resize 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
- Excel Flash Fill: How Patterns Work and When to Use ItIn Excel for Microsoft 365 on Windows, Flash Fill recognizes a pattern from examples you type and fills…
- How to Get Out of Replace Mode in Excel and Restore TypingTo get out of Overtype (replace) mode in Excel for Microsoft 365 on Windows, click inside the cell…
- How to Make One Page Landscape in Word 365: Step by StepTo make one page landscape in Word 365 while keeping the rest of the document portrait, isolate that…
- Excel Auto Group Rows by Cell Value: What You Can DoNo—not as a built-in rule that continuously groups rows whenever a cell value changes. In Excel for Microsoft…
- Excel Date Slicer by Month: Setup and TroubleshootingYes. In Excel for Microsoft 365 on Windows, create a PivotTable, group its date field by months, then…
- Google Sheets Checkbox Format: Setup, Values, and TipsIn Google Sheets, select the cells where you want boxes, then choose Insert > Checkbox. A checkbox is…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.