When you edit an Excel, you may need to merge or unmerge cells according to your requirements.
Besides, if you want to recover your missing Excel documents, you might tryMiniTool Power Data Recovery.
Excel is a part of the Microsoft Office suite of software.
When working with Excel, you’re gonna wanna master a variety of skills.
In this article, we will introduce how to merge and unmerge two or more cells in Excel.
How to Merge or Unmerge Cells in Excel on Windows/Mac/Web (Standard Methods)?
How to Merge or Unmerge Cells in Excel on Windows?
In Excel, you are not allowed to split an individual cell.
Here are two ways to merge Excel cells.
The contents of the other cells that you merge will be deleted.
Way 1: Use the top ribbon menu
Step 1: pick the cells you want to merge.
Step 2: SelectMerge & CenterunderHome.
This way will combine and center the contents of the selected cells in a new larger cell.
Of course, this is not the only choice for the format of merged cells.
Merge Across:merge the selected cells in the same raw into one large cell.
The following is the merged effect of Merge Across.
Merge Cells:merge the selected cells into one cell.
The following screenshot is the merged effect of Merge Cells.
Unmerge Cells:split the current cell into multiple cells.
This option is used to split a cell that is merged by multiple cells.
Step 1: grab the cells you want to merge and right-hit the selected area.
Step 2: SelectFormat Cellsfrom the right-click menu to continue.
Step 3: The Format Cells interface will pop up.
Then, you better switch to Alignment and selectMerge cellsunderText control.
Step 4: ClickOKto save the merge operation.
This way only simply merges your selected cells.
How to Unmerge Cells in Excel?
Splitting unmerged cells is not allowed in Excel.
That is, you could only unmerge a cell that is merged by multiple cells.
Step 2: ExpandMerge & Centerand selectUnmerge Cells.
This will split the current cell into multiple cells.
Step 1: snag the Excel cell you want to split.
Step 2: Right-smack the selected cell and selectFormat cells.
Step 3: Uncheck theMerge cellsoption.
Step 4: ClickOKto save the change.
Likewise, you might also use the Alignment feature to adjust the position of the text in the cell.
How to Merge or Unmerge Cells in Excel on Mac?
Microsoft Excel is also available on Mac.
All texts in the other merged cells will be removed.
Step 2: SelectMerge & Centerunder theHometab.
you could also tap the arrow next to Merge & Center, then selectMerge AcrossorMerge Cellsaccording to your requirements.
Step 1: snag the merged cell you want to split.
Step 2: ClickUnmerged CellsunderMerge & Center.
It is easy to unmerge a cell in Excel on Mac.
How to Merge or Unmerge Cells in Excel Web?
you should probably see to it that only one of the cells you want to merge has text.
Step 2: Go toHone > Merge & Center.
Step 2: Go toHome > Merge & Center.
The text or data in the merged cell will be moved to the left cell after splitting the cells.
it’s possible for you to move the text or data to any other cell according to your requirements.
How to Merge or Unmerge Cells in Excel without Losing Data?
In this part, we will show you two easy methods.
Way 1: Use the Justify Feature
This method cannot justify cells containing numbers and formulas.
Step 2: Under Home, go toFill > Justify.
Step 3: The following screenshot is the content merging effect.
Then, you could use the standard method to merge cells based on your needs.
With this method, you’re able to choose to retain all texts in the selected cells.
These are the two ways to merge cells in Excel without losing data.
you’ve got the option to select one way as your wish.
How to Recover Your Missing Excel Files?
you could use professionaldata recovery softwareto recover them if they are not overwritten by new data.
MiniTool Power Data Recovery is worth trying.
This program can work on all versions of Windows, including the latest Windows 11.
So, you might first try thisfree file recovery tooland see if it can find and retrieve your files.
you’ve got the option to click thePreviewbutton to preview the selected file.
This software allows you to preview up to 70 types of files.
you’re able to directly use the recovered files.
you might go to the MiniTool official site to get one.
Wrap Things up
How to merge two cells in Excel?
How to merge or unmerge cells in Excel?
How to merge Excel cells without losing data?
After reading this article, you’re free to get useful and easy methods to do this job.
