Cell Merge

How to merge cells in Excel and Calc

Below are the steps to merge cells in Microsoft Excel and Sun OpenOffice Calc.

Note

This document only covers merging the cells in excel, not how to merge the values of more than one cell. See: How to combine cell values in Excel.

Open Calc or Excel.

Highlight two or more adjacent cells you want to merge. For example, highlight cells A1 and B1 or C1 and C2.

Click the Merge cells button in the formatting bar. Below is an example of the button in each of the versions of Excel and Calc.

In Microsoft Excel 2010 and above, the Merged cell feature can be found under the Home tab and is shown in the picture below.

Note

When cells with multiple values are merged, the upper-left most cell will be the data of the merged cell.

Merge two cells using a formula

In Excel, you can merge two cells using a formula. Using the ampersand (&) in a formula acts to combine two cells or a cell and additional text together.

Merge Cells in Excel

In this example, the formula =A1&B1 combines the values in cells A1 and B1 into cell C1. In this same example, if you wanted a space between the two cell values, the formula would include a "space" in it and be written as =A1&" "&B1. You would use double quotes around a space to add a space in the formula and the resulting merged value.

What is an Operating System? » Computer Shortcut Keys and their Functions » Keyboard Function Keys » Computer Basics - Hardware - Software - Parts

Short Stories for Kids -

Moral Stories – English Short Stories for Children - Moral Stories for Kids - Stories for Kids - Funny Story for Kids - Scary Stories for Kids - Really Funny Short Stories - Bedtime Stories
Proverb Stories
Powerful Motivational Quotes for Students » Success Quotes » English Short Stories for Kids

Cabin Crew Jobs & Career Advice » Secretary Job Description » Receptionist Job Description » Top 100 Interview Questions and Answers » How to Prepare for an Interview » How to Write a CV » How to Choose a Career » Computer Shortcut Keys and their Functions

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Computer Basics FAQ.

Army Jobs - Navy Jobs - Military Jobs

Scholarship 2024/25

Current Scholarships 2024/2025 - Fully Funded

Full Undergraduate Scholarships 2024/2025

Fully Funded Masters Scholarships 2024/25

PhD Scholarships for International Students - Fully Funded!

Funding Opportunities for Journalists 2024/2025

Funding for NGOs 2024/2025

Funding for Artists 2024/2025

Funding for Entrepreneurs 2024/2025

✅Over 4500 Current Fully Funded Scholarships for International Students

✅ Undergraduate Scholarships 2024

✅ Masters Scholarships 2024

✅ PhD Scholarships 2024 Click Here!

Free Scholarship Newsletter --- E-mail Address

First Name

Then Don't worry — your e-mail address is totally secure. I promise to use it only to send you Advance Africa Newsletter.