Merge cells

(upbeat music) - [Narrator] You can merge cells together to make data in only one cell look better. Click and drag to select all the cells that you wish to merge, and then click Merge & Center on the home ribbon tab. To unmerge the cells, select your merged cell, and then click Merge & Center again. This works for both columns and rows, though if you do merge cells that have more than one item in them, it's only going to keep the uppermost value and delete the rest.

When I click Merge & Center, I'll get prompted, but it's only keeping the upper value. Click okay, and your cells are merged.