How-to · Numbers for Mac

How to duplicate a table in Numbers on Mac: Command-D steps for Numbers 15.4

To duplicate a table in Numbers on Mac, click the table handle in the top-left corner, then press ⌘D. Numbers puts the copy on the same sheet, right over the original, so drag it clear before you edit it.

Updated Checked against Numbers 15.4 on Mac, with notes for older versions3 minEasy

Person working on a spreadsheet on a laptop, the kind of table work where you duplicate a table in Numbers on Mac
A spreadsheet open on a laptop screen. · Image by Pexels from Pixabay

Quick answer

  • Click the table handle in the top-left corner to select the whole table.
  • Press ⌘D. Numbers makes a copy on the same sheet, placed over the original.
  • Drag the copy's handle to a clear space, or nudge it with the arrow keys.
  • Hold ⌥ and drag a selected table to copy it in one step.
  • Press ⌘Z right after a bad copy. Use ⇧⌘S only to duplicate the whole spreadsheet.

What you need

  • Numbers 15.4, the latest release on Apple's What's new page
  • A spreadsheet with at least one table on a sheet
  • A keyboard with a Command key and a trackpad or mouse
  • Test on a copy of the spreadsheet if the file matters to you

How to Duplicate a table in Numbers on Mac in Numbers on a Mac

  1. Select the whole table

    Move the pointer to the top-left corner of the table. Click the table handle, the small control at the corner. The table is selected when its outline shows. Clicking a cell selects only that cell, not the table.

    Tip: Apple's table help describes the same handle for deleting a table.

  2. Press Command-D

    ⌘D

    With the table selected, press ⌘D. Numbers creates a copy on the same sheet. The copy sits right over the original, so the sheet looks unchanged at first. Apple lists this shortcut as duplicating the object.

    Tip: A copy named like Table 1-1 is normal for this method.

  3. Drag the copy apart

    Click the handle of the new table, the one on top, and drag it to a clear space on the sheet. Leave a gap so the two tables do not touch. Watch the edges as you drop it.

    Tip: Move the copy first, then check the original. It is easy to move the wrong table.

  4. Nudge it with the arrow keys

    Arrow keys

    For small moves, keep the copy selected and press an arrow key. Each press shifts the table a small distance. Use this when a drag is too rough to line up edges.

  5. Or copy with Option-drag

    ⌥ drag

    Instead of Command-D, select the table by its handle, hold the Option key, and drag. Numbers leaves the original in place and puts the copy where you release the mouse.

  6. Check the copy

    Compare the header row, column widths, cell formats and formulas in the copy with the original. Change only the copy, then confirm the original still reads the way you need.

    Tip: Check a few formulas by hand. Totals are the first thing to go wrong.

  7. Undo if the copy is wrong

    EditUndo⌘Z

    If you duplicated the wrong table or the copy landed in a bad place, press ⌘Z right away. Undo reverses the last action, so do it before you make other edits.

Apple's table help explains how to add and delete a table, but it does not describe copying one. Apple's keyboard shortcut page does list a duplicate command for objects, and a table is an object. The method below uses that documented shortcut, and it works on whichever table you select.

15.4

Latest Numbers version on Apple's What's new page, the version this guide follows

What's new in Numbers on Mac, Apple Support

macOS 26

Minimum macOS Apple lists for Numbers 15.4

What's new in Numbers on Mac, Apple Support

650+

Professionals in Smartsheet's 2025 survey, which is vendor research

The Hidden Cost of Spreadsheets, Smartsheet

31%

Name undetected errors as a top spreadsheet challenge

The Hidden Cost of Spreadsheets, Smartsheet

Duplicate a table with Command-D

Start by selecting the whole table, not a single cell. The table handle is the small control in the top-left corner. Click it once, and the table outline shows that the table is selected. Next, press ⌘D. Numbers creates a copy of the table on the same sheet. Apple's keyboard shortcut page lists Command-D for duplicating an object, under the heading Move, group, layer, and resize objects. In an Apple Community thread, a user pressed Command-D on a table named Table 1 and got a copy named Table 1-1 that sat on top of the original. Nothing is deleted, so your next job is to move the copy.

