Excel TipsIn this tutorial, I’ll demonstrate the 3 different ways to merge cells. These won’t merge the content of the cells; only the left-most or upper-left-most content will be kept. Merging cells are especially useful when creating headers. As you can see in the image below, the “Excel Tutorial: Merge Cells” text spans across 5 columns to keep the content below it without having to adjust the cells below.

 

 

Excel Tutorial Merging Cells Before

The 3 ways to merge are all accessible under the “Home” menu toolbar. You should see a dropdown labeled “Merge & Center”.

Excel Tutorial Merging Cells Toolbar


Merge & Center

Excel Tutorial Merging Cells Merge Center Toolbar

This merging technique will take the chosen cells, merge them, and center the upper-left-most content. The merging will be across columns, and across rows.

Excel Tutorial Merging Cells Merge Center


Merge Across

Excel Tutorial Merging Cells Merge Across Toolbar

This merging technique will take the chosen cells and merge them keeping the left-most content. The merging will be across columns, but not across rows.

Excel Tutorial Merging Cells Merge Across


Merge Cells

Excel Tutorial Merging Cells Merge Cells Toolbar

This merging technique will take the chosen cells and merge them keeping the upper-left-most content. The merging will be across columns, and across rows.

Excel Tutorial Merging Cells Merge Cells