Richard Drury via Getty Images
Merging cells is an easy way to format your Excel spreadsheets, and you can do it vertically and horizontally.
Also: How to enable markdown in Google Docs
For example, a merged cell at the top of a table can work as a header or it can delineate a category. Merging will group the cells, so they work as an individual cell.
How to merge cells in Excel
1. Select the cells to merge into one
Keep in mind that the information in the first cell to be selected is the data that will go on the combined cell, so the contents of any other selected cell will be deleted once you merge cells.
The first cell you select should contain the information you want on your merged cell.
Screenshot by Maria Diaz2. In the Home tab, click on Merge & Center
Once you click on Merge & Center, the cells will be merged into one, occupying the real estate of the other cells you selected. This process can be done in columns vertically by repeating the same process.
FAQs
How do I unmerge cells?
Click on the merged cell to select it, and go to the same Merge & Center button.
Also: How to use ChatGPT to write Excel formulas
Clicking this button will separate the merged cells automatically, though a dropdown menu to the right will give you the option to Unmerge Cells.
How can I combine full columns or rows?
You can merge columns or rows by selecting them and clicking Merge & Center in the Home tab on Excel.
See also
-
How to merge cells in Excel
-
How to get Microsoft Office for free
-
How to convert a PDF to Excel for free
-
How to freeze a row in Excel
-
How to create a drop-down list in Excel