Move the copy so it does not hide the original

The copy sits on top of the original, so the sheet looks unchanged until you move one of the tables. Click the copy's handle in its top-left corner and drag it to a clear space. Leave a gap between the two tables so their edges do not touch. If the copy belongs below the original, drop it under the last row with some room to spare.

You can also nudge the copy. Keep it selected and press an arrow key. Each press moves the table a small distance. That is slow for long moves, but it is precise when you need edges to line up.

Person working on a spreadsheet on a laptop, the kind of table work where you duplicate a table in Numbers on Mac
A spreadsheet open on a laptop screen. · Image by Pexels from Pixabay

Once the copy is in place, compare it with the original. Check column widths, row heights, header styling and cell formats side by side. A copy should match, and a quick look takes less time than hunting down a wrong total later.

Option-drag is the other way to copy a table

Apple lists a second method next to Command-D: Option-drag. Click the table handle to select the table. Hold the Option key, then drag the table. Numbers leaves the original where it was and places the copy where you let go of the mouse.

This saves the separate move step, which helps when you already know where the copy belongs. A large table takes a steady hand, so drag slowly. If the copy lands in the wrong place, press ⌘Z and try again. Both methods come from Apple's list, so either one is a safe choice.

Three commands that look alike, and what each one copies.
MethodKeysWhere the copy landsBest for
Command-D⌘DOn the same sheet, over the originalQuick copies you will move anyway
Option-drag⌥ and dragWhere you release the mousePlacing the copy in one step
Duplicate a whole spreadsheet⇧⌘SA new spreadsheet file, not a tableBacking up a full file

What Apple's menus do and do not show

Apple's table help does not describe a Duplicate Table command. I could not confirm an Edit menu item for duplicating a table in Apple's pages either. Some search snippets mention one, so you may see something similar on your Mac.

If you do, check that it copies the table and not the whole sheet before you trust it. Until then, the object shortcut is the method Apple documents, so it is the one this guide uses.

A worked example: duplicating a monthly budget table

Say your sheet holds a monthly budget table with a header row, a totals row and a few formulas. You want a version for next month. Select the table by its handle and press ⌘D. Drag the copy below the original, leaving a clear gap between them.

Next, clear the typed values in the copy and keep the headers. Then check that each formula in the copy points at a row in the copy, not the original. If a total still reads from the old table, fix that formula before you enter any new numbers.

Copy a table to another sheet

Duplicating a table and moving it to another sheet are different jobs. Apple's help does not describe a Command-D copy that jumps to another sheet. Many people use copy and paste instead. Select the table by its handle, press ⌘C, go to the other sheet, and press ⌘V.

A 2012 Apple Community thread about Numbers '08 and '09 on Lion reports that pasted tables lost formatting and formulas. The cause was a clipboard utility that stripped formatting. Turning it off fixed the problem. That thread is old, so treat it as a warning, not a rule. After any paste, check a few formulas and the header row.

Duplicate a table in Numbers for iCloud

If you work in Numbers in a browser, the steps change. Apple documents how to duplicate a whole spreadsheet in Numbers for iCloud. Click the More button, then choose Duplicate. A number is added to the copy's name.

A copy of a shared spreadsheet is not shared, even when the original is. Apple's iCloud shortcut page lists Command-C, Command-V and Option-drag, but it does not list Command-D. I did not find an Apple page that confirms table-level duplication in the browser. If you need one table, duplicate the spreadsheet, then delete the tables you do not need.

Check which Numbers version you have

The steps in this guide are written for Numbers 15.4. Apple's What's new page lists 15.4 as the latest release, and it says 15.4 requires macOS 26 or later. The same page says Numbers 15.1 joined Apple Creator Studio, while creating, editing and real-time collaboration stay free.

Sources do not agree on the oldest macOS for 15.1. TidBITS says macOS 15.6, while Apple's Creator Studio page says macOS 26 for Numbers. Check the requirements in the Mac App Store before you update. To see your version, open the Numbers menu and choose About Numbers.

