Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 622,601 times.
Learn more...
You can easily merge two or more cells in Microsoft Excel on Mac or Windows. Merging cells combines two or more cells into a larger cell on the sheet. If you want to merge values of cells by connecting them together into a single cell, you can create a simple formula using the CONCAT function or the "&" symbol. This How.com.vn guide will teach you how to merge and combine cells in Microsoft Excel.
Things You Should Know
- To merge two or more cells into one big cell, select the cells, then click "Merge & Center" on the toolbar.
- Merging cells is helpful if you want one cell in your sheet to be larger, such as a cell that contains a title.
- To merge cell values into a single cell, use the CONCAT function or the & operator.
Steps
Select the cells you want to merge. To do so, click one cell, then drag your cursor to select the other cells you want to merge. The cells you merge must be touching each other. For example, you can merge A1 with B1 but not A1 with only F5.- Merging cells is a great way to add formatting to an Excel spreadsheet. For example, you could put “July Calendar” at the top of an Excel calendar in a larger cell without changing the width of the columns below.
- Merging cells only retains the value of the leftmost cell and results in a larger cell on the sheet. If you want to merge two or more existing cell values into a single cell, see Merging Values.
Click the Home tab. It's on the top-left side of the Excel window. This will bring up the Home toolbar.- You can also get to the Home tag quickly with keyboard shortcuts. Press and release the Alt key on your keyboard, then press H to access the Home tab.
Advertisement
Click Merge & Center on the toolbar. If the cells contain values, you'll see a warning that says, "Merging cells only keeps the upper-left value and discards other values." Click OK to merge the cells. If not, the cells will merge instantly.- If you don't want to center the cells' content, click the ▼ icon to the right of the Merge & Center button and select a different alignment option.
- If you pressed Alt and then H to get to the Home tab, you can press M and then C to merge and center your cells.
Unmerge cells. To unmerge cells, follow these steps:- Select the merged cell.
- Go to the Home tab.
- Click the ▼ icon next to the Merge & Center button.
- Select Unmerge Cells.
Use the formula =CONCAT(A1,B1) to merge two cell values. The CONCAT function makes it easy to concatenate the values into a single cell.- In this example, the contents of the two cells will appear in the new cell without a space separating them. For example, if A1 contains the word "wiki" and B1 contains "How," the new cell will be How.com.vn.
- If A1 is "John" and B1 is "Smith," the new cell will be JohnSmith.
Use =CONCAT(A1," ",B1) to combine values with a space between them. This formula will come in handy if you're combining two words that aren't supposed to butt right into each other, such as a first and last name.- If A1 is "wiki" and "B1" is "How," the new cell will be wiki How.
- If A1 is "John" and B1 is "Smith," the new cell will be John Smith.
Use =CONCAT(A1," and ",B1 to place the word "and" between values. You can replace and with any text you'd like. Note that there are spaces between "and" and the quote marks, which inserts spaces.- You can use CONCAT with more than two cells. For example, =CONCAT(A1," ",B1," ",F6," ",E6).
Use the & operator instead of CONCAT. Another way to merge cell values is the ampersand:- =A1&B1 will merge the values of A1 and B1 the same way as =CONCAT(A1,B1).
- A1," ",B1 will combine the cell values and add a space between them, just like =CONCAT(A1," ",B1).
Community Q&A
- QuestionCan six cells be merged into two cells in Excel?
GaiusGCommunity AnswerYes, of course that's possible.Choose 3 cells to be merged into a single cell, then repeat the process with the remaining three cells. - QuestionHow do I activate the merge cells option when it's grayed out?
Community AnswerTry highlighting the cells that are to be merged first; the option may be grayed out because there is nothing to merge available.
Tips
- Thanks
- You can create an overarching title box for your Excel content by merging cells.Thanks
About This Article
1. Open the Excel document.
2. Select cells to merge.
3. Click Home.
4. Click Merge & Center.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
