To duplicate something in Microsoft Excel, first decide whether you need a copy of the entire workbook, one worksheet, or a range of cells: use File > Save As for a workbook, Move or Copy for a sheet, or copy and paste for cells. These methods create a separate copy while leaving the original available. You need Excel or access to Excel for the web, plus permission to save in the destination location.
What You’ll Need
- The workbook you want to copy, open in Excel or available in File Explorer or Finder.
- A destination folder or OneDrive location where you can save the copy.
- A clear new file or sheet name, especially if you will keep both versions open or stored together.
- If the workbook is shared, permission to edit or create files in its location. You may need to ask the owner before making a copy.
Microsoft Excel is the application, so you generally do not duplicate the program itself. You duplicate a workbook (the Excel file), a worksheet inside a workbook, or selected content. The right choice depends on what needs to stay together and what you plan to change.
Step-by-Step
- Choose what you want to duplicate. If you need a complete backup or a new version with all the workbook’s sheets, choose the workbook method in Step 2. If only one tab needs to be reused, use Step 3. To repeat a table, block of cells, row, or column, use Steps 4 or 5. Avoid copying the entire workbook when you only need a small range; the copy may also carry hidden sheets, connections, and data you did not intend to share.
- Make a copy of the entire workbook in Excel for Windows. Open the workbook, select File > Save As > Browse, choose a folder, and enter a different file name. Select Save. Excel now saves your open work under that new name, so check the title bar before editing if you want to be certain which version is active. For a file stored in OneDrive or SharePoint, use File > Save As and select the option to save a copy if it appears; choose a destination and name rather than overwriting the shared original. Saving a copy creates a new workbook file, but it does not automatically remove external links or connections to other files.
- Save a workbook copy in Excel for the web or on Mac. In Excel for the web, open the workbook and select File > Save As > Save a Copy, then choose a location and name when prompted. The exact options can vary with your organization’s OneDrive or SharePoint settings. In Excel for Mac, use File > Save As, choose where to save, enter a new name, and save. If the Mac dialog shows a format option, keep an Excel workbook format such as .xlsx unless you specifically need another format. Confirm the saved copy is in the intended folder before making changes.
- Duplicate a worksheet in desktop Excel. Right-click the sheet tab at the bottom of the window and choose Move or Copy. In the dialog, select the workbook where the copy should go under To book. To place the copy beside the original, choose the original workbook and select where it should appear under Before sheet. Check Create a copy, then select OK. Excel adds a new tab, usually with a number appended to its name. Rename it by double-clicking the tab, typing a distinct name, and pressing Enter. On Mac, Control-click or right-click the sheet tab and choose Move or Copy; the dialog’s layout may differ slightly. In Excel for the web, right-click the sheet tab and choose Duplicate when that command is available.
- Copy a range of cells. Select the cells, press Ctrl+C on Windows or Command+C on Mac, select the upper-left destination cell, then press Ctrl+V or Command+V. The destination should be large enough for the copied range. The pasted copy normally includes formulas, formatting, and values. Relative cell references in formulas may adjust to the new location, which is often useful but can change the result. If you need fixed references, check the formulas after pasting or use absolute references in the original formula.
- Choose what to paste when you do not need everything. After copying, select the destination and use Home > Paste or the paste options that appear. Choose Values if you want the displayed results without formulas, or Formulas if you want formulas without the original formatting. Available paste choices depend on the copied content and Excel version. For example, copying a formatted schedule and pasting values can help you preserve the results without carrying over the source’s color scheme. Check the pasted cells before deleting or changing the source.
- Duplicate whole rows or columns without replacing existing data. Select the row number or column letter, copy it, then right-click the row or column header where it should be inserted and choose Insert Copied Cells. This inserts a duplicate and shifts existing content out of the way. If you instead paste into an occupied range, Excel can replace its contents. For a quick duplicate directly next to a row, copy the row, right-click the next row number, and use Insert Copied Cells. Inspect formulas and references afterward, particularly if the sheet uses totals or structured tables.
Once you have made the duplicate, compare its name and location with the original. If it is a workbook copy, look at the open file name and save location. If it is a sheet copy, check the new tab. If it is a range, confirm that the full intended block was pasted and that no existing data was overwritten.
Common Mistakes
- Using Save instead of Save As: Save updates the current workbook; it does not create a separately named version. Use Save As or Save a Copy when you need another file.
- Forgetting Create a copy: In the Move or Copy dialog, leaving this unchecked moves the sheet out of its original location rather than duplicating it. If the sheet seems to disappear, check the destination workbook before trying again.
- Pasting over useful data: Clicking an occupied cell and pressing Ctrl+V replaces the selected area. Insert copied cells when you need to preserve and shift existing rows or columns.
- Assuming a copy is independent: A copied worksheet can retain formulas, defined names, queries, or links that refer to other sheets or workbooks. A copied workbook can also continue to reference external files. Check important formulas and data connections before distributing the copy.
- Using an identical name: Two files with the same name in one folder cannot be kept as separate files; saving may prompt you to replace the existing one. Give the copy a descriptive name, such as Budget – Draft, and check the destination folder.
- Copying only visible cells by accident: Filters and hidden rows can affect what you see and select. If the duplicate must contain every record, review the filter and hidden rows before copying.
Tips
- Keep the original unchanged until you have opened and checked the duplicate. For important workbooks, create a backup before editing either version.
- Use a naming pattern that communicates purpose and date, such as Inventory – Working Copy – 2026-11-03. Do not rely on names like Copy or Final if you keep several versions.
- When duplicating a sheet as a template, clear only the input cells you intend to reuse. Deleting whole rows or columns may break formulas, charts, or references elsewhere in the workbook.
- After copying a sheet, verify that formulas, formatting, print settings, charts, and filters came across as expected. A quick review matters most when the sheet feeds summaries or reports.
- If sharing the duplicate, check for confidential information, hidden worksheets, comments, and external connections. A file copy can contain more than what is visible on the active sheet.
Troubleshooting
The copy is not appearing where expected. Check the destination folder or OneDrive location, and confirm the file name. In Excel, use File > Open > Recent to look for a recently saved copy. If you duplicated a sheet, look along the sheet tabs; it may be placed at the far end or named with a number. In the Move or Copy dialog, verify the selected destination workbook.
Excel says the file is read-only or you do not have permission. A shared workbook may be protected or stored in a folder where you cannot create files. Try File > Save As and choose a folder you control, such as Documents. If the workbook is managed by an organization, ask its owner or administrator for the required access rather than trying to bypass protection.
The formulas changed after copying. Excel normally adjusts relative references when formulas move or are pasted to another location. Compare the original and duplicate formulas, and correct any references that should point to a fixed cell or a particular sheet. Also check whether a formula depends on another workbook that is no longer available.
The copied sheet or range looks different. Check the paste options, row heights, column widths, merged cells, hidden rows, and conditional formatting. A regular paste may not reproduce every display setting in the way you expect. For a full sheet duplicate, use Move or Copy with Create a copy, rather than selecting only the visible cells and pasting them into a new sheet.
The file will not save or changes are missing. Confirm that Excel is connected to the network if the file is stored online, and check for a sync or upload warning. Save a new copy to a local folder if you need to secure your work immediately, then resolve the connection or permission issue before replacing any shared version.
Frequently Asked Questions
Can I duplicate an Excel workbook without changing the original?
Yes. Use File > Save As in desktop Excel or File > Save As > Save a Copy in Excel for the web. Choose a new name and destination. Then confirm you are editing the copy, not the source file.
How do I duplicate a sheet in the same workbook?
Right-click the sheet tab, choose Move or Copy, select the same workbook under To book, check Create a copy, and select OK. Rename the new tab so you can distinguish it from the original.
Will duplicating a worksheet copy its formulas and formatting?
Usually, yes. A sheet duplicate generally carries formulas, cell formatting, and much of the sheet layout. Formulas may still refer to other tabs or external workbooks, so check important references and connections.
Can I duplicate Excel on my computer?
If you mean the Microsoft Excel application, you do not need to duplicate it to make another spreadsheet. Create a copy of the workbook instead. Installing another copy of the application is a separate software and licensing matter.
How do I copy cells without copying their formulas?
Copy the cells, select the destination, and use the Values paste option from Home > Paste. This pastes the calculated results rather than the formulas. Check the destination to confirm it contains the values you intended.
Related
- Delete Blank Rows in Excel Quickly: Safe Ways to Clean
- How to Delete Blank Cells in Excel Without Losing Data
- How to Delete an Excel File from a SharePoint Site
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 Change Font View Size in Outlook on Any DeviceTo make email text easier to read in Outlook, enlarge the message view: in classic Outlook for Windows,…
- Jotform to Google Sheets: Setup, Syncing, and FixesTo send Jotform responses to Google Sheets, open the form in Jotform, go to Settings > Integrations, search…
- Conditional Formatting for Overdue Dates in Excel: GuideIn Excel for Microsoft 365 on Windows, select the date cells, choose Home > Conditional Formatting > New…
- Find Duplicates in Google Sheets: Methods That WorkTo find duplicates in Google Sheets, select the cells, then choose Format > Conditional formatting and use a…
- How to Delete a Line in Excel: Rows, Cells, and DataTo delete a line in Excel when you mean a whole row, click its numbered row heading, right-click,…
- Excel R1C1 Reference: Meaning, Examples, and SettingsIn Excel, R1C1 is a cell-reference style that identifies a cell by its row number and column number:…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.