Person at a Mac desk reviewing spreadsheet tables before they duplicate a table in Numbers on Mac
Reviewing a sheet at a desk. · Image by geralt from Pixabay

Mistakes people make with table copies

  • Selecting a cell instead of the table. Click the handle in the top-left corner first.
  • Leaving the copy on top of the original, then editing the wrong table.
  • Pressing ⇧⌘S and expecting one table. It copies the whole spreadsheet.
  • Pasting a table into another sheet without checking formulas and formatting.
  • Forgetting that the copy holds the same values. Change the copy, then confirm the original still reads the way you need.
  • Editing without checking which table has focus. The copy and the original look the same at first.

Fix an overlapping Table 1-1 copy

If Command-D left a copy on top of the original, the fix is simple. Drag the table handle to pull the two tables apart. Click the copy you do not want, check the selection, then press Delete. The Apple Community thread that reported this case suggested the same fix.

Before you press Delete, make sure the selected table is the copy and not the original. If you are unsure, press ⌘Z to undo the duplicate and start again. Undo puts the sheet back the way it was, which makes it the safest first move.

Keyboard shortcuts you will use with tables

Table copying sits alongside a few other shortcuts. Undo matters most, since many fixes start with one press of ⌘Z. Delete removes the selected table, and the arrow keys nudge a selected object. Apple's shortcut page covers these for Numbers on Mac.

If you copy tables often, keep the list open for your first few sessions. Our keyboard shortcut guide for Numbers lists more commands, including row and sheet keys.

Check the copy before you rely on it

A copy is only useful if the numbers in it are right. Smartsheet's 2025 report, based on a survey of more than 650 professionals, lists undetected errors as a top spreadsheet challenge. 31% of the findings name them. Manual updates came first at 45%.

The report is vendor research, and the company sells spreadsheet alternatives, so read it as a rough signal. The practical lesson is simple. After you duplicate a table, check the totals in both tables, and confirm that formulas in the copy point at the cells you expect.

Next steps after you duplicate a table

Once the copy sits where you want it, decide what it is for. If it is a template for a monthly report, clear the old values, keep the headers, and check that formulas still point at the right cells. If it is a second version to compare against, label each table so you know which one is which.

A text box works well for labels. Our text box guide walks through it. For a long table, you may want to sort the copy without touching the original. The sorting guide covers that. Before big changes, duplicate the whole spreadsheet with ⇧⌘S so you have a fallback file.

When a copy is the wrong tool

Command-D works best for a quick copy inside one sheet. If you need the same layout across many sheets, a template may suit that better. If you need the table in a separate file, duplicate the whole spreadsheet and delete what you do not need.

A copy of a shared spreadsheet is not shared, so you will need to share it again. Our sharing guide covers the options. If collaborators edit the original, make your changes in your own copy first, so you do not overwrite their work.

Printed charts and a laptop on an office desk, the kind of spreadsheet work where you duplicate a table in Numbers on Mac
Spreadsheet work on a desk. · Image by jarmoluk from Pixabay

Numbers shortcuts for this on Mac

Numbers keyboard shortcuts on Mac
To do thisPress
Duplicate the selected table or object⌘D
Duplicate by dragging a selected table⌥ drag
Duplicate the whole spreadsheet⇧⌘S
Undo the last action⌘Z
Delete the selected tableDelete
Nudge the selected objectArrow keys

If it does not work

