Download Article
Quick and easy ways to combine cells in Excel
Download Article
- Merging Cells |
- Merging Values |
- Video |
- Q&A |
- Tips |
- Warnings
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 wikiHow 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 tab 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 .
Advertisement
-
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 wikiHow .
- 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) .
Advertisement
Community Q&A
Search
-
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.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
-
Thanks
- You can create an overarching title box for your Excel content by merging cells.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
About This Article
Article Summary
X
1. Open the Excel document
.
2. Select cells to merge.
3. Click Home
.
4. Click Merge & Center
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 743,707 times.
Advertisement
