Merged cells cause problems in lists or data sets as Excel will have difficulty associating data with merged headers or merged cells in the data with the correct headers. If there is data to the right or below in the cells that you are merging, a dialog box appears warning that Excel will keep the upper left values and remove other data. If you merge cells with text, only the text in the upper leftmost cell will be used and text in cells to the right (and below) will be removed.

Merge cells options are available in the Alignment group on the Home tab in the Ribbon: Recommended article: How to Combine Cells in Excel using Concatenate (3 Ways)ĭo you want to learn more about Excel? Check out our virtual classroom or in-person Excel courses > If you want to combine data from cells in a worksheet (such as first name and last name) in another cell, you can use the CONCATENATE function, the CONCAT function, the CONCATENATE operator, the TEXTJOIN function or Flash Fill. You can merge cells horizontally across columns or vertically across rows. Typically, when a user wants to merge cells, they are trying to place longer headers in one cell (such as January Actual Sales).

You can also access merge commands by right-clicking or using keyboard shortcuts. In Excel, you can merge cells using the Ribbon or the Format Cells dialog box. By Avantix Learning Team | Updated February 19, 2022Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019, 2021 and 365 (Windows)

Excel shortcut keys 2015