If you are OK, with that, click on the “OK” in the warning and your three cells will merge together with that upper left-cell value label, in this case “Star Trek”. You will be given a warning that states, “Merging cells only keeps the upper-left cell value, and discards the other values.”Ĥ. Click on the Merge & Center option in that menu.

First, select which cells you want to merge.Ģ.Then, go into the main Home tab and select the Merge & Center toolģ. As you can see we have lists of names of characters from three Star Trek shows.ġ. Here’s the simple, but not too useful, way to merge cells in Excel. See also: How to Screenshot on a Chromebook Merge cell method 1: Merge and Center Tool Let’s take a look at how to merge cells in Microsoft Excel. The other truly merge two cells together. One method is quicker but is mainly for eliminating other cell names. Whatever the reason, there’s a couple of ways you can do that. What if you wanted to merge some cells in Microsoft Excel? You may want to combine the names of people or places into one cell.