Skip navigation

Division of Sheets in Numbers

209 Views 2 Replies Latest reply: Jan 3, 2013 11:37 AM by Barry RSS
Piotr Koper Calculating status...
Currently Being Moderated
Jan 3, 2013 4:49 AM

Hi does anybody knows how to divide/separate  big sheets

Numbers
  • Wayne Contello Level 6 Level 6 (12,640 points)
    Currently Being Moderated
    Jan 3, 2013 7:21 AM (in response to Piotr Koper)

    Enable page view by selecting the menu item "View > Show Print View" then adjust the scaling and page orientation as needed using the controls in the "Sheet Inspector":

    Screen Shot 2013-01-03 at 9.21.09 AM.png

     

    To open the sheet inspector select the menu item "View > Show Inspector"

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Jan 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:

    Picture 5.png

    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:

    Picture 8.png

    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:

    Picture 9.png

    Numbers automatically makes any adjustments needed in formulas.

     

    The process for separating rows is similar.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.