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.
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
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.
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.
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.
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.
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.
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.
Undo if the copy is wrong
⌘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 Support650+
Professionals in Smartsheet's 2025 survey, which is vendor research
The Hidden Cost of Spreadsheets, SmartsheetDuplicate 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.

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.
| Method | Keys | Where the copy lands | Best for |
|---|---|---|---|
| Command-D | ⌘D | On the same sheet, over the original | Quick copies you will move anyway |
| Option-drag | ⌥ and drag | Where you release the mouse | Placing the copy in one step |
| Duplicate a whole spreadsheet | ⇧⌘S | A new spreadsheet file, not a table | Backing 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.

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.

Numbers shortcuts for this on Mac
| To do this | Press |
|---|---|
| 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 table | Delete |
| Nudge the selected object | Arrow 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.
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
- Keyboard shortcuts for Numbers on Mac, Apple Support · Apple · checked 2026-11-07
- Add or delete a table in Numbers on Mac, Apple Support · Apple · checked 2026-11-07
- What's new in Numbers on Mac, Apple Support · Apple · checked 2026-11-07
- Duplicate a spreadsheet in Numbers for iCloud, Apple Support · Apple · checked 2026-11-07
- Keyboard shortcuts for Numbers for iCloud, Apple Support · Apple · checked 2026-11-07
- About Apple Creator Studio, Apple Support · Apple · checked 2026-11-07
- Table 1 in Numbers has duplicated, Apple Community · Apple Community · checked 2026-11-07
- Copying a Table in Numbers, Apple Community · Apple Community · checked 2026-11-07
- Pages, Keynote, and Numbers 15 Go Freemium, TidBITS · TidBITS · checked 2026-11-07
- 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.