Sean Killeen bio photo

Sean Killeen

Just a guy trying to get better at writing bios.

Email Twitter Facebook Google+ LinkedIn Instagram Github Stackoverflow Foursquare
Edit this page | Issue? Question?

Problem

When using Excel, sometimes I have multiple rows that I want to Merge and center, but only within that row.

The rows prior to the merge.

However, if I select them all and select Merge and Center, I see the following error:

"Merging cells only keeps the upper-left cell value, and discards the other values."

This is because Excel things I’m trying to merge all of those cells as one blob, rather than two rows, each with their own centered/merged text.

Solution

In Excel 2013 1, you can select the drop-down next to Merge and Center and Choose Merge Across, which will perform this function per row.

Merging across lets you do a merge and center, but for multiple rows.

And now, you see two rows of text, each merged & centered separately.

The finished product.

  1. (and possibly earlier versions, I haven’t tested)