Question

What is meant by ‘Merging a range of cells’? How is it done?

Answer 1

Merged cells are a single cell that is created by combining two or more selected cells. The cell reference for a merged cell is the upper-left cell in the original selected range. When two or more adjacent horizontal or vertical cells are merged, the cells become one large cell and displayed across multiple columns or rows. The contents of one appear in the centre of the merged cell.

Steps:

1. Select two or more adjacent cells that we want to merge.
2. On the Home tab, in the Alignment group, click Merge and Centre.