how to split a cell

How to split a cell in numbers 3.6.2.

iMac, OS X Yosemite (10.10.5)

Posted on Dec 31, 2017 1:44 PM

Reply
Question marked as Top-ranking reply

Posted on Dec 31, 2017 3:22 PM

From Numbers Help (emphasis added)

:

Merging table cells combines adjacent cells into a single cell. Unmerging cells that were previously merged retains all the data in the new top-left cell.


Here are some restrictions:


You can’t merge nonadjacent cells or cells from different areas of the table, for example, cells from the body and the header.


You can’t merge columns or rows.


You can’t split a cell. If a cell has never been merged with another cell, it can’t be unmerged.


To merge cells, select two adjacent cells. Go (menu) Table > Merge cells.

To unmerge cells, select a merged cell. Go (menu) Table > Unmerge cells.


Regards,

Barry

14 replies
Question marked as Top-ranking reply

Dec 31, 2017 3:22 PM in response to Ruppy59

From Numbers Help (emphasis added)

:

Merging table cells combines adjacent cells into a single cell. Unmerging cells that were previously merged retains all the data in the new top-left cell.


Here are some restrictions:


You can’t merge nonadjacent cells or cells from different areas of the table, for example, cells from the body and the header.


You can’t merge columns or rows.


You can’t split a cell. If a cell has never been merged with another cell, it can’t be unmerged.


To merge cells, select two adjacent cells. Go (menu) Table > Merge cells.

To unmerge cells, select a merged cell. Go (menu) Table > Unmerge cells.


Regards,

Barry

Dec 31, 2017 10:33 PM in response to Ruppy59

Yes I read the text in your screenshot . That appears to be for an ancient version of Numbers, nearly a decade old now, “orphanware”. For several years now the text in your snapshot has not applied to current versions of Numbers. Given the ease in achieving the same visual effect in other ways I’m personally happy the option is not included, cluttering the interface and causing mysterious problems for the unwary who are using Numbers for its primary purpose: crunching numbers.


For editing and displaying a lot of text I would lean toward using Pages and other apps designed for that purpose anyway, instead of Numbers.


But if you feel strongly about the old “split” feature described in your screenshot then you can may find it convenient to make your case to Apple via Numbers > Provide Numbers Feedback in your menu.


SG

Dec 31, 2017 10:09 PM in response to Ruppy59

"My original software was numbers 09."


When you upgraded (or downgraded, depending who you talked to) from Numbers 2 (Numbers '09), the iWork '09 applications (Numbers '09, Pages '09 and Keynote '09) were not removed from your computer. Unless you have deliberately deleted them, you'll find them in a folder named iWork 09, inside your Applications folder.


You can still split cells in a Numbers '09 document. I doubt (but haven't tested) that the split will be retained if the document is saved, then opened in Numbers 3.


Regards,

Barry

Dec 31, 2017 6:04 PM in response to Barry

Barry


Thanks for your response. However, I believe I have used the splitting cells feature before in previous documents. I agree with you 100% that your can merge two or more tangent cells in a table and can therefore unmerge the same!

There are references to both merged and unmerged and cell splitting in numbers help. Please review the attached and offer your thought. Thanks. Puppy.

User uploaded file

Dec 31, 2017 9:59 PM in response to SGIII

SGill


I have never had an issue tracking or tracing quote, unquote mysterious behavior. As I indicated earlier if the split cells contain texted it is a non-issue. In other words the cells are not used in calculating a formula; what is there to trace?

Your correct inserting columns and rows is elementary. Have you read the language in the snap-shot that is contained in my response to Barry? Read that and then if you have anything new to contribute please share. Thanks

Dec 31, 2017 6:28 PM in response to Ruppy59

Hi Puppy,


(Which is the typo—user name or signature?)


Note the icon on the Numbers Help article:

User uploaded file

The icon (a 3d bar graph with three vertical bars) and the Help article are for Numbers '09 (Numbers version 2), in which the option of splitting cells is a supported feature.


That feature was not included in the 'new and improved' Numbers 3, a completely rewritten application sharing a name with an earlier, different application.


General recommendations for all versions have been to avoid using split or merged cells in Numbers.


Regards,

Barry

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.

how to split a cell

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