Duplicates in Google Sheets: Copy Cells and Rows Safely

To put duplicate data in Google Sheets, select the cells or row you want to copy, press Ctrl+C, click the destination, and press Ctrl+V. You can also duplicate an entire sheet from its tab menu. These methods make a second copy while leaving the original in place; choose the destination carefully if existing data must not be overwritten.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
The cells, rows, or sheet tab you want to duplicate, and enough empty space for the copy.
Optional: permission to edit the spreadsheet. View-only access will not let you make changes to the original file.

The steps below use Google Sheets in a browser. Keyboard shortcuts are for Windows or Chromebook; on a Mac, use Command instead of Ctrl for copying and pasting. Excel has similar copy-and-paste shortcuts, but its menus and sheet-tab commands can differ from the Google Sheets paths below.

Step-by-Step

Choose what you want to duplicate. For one value, click its cell. For a block, click the first cell and drag across the full range, or click the first cell, hold Shift, and click the last cell. To copy an entire row, click its numbered row heading at the left. To copy a whole worksheet, use the sheet-tab method in step 6 instead. Check that your selection includes all the information you intend to repeat, such as labels and formulas.
Copy the selection. Press Ctrl+C on Windows or Chromebook, or Command+C on a Mac. You can also right-click the selection and choose Copy. A moving dashed outline usually appears around the copied cells. Copying does not remove or change the original. Avoid choosing Cut: that moves the selection instead of creating a duplicate.
Pick a destination with enough room. Click the top-left cell where the copied range should begin. For example, if you copied A2:C4 and want the copy directly below it, click A5. Google Sheets pastes the range in the same shape and relative position, so a three-column by three-row selection needs a clear three-by-three destination. If the destination contains information, pause and decide whether you are willing to replace it.
Paste the duplicate. Press Ctrl+V on Windows or Chromebook, or Command+V on a Mac. You can also right-click the destination and select Paste. Wait for the cells to appear, then check the first and last rows or columns to confirm the full selection landed where expected. If you see a browser permission prompt for clipboard access, allow it or use the right-click menu.
Duplicate an entire row without overwriting the next row. First click the row number to select the whole row, then copy it. Right-click the row number where you want the new copy and choose Insert 1 row above or Insert 1 row below. Click the new row number and paste. Inserting a row first shifts existing data down or up, leaving a blank row for the duplicate. If your sheet has filters or protected ranges, make sure the inserted row is in the intended section and that you have permission to edit it.
Duplicate a whole sheet tab. At the bottom of the spreadsheet, find the tab you want to copy. Click the small arrow on the tab, or right-click the tab, and choose Duplicate. Google Sheets creates a new tab, usually named with a “Copy of” prefix. Double-click the new tab name to give it a useful label. Review the copy: formulas may still refer to the original sheet or to other tabs, which can be correct or may need adjustment depending on what you are building.
Repeat a value or pattern down a range. To repeat the same value, copy its cell, select the destination range, and paste. To copy the contents of the cell above into the selected cells, use Ctrl+D on Windows or Chromebook; on a Mac, use Command+D. Google Sheets may also let you drag the small blue square at the lower-right corner of a selected cell or range (the fill handle) to extend a value or pattern. Check the results: a series such as dates or numbers may continue as a sequence instead of repeating an identical entry.
Confirm what was copied. Click a pasted cell and look at the formula bar to see whether it contains the value or formula you expected. Copy-and-paste normally carries formatting as well as cell contents. If you wanted only the displayed values, use Edit > Paste special > Values only after copying. If you wanted the appearance but not the contents, choose Edit > Paste special > Format only. Menu availability can depend on having copied a selection first.

For a small one-off copy, ordinary paste is usually the quickest choice. When copying records into a larger table, insert rows before pasting so that existing records are not replaced. When making a working version of a complete worksheet, use Duplicate on the tab rather than selecting cells manually; that preserves the sheet layout and its contents in one action.

Common Mistakes

