You will undoubtedly need to combine and unmerge cells while working with data in Excel. Unmerging cells split a single cell into numerous cells, whereas merging cells unite several cells into one. You will learn how to combine and unmerge cells in Excel in this blog article.
Suppose you have the expense data in excel and need to format it for your report. It will be looking professional to merge the cells C2:E2 and B2:B3.
Use the Excel Ribbon to Merge/Unmerge
You may need to Merge and UnMerge cells to format your data table. Please follow the below steps to merge rows for the text Months and columns for the text Expenses in the below example.
- Select cell B2:B3
- Go to Home
- Select Merge & Center
- Choose Merge Cells
For merging the cells C2:E2, Select the cells C2:E2 and follow steps 2 to 4. Your final output will look like the one below.
Use the Format Cells to Merge/Unmerge
You can use the Format cells dialog box to merge and unmerge cells in excel.
Select cells B2:B3
Click the Right mouse button and Choose Format Cells…
Go to Alignment
Make sure the Merge cells check box selected
Press OK
Select cells C2:E2 and follow the above steps to merge the cells C2:E2.
Use Keyboard Shortcuts to Merge/Unmerge
Select the cells B2:B3 or C2:E2.
Press Alt + H + M + M to merge the cells
Select the merged cells and can use the same combination of keys to unmerge the cells.
Conclusions
Merging and unmerging cells in Excel is a type of formatting your report and dashboard. which helps you create a more organized and visually appealing spreadsheet. Knowing how to merge and unmerge cells will help you create effective and professional-looking spreadsheets that are easy for others to read and understand. Now that you know the basics of merging and unmerging cells, you can begin creating your own perfect spreadsheets.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.
