How to Merge and Center Cells in Excel (3 Easy Methods)

When an entry occupies more than one cell and needs to be positioned in the center, Excel offers a couple of methods to go with. In this article, we’ll show you how to Merge & Center a data entry or a range of data entries in excel.

Suppose, I have a plain list of best published articles in 2020 with Article Sl & Article name.

Table of Contents hide

Dataset for Download

3 Easy Methods to Merge and Center Cells in Excel

Method 1: Using Merge & Center Command

Method 2: Using Keyboard Shortcuts

Method 3: Using Format Cells Option

Conclusion

Dataset for Download

Merge and Center Cells in Excel.xlsx

3 Easy Methods to Merge and Center Cells in Excel

Method 1: Using Merge & Center Command

Step 1: Select the cells you want to merge along a row.

Step 2: Go to Home Tab>> Alignment Group & Click on Merge & Center command option.

Step 3: Click on Merge & Center.

Repeat the method along the rows as many times as you need & will get results like the image below.

Read More: How to Merge Cells in Excel with Data

Method 2: Using Keyboard Shortcuts

Step 1: Select the cells you want to merge along a row & Press ALT key. It’ll enable Commands on Excel Ribbon.

Step 2: Press H for Home.

Step 3: Press M for enabling the Merge & Center command option.

Step 4: Press C to apply the Merge & Center command.

Repeat the method along the rows as many times as you need & will get results like the image below.

Similar Readings

Method 3: Using Format Cells Option

Earlier methods execute merge & center cells one at a time. We can not execute merge & center on multiple cells or range of cells using Merge & Center or Keyboard Shortcuts. However, the Format Cell option does it.

Step 1: Select the cells you want to merge.

Step 2: Right-Click inside any selected cell. A popup window will appear.

Step 3: Click on Format Cell option, Format Cell dialog box will appear.

Step 4: From the Format Cell dialog box, Click on Alignment.

Step 5: Under the Text Alignment, Make Horizontal drop down option Center Across Selection & Vertical drop down option Center.

Step 6: Click OK. And you are all done.

Now, all the cells are merged & positioned in the center.

You can also use keyboard shortcut CTRL+1; Format Cell command box to appear and Follow the sequence Format Cell>>Alignment>> (Text alignment)>>Horizontal (choose Center Across Selection)>> Vertical (choose Center ).

In Case of Column (Merge & Center)

For keeping things simple we use cells only along the rows . If you need to apply merge & center to the cells along the column you can use Merge & Center or Keyboard Shortcuts methods described above. In that case, just change the selection of cells along the column. But be cautious, only the Upper Left Cell Value merges & discards other values. So, you can only use this method in case of duplicate columns.

Suppose, I have a dataset to merge along a column similar to the image below

Step 1: Select cells along a columns you want to merge . Go to Home Tab>> Alignment Group & Click on Merge & Center command option.

Step 2: Click on Merge & Center. A warning window will pop up.

Step 3: Click OK. It discards duplicate values & merges selected cells along the column.

Conclusion

Merge & Center is a handy tool to get an overview of any dataset. Though options like Merge & Center, keyboard Shortcuts execute merge & center only on one cell data at a time, these two methods are user-friendly in case of concise dataset. On the other hand, Format Cell or CTRL+1 provides option to merge & center a range of data. You can use whatever methods you prefer on the basis of your data set. Hope, you find above mentioned methods user friendly & super easy to use.