Definition of Merge Cell

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
A close-up of a spreadsheet on a computer screen.
Image Credit: G0d4ather/iStock/Getty Images

Merge cell is a function in database software that allows multiple adjacent cells to be combined into a single larger cell. This is done by selecting all cells to be merged and choosing the "Merge Cells" command.

Advertisement

Benefits

Video of the Day

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.

Video of the Day

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.

Advertisement

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.

Advertisement

Advertisement

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.

Advertisement

Advertisement

references