Pasting over information: Pasting into an occupied range replaces its contents. If you are unsure, insert rows first or paste into an empty area, then compare the copy before moving it.
Copying only part of a record: Selecting a name but not its neighboring date or ID can leave the duplicate detached from its details. Select the complete row or all related columns before copying.
Using Cut instead of Copy: Cut removes the original from its location when you paste. Use Copy when you need both the original and the duplicate to remain.
Assuming formulas become fixed values: A pasted formula can adjust its cell references based on its new position. If you need the current results rather than live formulas, use Paste special > Values only.
Confusing creating duplicates with finding duplicates: Copying makes another instance of selected data. It does not identify or remove repeated entries elsewhere in the sheet. Review the data separately if your aim is to detect duplicate records.

Tips

Use a temporary area for a cautious check. Paste into unused columns or a spare tab first. Compare the copy with the source, then move or delete the temporary version when you are satisfied.
Keep related columns together. If a record includes a customer, order number, date, and status, duplicate all of those fields as one row. This reduces the risk of mismatched information.
Choose the right paste option. Regular paste is useful when you want content and formatting. Values only is useful for freezing formula results; Format only helps apply a visual style without replacing cell contents.
Name copied tabs clearly. Replace a generic “Copy of…” name with a description and, if relevant, a date. Clear tab names make it easier to tell a template from a working copy.
Remember that duplicate sheets are not independent snapshots in every sense. A copied sheet can contain formulas that refer to other tabs in the same spreadsheet. Check important totals and references after duplication, especially before sharing or using the copy for reporting.
Use version history for recovery, not as a substitute for care. If a paste causes a problem, Ctrl+Z (Command+Z on Mac) usually undoes the most recent edit. For changes made earlier, use File > Version history > See version history and restore an appropriate version if you have permission.

Troubleshooting

Nothing appears after you paste. Click the destination cell once and try the shortcut again. If browser clipboard controls interfere, right-click and choose Paste. Confirm that the spreadsheet is editable and that you have not clicked into the formula bar or a tab name instead of a cell.
The paste replaced data you needed. Immediately press Ctrl+Z on Windows or Chromebook, or Command+Z on Mac. If you have made more edits since then, inspect them before undoing further. You can also check File > Version history > See version history for an earlier state. Restoring a version can roll back other people’s changes too, so review the timestamp and contents first.
The copied row is incomplete. Undo the paste if needed, then select the row number rather than dragging over just the visible cells. If the sheet has hidden columns, selecting the row heading helps include them. Be aware that pasting a whole row into a partly filled sheet may overwrite data across many columns.
The formulas show unexpected results. Relative references can change when a formula is pasted elsewhere. Click a copied formula cell and inspect its references. If the original calculated result is what you need, undo and paste again using Edit > Paste special > Values only. If the formula should keep pointing to a particular cell, edit it to use the intended reference.
You cannot duplicate or edit the sheet. Check whether you have view-only access, whether the sheet or range is protected, or whether the file owner restricts editing. Ask the owner for permission. If you can view but cannot alter the original, you may be able to make your own file copy with File > Make a copy, depending on the owner’s sharing settings.
The new tab does not behave like a separate workbook. Duplicate makes another tab in the same spreadsheet, not a separate file. If you need a separate document, use File > Make a copy, choose a name and location, and confirm. Check formulas, sharing permissions, and linked data in that new file before relying on it.

Frequently Asked Questions

How do I duplicate a cell in Google Sheets?
Select the cell, press Ctrl+C (Command+C on Mac), click an empty destination cell, and press Ctrl+V (Command+V on Mac). The original remains where it was.

Can I duplicate a row without replacing the row below it?
Yes. Copy the row heading, insert a row above or below the intended location using the row-heading context menu, then paste into the new row. Inserting space first protects existing records.

How do I duplicate a Google Sheets tab?
Click the arrow on the sheet tab or right-click the tab, choose Duplicate, and rename the new tab. This creates a new sheet in the same spreadsheet file.

How can I paste a duplicate without its formatting?
Copy the source, select the destination, and choose Edit > Paste special > Values only. This pastes values rather than carrying over the source formatting. It also replaces formulas with their current results.

Does copying a formula duplicate its result or the formula?
Ordinary copy and paste copies the formula, and its relative references can shift to suit the new location. Choose Values only if you want the displayed result as a fixed value instead.

Is duplicating data the same as removing duplicate entries?
No. Duplicating adds another copy; it does not clean the sheet. If you want to remove repeated entries, use Data > Data cleanup > Remove duplicates, and review the selected columns carefully before confirming.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.