In this tutorial I am going to show you how to merge cells in Excel. In the screenshot below I have an example of why I need to merge cells. As you can see the heading “money earnt” is at the top of one column when I need it to be centered over all the columns.
How to merge cells in Excel
- Highlight the cell with the word in it and the other boxes you want to merge with it.
- Go to the top menu and press on the Home tab/ribbon.
- Look for the link that says Merge & Center. Click on this link. See the screenshot below.
- Then you will notice it has merged and centered.
If you just want to center the text to the middle of the cell simply select the text and press on the text centering button, as shown below. However by pressing the Merge and center button, this will merge the selected cells and center the text at the same time.
Excel can be a difficult program to master. If you are interested in learning more see this Excel video training course. They make everything look so easy!