Benefits

• If you need a larger cell in a spreadsheet or need to merge cells to create a text box, the merge feature can reformat cells in just a few clicks.
  
  

Function

• When cells are merged, all of the text and numbers from the individual cells is merged and displayed in the center of the merged cell.
  
  

Considerations

• If you accidentally use the merge function in a spreadsheet program, you can reverse the merge by selecting the cell. Next, right click and select Split Cell.
  
  

Other Applications

• Although merging is most often used in spreadsheet software, it can be used in any piece of software that allows the creation of tables. For example, if you are adding a table in Microsoft Word or working in an Access database, cells can be merged.
  
  

Expert Insight

• Microsoft notes that cells can also be merged by using text in the formula line. Simply type "Concatenate" followed by the cells that should be merged.