create new table from existing cells

I moved a big spreadsheet from Excel into Numbers. Is there any way to breakup the spreadsheet into multiple Tables?

Mac Studio, macOS 14.4

Posted on Apr 18, 2024 6:57 PM

Reply
Question marked as Top-ranking reply

Posted on Apr 18, 2024 9:08 PM

You can make a new table from a range of cells like this:

  1. If you can't see much blank canvas around the table because the table takes up too much of the window, it might help to zoom out before starting
  2. Select a rectangular range of cells
  3. Click and hold somewhere with the selection box and the cells will lift from the table
  4. Drag them to an empty space on the canvas then drop them.


After getting these cell to be a separate table, you may want to convert the first row and/or column of that table into headers if the information in them is headers/labels, not data. And you might want to create a footer row if the last row is a row of formulas that sum up the columns (or something like that). You can do it a few ways. One way is to use the format sidebar. In the Table tab of the sidebar, select how many headers and footers you want.


You can use the same technique to relocate entire rows or columns and also to rearrange rows or columns in an existing table.

2 replies
Question marked as Top-ranking reply

Apr 18, 2024 9:08 PM in response to WilliamL

You can make a new table from a range of cells like this:

  1. If you can't see much blank canvas around the table because the table takes up too much of the window, it might help to zoom out before starting
  2. Select a rectangular range of cells
  3. Click and hold somewhere with the selection box and the cells will lift from the table
  4. Drag them to an empty space on the canvas then drop them.


After getting these cell to be a separate table, you may want to convert the first row and/or column of that table into headers if the information in them is headers/labels, not data. And you might want to create a footer row if the last row is a row of formulas that sum up the columns (or something like that). You can do it a few ways. One way is to use the format sidebar. In the Table tab of the sidebar, select how many headers and footers you want.


You can use the same technique to relocate entire rows or columns and also to rearrange rows or columns in an existing table.

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.

create new table from existing cells

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