3. Excel How to merge cells ?


To merge cells into an Excel sheet :

  1. Select the cells you want to merge
  2. Use one of the following buttons in the Alignment group on the Home tab of the Ribbon:
  • The button Excel 2016 Merge And Center merges the selected range of cells into a single cell and centers the content horizontally and vertically
  • The button Excel 2016 Merge Across merges each line of the selected range of cells into a cell for each line without centering the content
  • The button Excel 2016 Merge Cells merges the selected range of cells into a single cell without centering the content
  • The button Excel 2016 Unmerge Cells cancels all cell merges in the selected range.

<< 2. Excel How to create a drop-down list ?

4. Excel How to remove duplicates ? >>