Merge and center cells in Excel - Cell-by-Cell Formula Trace

Concept Flow

Sales Report

↓

Product

Cells A1, B1, and C1 are selected and merged into one cell. The content from A1 is centered across the merged cell.

Formula

Select cells A1:C1 Click 'Merge & Center' button

You select the range A1 to C1 and then click the Merge & Center button on the toolbar to combine these cells and center the text.

Step-by-Step Trace

Step	Action	Result	Explanation
1	Select cells A1, B1, C1	Cells selected	You start by selecting the range of cells you want to merge.
2	Click 'Merge & Center'	Cells merged into one spanning A1:C1	The selected cells combine into a single cell, and the content is centered.
3	Check merged cell	Merged cell shows 'Sales Report' centered	The text from the original top-left cell remains visible and is centered across the merged area.

The merged cell now spans columns A to C with the text centered. Other cells in the range are no longer separate.

Variable Tracker

Variable	Value	Description
SelectedCells	A1:C1	Range of cells selected for merging
MergedCell	A1:C1	Cells combined into one merged cell
DisplayedText	Sales Report	Text from the top-left cell shown centered

Key Moments

What cells are merged when you merge and center A1:C1?

Which cell's text remains visible after merging?

What happens to the text alignment after merging and centering?

Sheet Trace Quiz - 1 Questions

What happens to the text in cells B1 and C1 after merging A1:C1?

A The text disappears and only A1 text remains

B All texts from A1, B1, and C1 are combined

C Only B1 text remains visible

D The text in B1 and C1 moves to row 2

Key Result

Merge and center combines multiple selected cells into one larger cell and centers the content from the top-left cell across the merged area.

Transcript

First, select the cells you want to merge, for example, A1 to C1. Then click the 'Merge & Center' button on the toolbar. This merges the cells into one and centers the text from the top-left cell. The other cells' contents disappear, and the merged cell spans the selected columns with centered text.