Google Sheets Duplicate Shortcut: Cells, Rows, and Sheets

Google Sheets has no single dedicated keyboard shortcut that duplicates every kind of item. To copy cells, use Ctrl+C then Ctrl+V on Windows or ChromeOS (⌘+C then ⌘+V on Mac); to duplicate a whole sheet, open the sheet tab’s menu and choose Duplicate.

Which duplicate method should you use?

The right method depends on what you mean by “duplicate.” Google Sheets treats copying a cell range, filling a range with repeated content, and copying a sheet tab as different actions. A shortcut that works for one does not necessarily do the others.

Copy cells or a range: Select the cells, press Ctrl+C (⌘+C on Mac), select the destination, and press Ctrl+V (⌘+V on Mac).
Repeat a value or formula down a selection: Select the source cell and the cells below it, then use Ctrl+D (⌘+D on Mac) for Fill down.
Repeat a value or formula across a selection: Select the source cell and the cells to its right, then use Ctrl+R (⌘+R on Mac) for Fill right.
Copy an entire worksheet tab: Open that tab’s menu and choose Duplicate. There is no default one-key shortcut for this action.

These options are useful in different situations. Copy and paste makes a separate copy at a destination you choose. Fill down or Fill right repeats the first cell’s contents across the selected cells. Duplicate creates another sheet inside the same spreadsheet file.

How to duplicate a sheet tab

To create a complete copy of a worksheet, find its tab along the bottom of the Google Sheets window. Right-click the tab and select Duplicate. Depending on your device and browser, you can also open the tab’s small menu arrow and choose the same command. Sheets adds a copy, usually with a name such as “Copy of Sheet1,” while leaving the original tab in place.

Open the spreadsheet and locate the tab you want to copy.
Right-click the tab, or open its tab menu.
Choose Duplicate.
Rename the new tab if needed: open its menu, choose Rename, and enter a clear name.

Duplicating a tab is useful for making a new month’s report from a previous month, keeping a clean template, or preserving a snapshot before making changes. It copies the sheet’s contents and layout, including things such as cell formatting and formulas. It does not create a separate spreadsheet file: both the original and duplicate remain in the same file and share its access settings.

Check formulas after duplicating if they refer to other tabs. A copied formula may continue to refer to the original source sheet or another existing tab, depending on how the formula is written. For example, a formula explicitly referring to a tab named January is not automatically a reference to a newly duplicated tab named February. Review important links and update them where necessary.

How to duplicate cells and ranges

For a straightforward copy within a sheet or between tabs, select the cell or range and use the standard copy-and-paste shortcuts. On Windows or ChromeOS, press Ctrl+C, click the destination’s upper-left cell, and press Ctrl+V. On Mac, use ⌘+C and ⌘+V. You can also use Edit > Copy and Edit > Paste from the menu.

For example, to copy a block from A2:C6 to E2:G6, select A2:C6, copy it, click E2, and paste. The copied cells include their contents and formatting. Relative references in formulas generally adjust to the new position, as they do in ordinary spreadsheet copying. An absolute reference, marked with dollar signs such as $A$1, stays fixed when copied.

Copy and paste is also the practical choice when you need a second instance of a range in a different part of a sheet. Be sure to choose a destination large enough for the copied block. Pasting into a range that overlaps data you need to keep can overwrite those cells, so check the destination first. If you only want to paste values or formatting rather than everything, use the relevant option under Edit > Paste special instead of a regular paste.

When Fill down or Fill right is better

Fill commands are shortcuts for extending the contents of the first cell across a selected range. They can be faster than copying and pasting cell by cell, especially when applying one formula to many rows. Select the source cell along with the cells that should receive its contents, then press Ctrl+D for Fill down or Ctrl+R for Fill right. On Mac, the corresponding shortcuts are ⌘+D and ⌘+R.

For example, if D2 contains a formula and D3:D20 should use the same calculation for each row, select D2:D20 and use Fill down. References that are relative can adjust for each row. If D2 contains a fixed label instead of a formula, the same operation repeats that label down the selection. Fill is not the same as duplicating a sheet, and it does not make an additional copy of the selected range elsewhere.

