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.

 

mergeandcenter intro

 

Merge and Center Cells

If you have data in a cell acting as a table heading, you may want to center it across the columns of your table.

  1. Select the cells that you wish to merge.

 

merge and center select

 

  1. In the Ribbon, select Home > Alignment > Merge & Center.

 

merge and center ribbon

 

  1. The selected cells will be merged into one large cell, and the data in the first cell will be centered over the columns selected.

 

merge and center merged

 

Replacing Data When Merging 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

 

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

 

merge and center 1

 

  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. Select cells that you want to merge (A1:C1), and in the Menu, click the Merge cells icon.

 

google sheets merge and center 1

 

  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.

 

google sheets merge and center 2

 

  1. 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