Shortcut Key for Merge and Center in Microsoft Excel

Merge & Center combine and center the contents of the selected cells in a new 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 in Microsoft Excel.

There are four options available in Merge and Center:-

  • 1st Merge and center
  • 2nd Merge Across
  • 3rd Merge Cells
  • 4th Unmerge Cells

22

We are going to perform Merge and Centre on the below table
23

Select the cells to be merged, and use Alt > H > M > C sequentially
24

As we can see text in B1 cell is now merged and centered in B1 to D1 cells.

Note:  Merge and Centre option takes the text of only one cell which will be upper-left most cell while performing Merge and center.

You have to be careful about your content in the cells which is to be merged. So let’s get this by an example below.

25

We need to merge the text to B1 to D1. So the text in the cell C1 will be erased and text in cell B1 will be merged and centered in cell B1 to D1 but it shows a warning before doing so.
26

Click OK and output will be like as shown below.
27

Now the same function will be performed on E1 to G1 cell and H1 to J1 cells.

So we will use the F4 key to perform the last function again.
28

In the above image data of Team A is under Team A label. Similarly, for Team B and Team C, we can say the same.

Please find more articles on Labeling and highlighting cells here. Hope you got this by now. Please share your queries in the comment box below. We will solve it for you.

Users are saying about us...

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