Merge and center cells in Excel - Step-by-Step Guide

Introduction

Merging and centering cells combines multiple cells into one and centers the text inside. This helps create clear titles or headings that span across columns in your spreadsheet.

When you want a title to span across several columns in a report.

When creating a header that should be centered over multiple data columns.

When formatting a form to have a label centered above input fields.

When you want to visually group several columns under one heading.

When you want to improve the look of your spreadsheet by aligning text nicely.

Steps

Step 1: Select the cells you want to merge

- Spreadsheet grid

The selected cells are highlighted

💡 Make sure the cells are next to each other horizontally or vertically

Step 2: Click the Home tab

- Ribbon at the top of Excel

Home tab options appear below the ribbon

Step 3: Click the Merge & Center button

- Alignment group on the Home tab

The selected cells merge into one cell and the text is centered inside

Step 4: Type your text if the merged cell is empty

- Merged cell in the spreadsheet

Text appears centered across the merged area

Before vs After

Before

Cells A1, B1, and C1 each contain separate text values: 'Sales', '2024', 'Report'

After

Cells A1, B1, and C1 are merged into one cell showing 'Sales 2024 Report' centered across the merged area

Settings Reference

Merge & Center

📍 Home tab > Alignment group

Combines selected cells and centers the content

Default: Unmerged cells

Alignment

📍 Home tab > Alignment group

Controls horizontal text alignment inside cells

Default: General

Common Mistakes

Merging cells that contain different text values

Only the text in the upper-left cell remains after merging; other texts are deleted

Combine or copy the text you want into one cell before merging

Trying to sort data with merged cells

Merged cells can cause sorting errors or unexpected results

Avoid merging cells in data tables that need sorting; use center across selection instead if needed

Summary

Merge and center cells to combine multiple cells into one and center the text inside.

Use this feature to create clear, centered headings across columns.

Remember merging deletes all text except the top-left cell's content.