Then go to the Home tab, and click the Merge and Center button in the Alignment group. This will merge the selected cells but only keep the top-left value and center it. The rest of the values ...