How to merge cells in excel

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!

Related Posts

• Excel Tutorial – Making a Basic Spreadsheet That Totals Columns Automatically
• Relative and Absolute Cell References in Excel Formulas
• Background colors and images will not print in Word 2007
• Type abbreviations and use autocorrect to finish words for you
• How to use and show all keyboard shortcuts in Word 2007
• How to use a custom watermark on different pages in your document
• How to use data from a table to create a graph chart in excel

Tagged as: 2007, cell, excel, merge cell, merge cells

This post was written by...

Mitz – who has written 759 posts on Computer Tips.

Hi guys…I am a computer freak but I do not always talk in tech language. Hope you enjoy my website and learn everything you need to know in an easy to understand way.. If you like what you see please join: Follow Tips4pc On Twitter | Become A Facebook Fan | Subscribe RSS Feed | Tips4pc Youtube Channel

Contact the author