If you want to repeat a pattern rather than copy one cell, dragging the small blue fill handle at the corner of a selection may extend a sequence, such as dates or numbered values. The result depends on what you select and how Sheets recognizes the pattern. For a predictable exact copy of a block, use copy and paste instead.

Copying rows, columns, and formatting

To copy a whole row or column, click its numbered row header or lettered column header, copy it, select the destination row or column, and paste. You can select multiple adjacent headers by dragging across them or using Shift while selecting the endpoints. This is different from inserting a blank row or column: pasting a copied row or column places its content and formatting at the destination and can replace existing material there.

When you only want to reproduce the appearance of cells, copying the entire range may bring along formulas or values you did not intend to transfer. Use Edit > Paste special and choose the applicable paste option, such as formatting only or values only. The available choices can depend on what you copied and where you paste it. A quick check of the destination after pasting helps catch unwanted formulas, changed number formats, or overwritten entries.

For example, to apply a header’s formatting to another row without copying its text, copy the formatted header cells, select the destination cells, and use the formatting-only option in Paste special. If the goal is to reproduce a complete report layout with its formulas and styling, duplicating the sheet tab is usually more reliable than copying many separate ranges.

Common problems and misconceptions

Expecting a sheet-duplication hotkey: Google Sheets does not provide a default keyboard shortcut dedicated to duplicating a tab. Use the tab menu’s Duplicate command.
Using Ctrl+D for every kind of duplicate: Ctrl+D is Fill down, not the command for copying a sheet or placing a copy at an arbitrary destination. Select the intended vertical range before using it.
Pasting over existing data: A paste can replace cells in the destination. Confirm the destination position and size before pasting a large range.
Thinking a duplicated tab is a separate file: It remains in the same spreadsheet. To make a separate file, use File > Make a copy, which creates a new spreadsheet file rather than another tab.
Getting unexpected formula results: Relative references can shift when copied, while absolute references stay anchored. Inspect formulas if a copied calculation points somewhere unexpected.

Shortcuts can also behave differently if a browser, operating system, or assistive input method intercepts a key combination. If a shortcut does not work, first check that the sheet grid is active and the intended cells are selected. You can use the corresponding menu command instead. Google Sheets’ Help > Keyboard shortcuts menu lists shortcuts available in the current interface.

Google Sheets compared with Excel

The basic distinction between copying cells and duplicating a worksheet exists in both Google Sheets and Microsoft Excel, but instructions are not always interchangeable. This article describes Google Sheets in a web browser. Its sheet-tab menu has a Duplicate command, while Excel’s worksheet-copy controls and keyboard behavior can vary by platform and version. A shortcut documented for Excel should not be assumed to work in Sheets.

In Sheets, Ctrl+C and Ctrl+V on Windows or ChromeOS (⌘+C and ⌘+V on Mac) are the standard cell-copy shortcuts, and the tab menu is the straightforward way to copy a whole sheet. If you move between the programs, use the menu labels in the app you have open and verify the copied result. This is especially important for formulas, because spreadsheet references and features can behave differently across programs.

Frequently Asked Questions

Is there a keyboard shortcut to duplicate a sheet in Google Sheets?
No dedicated default shortcut duplicates a sheet tab. Right-click the tab, or open its menu, and choose Duplicate.

What is the Google Sheets shortcut for copying cells?
Use Ctrl+C and Ctrl+V on Windows or ChromeOS. On Mac, use ⌘+C and ⌘+V. Select the destination before pasting.

What does Ctrl+D do in Google Sheets?
Ctrl+D fills down: it copies the top cell’s contents into the selected cells below it. It does not duplicate a sheet tab.

How do I duplicate a Google Sheets tab on a Mac?
Right-click the sheet tab, or open its menu, then choose Duplicate. The menu method works without relying on a special sheet-duplication keyboard shortcut.

How do I make a separate copy of the spreadsheet?
Choose File > Make a copy. That creates a new spreadsheet file; Duplicate on a sheet tab only adds a copied tab to the current file.

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.