Currently Being ModeratedJan 3, 2013 7:21 AM (in response to Piotr Koper)
Currently Being ModeratedJan 3, 2013 11:37 AM (in response to Piotr Koper)
If you mean 'divide or separate large tables into separate tables,' the process is an extension of the method used for moving rows or columns within a table.
Here's an example, using a small table:
To separate this into two smaller tables, one containing the single column on the left, the other the three columns to the right, first select any cell or group of cells on the table to show the Row and Column Reference tabs.
Then select columns B, C and D by clicking the column reference tab for B and dragging right to add C and D to the selection:
Click and hold on the tab for column B (either on or slightly to the left of the "B") and drag down, then right as the image of the selected columns separates from the original table. When the dragged image is completely separated from the original table image, release the mouse button to drop these columns onto the sheet as a new table. Select the new table and position it as desired:
Numbers automatically makes any adjustments needed in formulas.
The process for separating rows is similar.