Numbers data tables

Is it possible to move a data table from one sheet to another without breaking the formulas that rely on that table?

MacBook Pro 13″, OS X 10.11

Posted on Dec 2, 2022 8:19 AM

Top-ranking reply

Ralf-F

Level 4

2,741 points

Posted on Dec 2, 2022 11:56 AM

Yes

Select your table and use command + X to cut it, then go to the new sheet and use command + V to paste it.

All links will be updated.

Select the table here

Regards Ralf

View in context

Similar questions

How to select a table in Numbers I need to transpose columns into rows. I see I need to first select my table to do this. I do not know how to select a table. I have copied the advice given on the Numbers troubleshooting page. Tap the table, then tap in its top-left corner; three blue dots appear on the edges of the table when it’s selected. I have tapped the table, then tapped the icon in the top-left corner. I do not see three blue dots. I am not able to transpose my data.
591 2
Numbers Pivot Tables I would like to know if and when Apple will update the Numbers application so that a pivot table can be moved to any sheet, once it has been made. I would like to have multiple pivot tables on 1 sheet. And to go along with this, when refreshing a pivot table, all other pivot tables should refresh. I would also like to have real data validation (not a pop-up menu).
1489 3
Copy & paste table formatting to new sheet in Numbers on iPad Pro 12.9? How do I Copy & paste table formatting to new sheet? I have a large table on sheet A. I do not want to Duplicate Sheet A, it is too large. I also do not want to paste a snapshot. I have to submit a months worth of data at a time. When I copy those rows and paste to a new sheet, I lose column widths and row heights only. They revert back to 20 pt X 98 pt. Does not matter which I paste first, values or formulas. All other formatting copies over.
1151 2

1 reply

Top-ranking reply

Ralf-F

Level 4

2,741 points

Dec 2, 2022 11:56 AM in response to snivo

Yes

Select your table and use command + X to cut it, then go to the new sheet and use command + V to paste it.

All links will be updated.

Select the table here

Regards Ralf

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers data tables

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up