Home »  Software »  Office Suite Software

How Do I Merge Cells in Microsoft Excel®

October 03, 2011  |  Difficulty: Easy

How to format and merge cells in your Microsoft Excel® spreadsheet

When working with Microsoft Excel®, adding a heading or title to a row or column or to merge cells are all common practices in using the program. With Microsoft Office® 2010, Excel® lets you easily merge cells together to form one cell. Logically, these cells must form a rectangle and must be an even count. Follow the steps below to find out how to format cells in your Microsoft Excel® spreadsheet.


  1. Start the Microsoft Excel® application.
  2. Open the file where you want to format the cells, or create a new one.
  3. Mark the cells (drag the “cross” cursor over them).
  4. Right-click on the marked cells and choose “Format Cells…” from the menu.
  5. Switch to the “Alignment” tab.
  6. In the “Text control” section, check the “Merge cells” checkbox.
  7. Click the “OK” button.

Tips and Tricks:

  • If your text is longer than the merged cells in the “Text control” section check the “Shrink to fit” checkbox and the text will automatically change its size to fit the cell.
  • If you have truncated text in your merged cells and vertical space is available, in the “Text control” section you can check the “Wrap text” checkbox. The text will be divided into two or more lines in one cell.


Most Popular Articles:

What Is the Best Backup Software for Me

Internet Security Solutions Detect Legitimate Soft

How Do I Block Internet Intruders from Spying

How Do I Choose a Data Backup Software

How Do I Install a FREE Spyware and Adware Blocker

Related Articles:

How to insert a new line, row, or column between ones that already exist

How Do I Add a Line or Column in Microsoft Excel®

How Do I Set Up Slides to Change in Microsoft® PowerPoint 2010

How Do I set up slides to change in PowerPoint

How to share a workbook in Microsoft® Excel 2010 so other people will see the changes

How Do I Share a Workbook in Microsoft® Excel 2010

How to start working with Microsoft Access® application and create your first database

How Do I Create Microsoft Access® Database

How to use the format painter in Microsoft® Word 2010

How Do I Copy the Format in Microsoft® Word

Help Us Spread the Word!

Love us on Facebook to stay updated.

Stay aware and get our best content on health, celebrity, travel, living, career and the technologies that will change the world.