How to merge multiple cells in Excel at once

Excel has several options for formatting cells. When formatting data, you may want to merge multiple cells to improve the formatting of a table. This is commonly done for the heading of a table that spans multiple columns. Also, when multiple rows have the same value, they can be merged and a single value retained. Merging cells is feasible only when presenting data and usually has to be removed when analyzing data.