How to merge and separate cells in Excel: a complete guide

When you start working with increasingly larger tables, Understand how to merge and separate cells in Excel It makes all the difference between a chaotic spreadsheet and a clean, easy-to-read one. Excel offers several ways to merge cells, center titles, adjust text, or even combine the contents of multiple cells using formulas.

Throughout this guide you will see All the practical ways to merge and unmerge cells in Excel, and Tricks To split text into multiple columns or use the ampersand (&) to construct addresses, full names, or other more complex data without losing information. Everything is explained step by step in clear, straightforward language, as if you were watching it with someone right next to you.

Related article:

How to include multiple rows in an Excel cell? These are the tricks to make Excel cells more efficient

Basic concepts: what it means to merge and separate cells in Excel

In Excel, when we talk about “merging cells” we mean merge several adjacent cells into a single larger cellThis new cell acts as a single block where only the content of one of the original cells is maintained (usually the top left or the leftmost one).

The main tool for this is the button. “Merge and Center” from the Home tabThis option, in addition to merging cells, aligns the text to the center of the resulting cell. The same drop-down arrow on the button provides access to other options, such as merging horizontally only or merging without centering.

Separating cells involves just the opposite: undo the merge and restore the individual cell gridThe content remains in only one of the cells, usually the leftmost one, while the others are emptied when the merge is undone.

It's important to keep in mind that when combining, The contents of all cells except one are lostTherefore, it's advisable to plan carefully what you're going to merge and, if you need to keep the content of all cells, use formulas or other tools such as linked cells, as discussed below.

Most of the combination and separation options are found in the Home tab of the ribbon, within the Alignment groupFrom there you can merge and center, merge horizontally, merge without centering, or separate cells that have already been merged.

How to merge cells in Excel step by step

To create titles that span multiple columns or to visually group blocks of information, the usual approach is merge cells directly from the Merge and Center buttonThe procedure is simple and is based on first selecting the range and then choosing the appropriate option from the combination menu.

The first step is always select the cells you want to convert into a single cellThey can be several columns in the same row, several rows in one column, or even a rectangular block of several rows and columns, as long as they are contiguous.

Once you have made your selection, go to the tab Start and locate the Merge and Center buttonIf you click directly on the button, Excel will merge the selected cells and center the text from the cell that is retained in the new merged cell.

If instead of pressing the button you click on the arrow that appears to the right of Combine and CenterA small menu will appear with all the possibilities: merge and center, merge horizontally, merge cells, or separate cells if the selection is already merged.

Sometimes you will see that the option to The "combine" option appears disabled or grayed out.This usually happens when you're typing inside a cell (in edit mode) or when the selected range is part of a defined Excel table. In that case, exit edit mode by pressing Enter or Esc, or convert the table to a normal range before attempting to merge.

Variant 1: Use “Merge and Center” to create titles

The most common way to combine cells is the option “Combine and center” to create headers that span multiple columnsIt is widely used to place the company name, the title of a report, or a general heading above a large table.

Imagine you have a sheet with monthly billing data of a company and its different subsidiariesThe table spans several columns, and you want the company name to appear in the top row, occupying the entire width of the table, to make it easier to read.

Select all the cells in the row that are directly above the data, Select all the columns you want the title to cover. Then go to Home > Merge & Center. After clicking, all those cells will be combined into a single large cell that spans the width of the table.

The text you have in the top left cell will be the one that is preserved, and at the same time It will be automatically centered in the new merged cell.If you later change the column widths, the title will still be visually centered within the combined range.

After combining, you can adjust the title format as you wish: Increase font size, apply bold, change color, or apply bordersAll of this will be applied to the merged cell, which acts as a single normal cell from a formatting point of view.

Variant 2: Combine cells horizontally by rows

Another option available in the tool's drop-down menu is “Merge horizontally”This alternative groups cells only from left to right, respecting rows, and is useful when you want to merge cells by rows without affecting entire columns.

When you choose to combine horizontally, Excel Combines the selected cells in each row independentlyIn other words, if you select a range of several rows and several columns, it will create a merged cell for each row, but rows will not be merged together.

The data that is maintained in each row is the content of the leftmost cell within the selection of that rowThe remaining cells in the same row lose their contents during the merge process.

This option comes in very handy when you need group columns within the same row without affecting the rest of the structureFor example, to create subtitles by rows or to compact several columns of text into one for each record.

Keep in mind that merging horizontally does not automatically center the text, so You may need to adjust the alignment manually. if you want it to look more eye-catching or aligned with the rest of the information.

Variant 3: “Merge cells” without centering the content

Within the drop-down menu you will also see the option “Merge cells” and nothing moreThis function works the same as "Merge and Center" in terms of joining cells, but it respects the original text alignment without automatically centering it.

To use it, first select the range you want to join and then Choose Merge Cells from the Merge & Center button menuExcel will create a single cell from all the selected cells, preserving the content of the top left cell or the leftmost cell, as the case may be.

The key difference is that, by combining the text in this way, It remains aligned as configured. in the source cell: if it was left-aligned, it stays left-aligned; if it was right-aligned, it stays right-aligned.

This way of combining is very useful when You don't want to center the headers or the combined dataFor example, in lists where all the text must be aligned to the left to make it easier to read.

In any of the combination variations, remember that Only the content of one of the original cells is saved.If there was different information in several cells of the range, you will lose it, so it's best to make sure before merging or using concatenation formulas when you need to join text.

How to separate merged cells in Excel

If you've gone overboard with the combinations or the design no longer works, you'll probably want to separate cells to return to the original gridExcel allows you to easily reverse the merge from the same Merge and Center button and also by using a keyboard shortcut right after merging.

The quickest way to cancel the last combination is Press Ctrl + Z immediately after merging the cellsThis key combination undoes the last action performed, returning the range to its previous state, both in content and format.