Command-D creates a copy that sits right on top of the original
Drag the copy's handle to separate the tables. Select the copy you do not want, check it is the right table, then press Delete. If you are unsure, press ⌘Z and start again.
Nothing happens when I press ⌘D
Check that the whole table is selected, not a single cell. Click the table handle in the top-left corner, then press ⌘D again. Make sure you are not typing inside a cell.
I cannot find a Duplicate Table item in any menu
Apple's help does not list one for tables. Select the table by its handle and press ⌘D. Some search snippets mention an Edit menu item, but I could not confirm it in Apple's pages.
The copy lost formulas or formatting after I pasted it into another sheet
An old Apple Community thread linked this to a clipboard utility that strips formatting. Turn that utility off, paste again, and check a few formulas. Test with a small table before you move a big one.
I need a copy of a table in Numbers for iCloud
Click the More button, then choose Duplicate, to copy the whole spreadsheet. Apple does not document table-level duplication in the browser, so delete the extra tables in the copy.
My team cannot see the copy I made of a shared spreadsheet
Apple says a copy of a shared spreadsheet is not shared. Share the copy again using the steps in our sharing guide.

Faster with Lazur

Do it faster: ask Lazur while you are in Numbers

Hold ⌥ ⌘ and say what you want. Lazur sees your Numbers window. Lazur draws a circle and a label around the button or menu you need.

  • 1

    Hold ⌥⌘ and talk

  • 2

    Lazur draws a circle and a label around the button or menu you need.

  • 3

    You stay in Numbers. Nothing to copy into a chat window.

Free for 3 days, then $18/month. Download for Mac

You say“Where is the table handle?”

Lazur · points at itLazur circles the table handle in the top-left corner. You click it, then press ⌘D yourself.

Numbers
HomeInserttable handleRight hereDrawFormulasDataReview

Questions people ask

Is there a Duplicate Table command in Numbers on Mac?

Not one that Apple's table help describes. The help covers adding and deleting tables, but it does not explain copying one. The working method is Command-D after you select the table by its handle.

What is the keyboard shortcut to duplicate a table in Numbers?

Select the table by clicking its handle, then press ⌘D. Option-drag also duplicates a selected object. Shift-Command-S duplicates the whole spreadsheet, so it is the wrong key for a single table.

Why does the copy overlap the original?

Numbers places the duplicate on the same sheet, in the same spot. Drag the copy's handle to move it. Community reports describe copies named Table 1-1 that sit on top of the first table.

Can I duplicate a table in Numbers for iCloud?

Apple documents duplicating a whole spreadsheet in Numbers for iCloud. Click the More button, then choose Duplicate. I did not find an Apple page that confirms table-level duplication in the browser, so use the Mac app for that job.

Does a copied table keep its formulas?

Apple's pages do not say for certain. An older Apple Community thread reports lost formulas and formatting after a paste, caused by a clipboard utility. Check formulas after every copy, and test on a small table first.

How do I undo a duplicated table?

Press ⌘Z right after the copy appears. If you have made other edits since, select the copy by its handle, check that it is the right one, and press Delete.

Which version of Numbers does this guide cover?

Numbers 15.4. Apple's What's new page lists 15.4 as the latest version and says it requires macOS 26 or later. Community reports behind some steps come from older releases, so check results on your own copy.

Is Numbers free with Apple Creator Studio?

Creator Studio adds premium templates, themes and intelligent features. Apple says Keynote, Pages, Numbers and Freeform remain free to create, edit and collaborate.

Sources

  1. Keyboard shortcuts for Numbers on Mac, Apple Support · Apple · checked 2026-11-07
  2. Add or delete a table in Numbers on Mac, Apple Support · Apple · checked 2026-11-07
  3. What's new in Numbers on Mac, Apple Support · Apple · checked 2026-11-07
  4. Duplicate a spreadsheet in Numbers for iCloud, Apple Support · Apple · checked 2026-11-07
  5. Keyboard shortcuts for Numbers for iCloud, Apple Support · Apple · checked 2026-11-07
  6. About Apple Creator Studio, Apple Support · Apple · checked 2026-11-07
  7. Table 1 in Numbers has duplicated, Apple Community · Apple Community · checked 2026-11-07
  8. Copying a Table in Numbers, Apple Community · Apple Community · checked 2026-11-07
  9. Pages, Keynote, and Numbers 15 Go Freemium, TidBITS · TidBITS · checked 2026-11-07
  10. The Hidden Cost of Spreadsheets, Smartsheet · Smartsheet · checked 2026-11-07

Try Lazur free for 3 days

Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.