• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. Definition of Merge Cell

Definition of Merge Cell

By: MichaelRyan
  • Share
  • Share on Facebook

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.

Corporate earnings
A close-up of a spreadsheet on a computer screen.
credit: G0d4ather/iStock/Getty Images

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.

Video of the Day

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.

Show Comments

Related Articles

How to Merge Cells in Excel

How to Merge Cells in Excel

Around The Home
Productivity
By: Sue Aveyard
Why Can't I See All My Text in an Excel Cell?

Why Can't I See All My Text in an Excel Cell?

Around The Home
Productivity
By: Aaron Parson
How to Merge Cells in a Microsoft Word Table

How to Merge Cells in a Microsoft Word Table

Around The Home
Productivity
By: JaniceU
How to Get Annual Sales in Excel

How to Get Annual Sales in Excel

Around The Home
Productivity
By: Shea Laverty
How to Split a Cell Diagonally

How to Split a Cell Diagonally

Around The Home
Productivity
By: Foye Robinson
How to Switch to Editing Mode in Excel

How to Switch to Editing Mode in Excel

Around The Home
Productivity
By: Jim Campbell
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.