Skip navigation

How can I split cells in Numbers 3.0.1

621 Views 10 Replies Latest reply: Dec 4, 2013 2:39 PM by Nick-Thirteen RSS
Nick-Thirteen Level 1 Level 1 (0 points)
Currently Being Moderated
Dec 4, 2013 10:02 AM

I cannot find the cell split option on the latest version on Numbers - can anyone point me in the right direction - thank you

Aperture 3, OS X Mavericks (10.9), MacBook Pro 2.8GHz core 2 Duo, 8GB
  • SGIII Level 4 Level 4 (3,325 points)
    Currently Being Moderated
    Dec 4, 2013 10:13 AM (in response to Nick-Thirteen)

    Hi Nick-Thirteen,

     

    Not sure if this is what you mean, but this is how you can "Unmerge" already merged cells.  It's in the Table menu.

     

    Screen Shot 2013-12-04 at 1.11.15 PM.png

     

    SG

  • Jerrold Green1 Level 7 Level 7 (28,235 points)
    Currently Being Moderated
    Dec 4, 2013 10:14 AM (in response to Nick-Thirteen)

    Hi Nick,

     

    In Numbers 3, there is no "Split", only Merge and Unmerge.

     

    This means al lot more planning is necessary when designing a table.

     

    Jerry

  • SGIII Level 4 Level 4 (3,325 points)
    Currently Being Moderated
    Dec 4, 2013 10:24 AM (in response to Nick-Thirteen)

    Hi Nick,

     

    I'm curious about this. Could you give a simple example?  I always just insert rows or columns when I need them, knowing that tables in spreadsheets generally work best as a simple grid.

     

    SG

  • SGIII Level 4 Level 4 (3,325 points)
    Currently Being Moderated
    Dec 4, 2013 11:24 AM (in response to Nick-Thirteen)

    Nick,

     

    Interesting.  Thanks.

     

    What's the advantage of doing it that way rather than keeping things simple and uniform with the usual tables?

     

    (I suspect it would disable filtering and sorting, which can be so useful in tables.)

     

    Is this mainly to arrange things for display or print?

     

    SG

  • SGIII Level 4 Level 4 (3,325 points)
    Currently Being Moderated
    Dec 4, 2013 12:31 PM (in response to Nick-Thirteen)

    Hi Nick,

     

    Got it. The purer "spreadsheet way" to avoid duplication of data would be to record commissions in a separate table, and extract the sums corresponding to each "heading" with a formula, something like this:

     

    Screen Shot 2013-12-04 at 3.17.18 PM.png

     

    The formula in D2, copy pasted down,  is:

     

             =SUMIF(Commissions::$A,$A2,Commissions::$C)

     

    This says, add up everything in column C of the Commissions table where the value in column A of the Commissions table is the same as the value in column A of this row.

     

    This takes a one-time setup (and you have to make sure the values in column A of both tables are consistent) but thereafter there are advantages.  Among them, you can sort and filter your transactions or your commissions to get different views.

     

    Splitting and merging cells in spreadsheets generally spells trouble, even in Numbers 2.3, though it sounds as if you've been lucky.

     

    SG

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.