Merging multiple excel cells allows your data to visualize as one large cell.
The process is quite essential for presenting the data set to a business meeting and other purposes.
But one big drawback of merging data is you cant implement any formula on the merged cells.
Even you will be unable to edit cell data if the cells are merged.
you could simply split the incorporated cell data into multiple unmerged cells to avoid such incompetence.
Dont know how to do that?
In this article, Ill describe different methods of unmerging cells in MS Excel.
you’re free to use these techniques on any version of Microsoft Excel, including macOS.
So, lets start.
This shortcut will definitely unmerge cells in your worksheet.
So, double-check you choose the merged cell before pressing Alt + H + M +C altogether.
Now, lets get to the other unmerging methods I discussed.
Here is the simplest way to unmerge Excel cells on Windows PC:
1.
Dont worry; this method will surely unmerge cells in your worksheet.
Just follow my lead.
Youll need to rewrite the values on every cell.
Thats how you unmerge cells using Excels in-built ribbon option.
Check out our separate post on how toInstall Macro in Excel.
Now, if youre a mac user, an unmerging option is also available for you.
Check out the following section for unmerging excel cells in macOS.
Heres a complete guide on how toCopy Values Without Formulas on Excel.
How to Unmerge Excel Cells in Mac
Unmerging Excel cells in Mac is quite similar to Windows.
To unmerge combined cell data on Mac, you must follow the instructions given below.
And double-check there is sufficient space for a new column to the right of the merged cells.
Check out our separate post onFix Microsoft Excel Freezing or Slow.
So, its safe to find the merged cells first, then unmerge them.
Lets see how to do that.
check that you follow the steps as I explained.
Actually, its not difficult to split the combined data without any data loss.
You just need to focus on some minor options while unmerging.
Hopefully, youve understood all these techniques for unmerging an excel cell.
If you have any further queries, continue reading to the end.
Frequently Asked Questions
How do I Unmerge all merged cells?
How do you Unmerge cells in Excel and keep all data?
Can you Unmerge multiple cells in Excel?
First, try the keyboard shortcuts for unmerging.
Then, try adding a button in the quick access toolbar.
That will speed up the time of unmerging.
However, comment down if you have any concerns about other excel tricks.
My support team will be happy to assist.
