Merge and Center in Microsoft Excel 2010

In this article we will learn about how we can do merge and center in Microsoft Excel 2010

Merging of cells is important to combine and center the contents of the selected cells in a new or existing larger cell. This is a great way to create a label that spans multiple criteria. This is used to combine multiple cells into a single cell and create the main headers for reports.

There are four options available in Merge and Center:- 1st Merge and center itself, 2nd Merge Across, 3rd Merge Cells, 4th Unmerge Cells. We will review the 3rd one in the list which is Merging Cells.

 

Let’s take an example and understand how you can merge cells in Excel.

 

We have text in cell A1 and we need to split it into three cells. To merge the cells follow the below mentioned steps:-

    • Select the cells A1:C1.
    • Go to the “Home” tab, select “Merge and Center” in the “Alignment” group.

img1

 

  • Another way to merge the cells is select the cells A1:C1.
  • Press the key CTRL+1.
  • The Format cells dialog box will appear.
  • In the “Alignment” tab, tick on the “Merge Cells” check box.
  • Click on ok

img2

 

img3

 

Now you can see in the snapshot the three cells havebeen merged. You can use the merge option in a report to create the main header along with a sub header which would be very useful in formatting the report for better understanding of the data.

 

See the below snapshot for a before and after version of the headers.

Report before merging the header

img4

 

Report after merging the header

img5

 

To summarize, merge cells, though are a bane when it comes to using them daily, do help in formatting a report so that it looks more presentable and makes the data easier to read and understand.

This tip is applicable to all the Microsoft Excel’s version later to 2003.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube