How to Merge Cells in Microsoft Excel 2010

If you are lucky enough to be working with an Excel spreadsheet where all of the data can be arranged in the default layout without any additional configuration by you, consider yourself lucky. Individuals making spreadsheets that require no formatting are certainly in the minority. If you have read this article about adjusting your cell size and have been applying those techniques to your spreadsheet, then you have taken the first step towards fully customizing your spreadsheet layout. Unfortunately, merely changing the height or width of a cell might not always be an adequate solution. The primary reason for this ineffectiveness is that changing the height or width of a cell will adjust that setting for every cell in the row or column, which may not be your desired intention. Fortunately you can merge cells in Microsoft Excel 2010 so that one cell can be as wide or tall as many cells.

 

Make Just One Cell in Excel Bigger

 

Understanding the logic behind merging cells is an important aspect of deciding when it is the correct solution for your situation. If, for example, you are making a spreadsheet where you need to display three columns of data under one heading, then you are searching for the correct solution. Merging cells defines a setting for those specific cells, but does not affect the other cells around them. Follow the tutorial below to learn how to apply this to your own spreadsheet.

Double-click the Excel file containing the cells that you want to merge to open it in Excel 2010.

In the example image below, I have a hypothetical situation where I want to create one cell titled “Full Name” above the three columns that are currently filled with the first, middle and last names of some fake people.

sample excel data to be merged

 

Click your mouse on the leftmost cell, then drag your mouse until all of the cells that you want to merge are highlighted.

how to merge cells in Microsoft Excel 2010

 

Right-click on the highlighted cells, then click Format Cells.

open the format cells menu

 

Click the Alignment tab at the top of the window, then check the box to the left of Merge Cells.

click alignment, then click merge cells

 

Click the OK button at the bottom of the window to apply the change. This will remove the dividing lines that previously indicated that there were separate cells, and clicking on that cell will now highlight the entire area.

There is also a Merge and Center button that you can click in the Alignment section of the ribbon at the top of the screen.

excel 2010 merge and center

 

Clicking this button will automatically merge your highlighted cells and center the cell value.