If you've already continued working on the sheet and several actions have passed since you combined, you can separate cells from the Home tabFirst, select the merged cell or cells you want to undo.

With the merged cell selected, go to Home, locate the button Combine and center, then click on it or the drop-down arrow.If you have selected a merged cell, the option you will see available will be "Separate cells"; when you click it, Excel will unmerge the cells.

After separating, the contents of the merged cell It remains in the left cell (or in the first cell of the original range), while the rest of the cells are left empty again, ready for you to write whatever you need or copy data into them.

Some interface descriptions mention that this option is listed as “Separate cells” within the Merge & Center menuThe behavior is the same: returning the cells to their individual state without attempting to reconstruct the content that might have been there before merging.

Split the text of a cell into multiple columns

In addition to working with merged cells, Excel has a very powerful tool for break the contents of a cell or column into multiple columnsIt is the exact opposite of concatenating: instead of joining texts, you separate them according to a delimiter such as a space, a comma, or a specific character.

A very typical case is when you have a column with full names and you need to extract the first and last names separatelyAnother common scenario is having complete addresses in a single cell and wanting to divide it into street, number, and postal code for better analysis.

To do this, the first thing is select the cell or column that contains the text you want to snip offMake sure to select all rows with data, as the wizard will work on the entire selected range.

Then go to the tab Data and choose the Text in Columns optionThis opens the Text to Columns Wizard, which will guide you through several steps to transform the text according to the type of separation you need.

In the first step of the wizard, select “Delimited” if your data is separated by a character such as a space or a commaand click Next. The other option, “Fixed width”, is used when the fields always occupy the same number of characters, which is less common.

In the next step, mark the delimiters that correspond to your data: for example, Check the Space box if the fields are separated by spaces.Or, combine Comma and Space if you have text like “Reyes, Javier” with a comma followed by a space. At the bottom of the window, you'll see a preview to check if the split matches your expectations.

By advancing to the final step of the wizard, Excel allows you to define the format of each new column that will be generatedYou can leave the standard format or choose types such as Text, Date, or others for each column individually, selecting them in the preview and applying the desired formatting.

Next, you'll need to specify where you want to place the result. You can choose a different location for the resulting columnsFor example, empty columns to the right of the original range, by selecting the starting cell in the Destination box of the wizard.

After confirmation, Excel distributes the contents of the original column in several new columns following the delimiters you have chosenThe text appears neatly separated, ideal for filtering, sorting, or using in more complex formulas.

Join cell contents with the & symbol in formulas

If what you're looking for is not just for the cells to look like one, but Combine text from multiple cells without losing the information in each cell.The best alternative is to use formulas with the commercial symbol & (ampersand) to concatenate.

This symbol allows combine the contents of several cells into a single formulaFor example, if you have the first name in A2, the last name in B2, and the street address in C2, you can construct a complete address in a separate cell by joining all those fragments in the order you want.

A very practical example is when you manage Customer lists with street, number, and postal code in separate columns and you want to display the full address in a report or label, but without losing the original column structure.

The typical approach would be to select the cell where you want the merged text to appear and Write a formula that links each cell with the ampersand (&) symbol., adding commas, spaces, or other punctuation marks in between as needed.

Following the example of an address, you could use something like =A2 & » » & B2 & «, » & C2 To combine street name, number, and postal code, spaces and commas are used to ensure readability. Each fixed text fragment is enclosed in quotation marks and linked to cell references using ampersands (&).

In this way, the content appears perfectly ordered and separated by spaces and punctuation marksEven if the source cells only contain raw data, you can easily adjust the formula if formatting needs change or add more fields as required by your report.

The use of the ampersand (&) symbol is not limited to addresses; it is a very powerful tool for create dynamic messages, combine results from other formulas, or generate descriptive labelsFor example, you can combine the value of a numeric cell with explanatory text to display clearer summaries.

Furthermore, this method can be combined with Excel functions such as COUNT, INDIRECT and to coincide, and many othersFor example, you could check if an address has all the necessary components and, based on that check, concatenate only the valid fields, or build messages that warn of errors or incomplete data.

Merging and adjusting cells in Excel 365

In more recent versions like Excel 365, the merge tools complement each other very well. the text wrap optionwhich allows the content to automatically adapt to the cell size without the need to manually expand columns.

When working with long text within a cell, instead of merging multiple cells to make it all fit, it's often more efficient Use Wrap Text to have Excel adjust the row height and create automatic line breaks within the same cell.

The recommended workflow for combining in Excel 365 is very clear: First, select the cells you want to mergeSecond, open the Merge & Center menu; third, choose one of the available options (Merge & Center, Merge Horizontally, Merge Cells or Split Cells).

In the same work environment you can also select the tool Adjust text so that the vertical size of the cell fits the contentThis way, if you enter longer text, the cell will automatically expand downwards and you won't have to redesign the table.

To use Wrap Text, select the cell or range of cells where you want the content to appear. be displayed on multiple lines within the same cell Then click the Wrap Text button on the Home tab. If you need to turn the wrapping off, simply click the same button again.

This combination of tools (merge, center, and adjust) helps you to create much more readable tables without sacrificing data structureYou can use merged cells only for titles and labels, and leave the detail data in individual cells with wrapped text to make the most of the space.

Don't forget that if you want to learn in depth how How do columns and rows work in Excel 365?The application itself offers additional help resources with examples and videos that show you how these tools behave on the grid.

Isaac

Passionate writer about the world of bytes and technology in general. I love sharing my knowledge through writing, and that's what I'll do on this blog, show you all the most interesting things about gadgets, software, hardware, tech trends, and more. My goal is to help you navigate the digital world in a simple and entertaining way.