See all How-To Articles

How to Merge and Center Cells in Excel & Google Sheets

This tutorial demonstrates how to merge and center cells in Excel and Google Sheets.

 

merge and center final data

 

Merge and Center Cells

Say you have the following values in cells A1:C1 and want to merge and center them into one cell.

 

merge and center initial data

 

To achieve this, (1) select cells that you want to merge (A1:C1), and in the Ribbon, go to Home > Merge & Center.

 

merge and center 1

 

You will get a pop-up message with a warning that merging cells will keep value only from the upper-left cell. Press OK to confirm.

 

merge and center 2

 

As a result, cells A1:C1 are merged and centered, keeping the value from cell A1.

 

merge and center final data

 

Merge and Center Cells in Google Sheets

Unlike Excel, Google Sheet doesn’t center merged cells automatically. Therefore you need to merge cells first, and then set the alignment to center. To do this, follow the next steps.

1. (1) Select cells that you want to merge (A1:C1), and in the menu, click the Merge cells icon.

 

google sheets merge and center 1

 

2. You will get a pop-up message with a warning that merging cells will keep value only from the upper-left cell. Press OK to confirm.

 

google sheets merge and center 2

 

3. Now you need to center the merged cell. To do this, in the menu, click on the Horizontal align icon and choose Center.

 

google sheets merge and center 3

 

As a result, cells A1:C1 are merged and centered.

 

google sheets merge and center 4