In this situation I have 2 cells merged into 1. How can I unmerge it so the result will be 2 cells with the same data?
I have cases with up to 7 cells merged in the xls file. How can I unmerge them all?
Unmerge all cells in Numbers xls file
numbers
Related Question
- How to make two cells edit and display the same information in Numbers
- How to combine separate cells in a Numbers spreadsheet and paste the result as text into a TextEdit document
- How to find duplicate adjacent cells in Numbers
- MacOS – NUMBERS Is it possible to select all the cells that share the same background colour on an existing table
- How to add all of the text strings in all of the cells in a row together
- How to delete certain cells from Numbers
Best Answer
There's no automated way to do this.
As you would know, when you merge two or more cells the data all ends up in the new merged cell. However, if you unmerge the cell in future, Numbers will retain the data but keeps it in the left most cell (or, in the case of merged cells across rows and columns, data ends up in the top left cell when unmerged).
This behaviour is standard across spreadsheeting software (e.g. MS Excel, etc). Typically, if you want to unmerge the cell and then retain the data in the other cells as well, you would first unmerge the cell and then copy/paste the existing data from the first cell into the others.
If you needed to automate this because you had a large number of merged cells to unmerge and retain the data in all cells, you would need to look at using something like AppleScript to achieve what you want. Of course, this assumes you're talking about Numbers in macOS rather than in iOS.
Finally, your question refers to an Excel file (the .xls file you mention), so another option would be to use Visual Basic in Excel to make the changes first before opening the file in Numbers. However, this too would require coding a custom solution just like you'd have to using AppleScript. Any such option would have to be done within Windows or macOS (i.e. not Excel for iOS or Android).