The simplest way to copy an entire sheet
To copy a whole Excel sheet, right-click the sheet tab at the bottom of your window and select Move or Copy. A dialog box opens. Choose the location where you want the copy to go — either in the same workbook (the file you have open) or a different one. Check the box that says Create a copy, then click OK. Excel duplicates the entire sheet with all its data, formulas, and formatting intact.
The sheet tab is the small labeled area at the very bottom of your spreadsheet, usually showing names like "Sheet1" or "Sales Data". If you do not see tabs, your sheet may be hidden — go to the Home tab in the ribbon, find Format, then Sheet, then Unhide.
This method copies everything at once. If you only need part of the sheet — certain columns, rows, or a range of cells — use the manual copy method instead, which takes about the same time and gives you more control.
Key Takeaways
- Right-click the sheet tab at the bottom, select Move or Copy, check Create a copy, and choose where the copy goes.
- The entire sheet copies with all data, formulas, and formatting preserved exactly as it was.
- To copy only part of a sheet, select the cells you want, press Ctrl+C (or Cmd+C on Mac), click where you want them, and press Ctrl+V.
- Pasting into a new sheet or workbook keeps the original sheet unchanged.
- If formulas reference cells outside the copied range, those references may break and need to be fixed manually.
Copying part of a sheet manually
Select the cells, rows, or columns you want to copy. Click on the first cell and drag to the last one, or click the first cell, hold Shift, and click the last cell. To select entire rows or columns, click the row number or column letter on the left or top edge of the sheet.
Once your selection is highlighted in blue, press Ctrl+C on Windows or Cmd+C on Mac. You will see a dotted border around your selection — this means the data is copied to your clipboard. Click the cell or sheet where you want to paste, then press Ctrl+V (or Cmd+V on Mac). The data appears exactly as it was, with all formatting and formulas included.
If you copy data from one sheet and paste it into another sheet in the same workbook, the paste happens when ready. If you are pasting into a different Excel file, make sure that file is already open, or open it first, then paste.
Pasting with special options
After you paste, a small icon appears next to your pasted data. Click it to see Paste Special options. These let you paste only certain parts of what you copied — for example, just the values without formulas, just the formatting without the data, or just the formulas without the formatting.
Paste Special is useful when you copy from one sheet and want to paste into another but do not want formulas to recalculate based on new cell positions. Select Paste Special, then choose Values only. This turns all formulas into their calculated results, so they stay the same no matter where you paste them.
You can also reach Paste Special by pressing Ctrl+Shift+V (Windows) or Cmd+Shift+V (Mac) after copying. A larger dialog opens with more detailed options for what gets pasted and how.
What happens to formulas when you copy
When you copy cells that contain formulas, Excel adjusts the cell references automatically. If a formula in cell B2 says =A2+10 and you copy it to cell B3, the formula becomes =A3+10. This is usually what you want — the formula adapts to its new location.
Sometimes this automatic adjustment breaks your sheet. If a formula references a specific cell that should not move — like a tax rate stored in cell E1 — use an absolute reference instead. Type the formula as =A2+$E$1. The dollar signs tell Excel to keep E1 fixed no matter where the formula is copied. When you copy this formula, it will always reference E1, not a different cell.
If you paste a formula into a new sheet and it shows an error like #REF!, the formula is trying to reference cells that do not exist in the new location. Use Paste Special and choose Values only to convert the formula to its result, or rewrite the formula to reference the correct cells in the new sheet.
Copying between different Excel files
Open both Excel files on your screen. You can arrange them side by side by opening the first file, then opening the second file, then using your operating system's window-snap feature. On Windows, drag a window to the left or right edge of your screen to snap it to half the screen. On Mac, hold the green maximize button in the top-left corner of a window and choose which side to snap to.
With both files visible, select the cells or sheet you want to copy from the first file and press Ctrl+C (or Cmd+C). Click into the second file and press Ctrl+V to paste. The data transfers between files exactly as it does within a single file.
If you are copying a whole sheet between files, use the Move or Copy method instead. Right-click the sheet tab, select Move or Copy, and in the dialog, use the dropdown that says To book to choose the other file. This method is more reliable for entire sheets because it preserves all formatting and hidden elements.
Undoing a copy or paste mistake
If you paste data in the wrong place or paste the wrong data, press Ctrl+Z (Windows) or Cmd+Z (Mac) when ready. This undoes the paste and restores your sheet to how it was before. You can undo multiple times by pressing Ctrl+Z again and again, stepping backward through your recent actions.
If you have already closed the file or saved it, undo may not work. In that case, reopen the file without saving the changes. Excel will ask if you want to recover the previous version — choose yes. If you have already saved, you will need to manually delete the pasted data or restore from a backup if your organization keeps one.
To prevent mistakes, always check what you have selected before pressing Ctrl+C, and always look at where your cursor is before pressing Ctrl+V. A few seconds of checking saves time fixing errors later.
Copying sheets with links to other sheets
If your sheet contains formulas that reference other sheets in the same workbook — for example, =Sheet2!A1+B2 — copying the sheet preserves those links. The copied sheet will still reference the original Sheet2, not a copy of Sheet2. This is usually correct, but check your formulas after copying to make sure they point to the sheets you intended.
If you copy a sheet to a different workbook entirely, those links break because the other workbook does not have the same sheet names. Excel will show #REF! errors in cells that had those formulas. To fix this, either use Paste Special and choose Values only to convert formulas to their results, or manually update the formulas to reference the correct sheets in the new workbook.
Frequently Asked Questions
Can I copy a sheet and give it a different name?
Yes. After copying the sheet, right-click its tab and select Rename Sheet. Type the new name and press Enter. The copy keeps all the data and formatting from the original, but now has its own name so you can tell them apart.
What if I copy a sheet but only want certain columns?
Copy the entire sheet first, then delete the columns you do not need. Right-click a column letter and select Delete. Or, instead of copying the whole sheet, select only the columns you want, copy them, and paste into a new sheet. The second method is faster if you only need a few columns.
Does copying a sheet also copy charts and images?
Yes. Charts, images, and all other objects on the sheet copy along with the data. If a chart is based on data in that sheet, the copied chart will reference the copied data, not the original.
Can I copy a sheet from an older Excel file format to a newer one?
Yes. Open both files, use Move or Copy to copy the sheet from the old file to the new one, and Excel handles the format conversion automatically. Save the new file when you are done. The data and formatting transfer without errors in most cases.
What does the dotted border around my selection mean?
The dotted border shows that your data is copied and ready to paste. It stays visible until you press Escape or copy something else. You can paste the same data multiple times while the dotted border is still showing — just click a new location and press Ctrl+V again.