- Mastering the options for combining, centering, and splitting cells in Excel significantly improves the presentation of tables and headers.
- The Text to Columns wizard allows you to divide complex data, such as names or addresses, into several manageable columns.
- The & symbol in formulas concatenates text without losing information, creating dynamic strings from multiple cells.
- Using merged cells and text wrapping judiciously avoids problems when sorting, filtering, and analyzing large volumes of data.
When you start working with increasingly large spreadsheets, knowing how to merge and split cells in Excel makes all the difference between a chaotic sheet and a clean, easy-to-read one. Excel offers several ways to merge cells, center titles, wrap text, or even combine the contents of multiple cells using formulas.
Throughout this guide, you'll learn all the practical ways to merge and unmerge cells in Excel , as well as tricks for splitting text across multiple columns or using the ampersand (&) to create 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 discussing it with someone right next to you.
Basic concepts: what it means to merge and separate cells in Excel
In Excel, when we talk about "merging cells," we mean joining several adjacent cells into a single, larger cell . This new cell acts as a single block where only the content of one of the original cells is retained (usually the top left or leftmost cell).
The main tool for this is the "Merge & Center" button on the Home tab , which, 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 is the exact opposite: undoing the merge and restoring the grid of individual cells . The 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 you merge cells, you lose the content of all cells except one . Therefore, it's advisable to carefully plan what you're going to merge and, if you need to keep the content of all cells, use formulas or other tools like linked cells , as we'll see later.
Most merging and splitting options are located on the Home tab of the ribbon, within the Alignment group . From there you can merge and center, merge horizontally, merge without centering, or split 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 method is to merge cells directly using the Merge & Center button . The procedure is simple: first select the range and then choose the appropriate option from the merge menu.
The first step is always to select the cells you want to merge into one . This can be multiple columns in the same row, multiple rows in a column, or even a rectangular block of multiple rows and columns, as long as they are contiguous.
Once you've made your selection, go to the Home tab and locate the Merge & Center button . Clicking this button will merge the selected cells and center the text from the remaining cell in the new merged cell.
If instead of pressing the button you click on the arrow that appears to the right of Merge and Center , a 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'll see the merge option 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 merge cells is with the "Merge and Center" option to create headers that span multiple columns . This is frequently used to place a company name, report title, or general heading above a large table.
Imagine you have a spreadsheet with monthly billing data for a company and its various subsidiaries . The table spans several columns, and you want the company name to appear in the top row, occupying the entire width of the table, to improve readability.
Select all the cells in the row directly above the data, select all the columns you want the title to span , and go to Home > Merge & Center. After clicking, all those cells will be merged into a single, large cell that spans the width of the table.
The text in the top-left cell will be retained and automatically centered in the new merged cell . If you later change the column widths, the title will remain visually centered within the merged range.
After merging, you can adjust the title's formatting as desired: increase the font size, apply bold, change the color, or add borders . All of this will be applied to the merged cell, which acts as a single, normal cell from a formatting perspective.
Variant 2: Combine cells horizontally by rows
Another option available in the tool's drop-down menu is "Merge Horizontally ." This option groups cells only from left to right, respecting rows, and is useful when you want to merge cells by row without affecting entire columns.
When you choose to merge horizontally, Excel merges the selected cells in each row independently . That is, if you select a range of multiple rows and columns, it will create a merged cell for each row, but rows will not be merged together.
The data retained in each row is the content of the leftmost cell within that row's selection . The remaining cells in the same row lose their content during the merge process.
This option is very useful when you need to group columns within the same row without affecting the rest of the structure . For example, to create row-level subheadings or to combine multiple columns of text into a single column per record.
Keep in mind that horizontal merging 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'll also see the option "Merge cells" on its own . This function works the same as "Merge and center" in terms of joining cells, but it preserves the original text alignment without automatically centering it.
To use it, first select the range you want to merge, and then choose Merge Cells from the Merge & Center button menu . Excel will create a single cell from all the selected cells, preserving the content of the top-left or leftmost cell, as appropriate.
The key difference is that, when combining in this way, the text remains aligned as it was set 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 headings or combined data , for example, in lists where all the text has to be aligned to the left to make it easier to read.
In any of the merging methods, remember that only the content of one of the original cells is saved . If there was different information in several cells within the range, you will lose it, so it's best to double-check before merging or using concatenation formulas when you need to combine text.
How to separate merged cells in Excel
If you've over-merged cells or the layout no longer fits, you'll likely want to separate cells to return to the original grid . Excel allows you to easily undo the merge using the Merge & Center button and also with a keyboard shortcut immediately after merging.
The quickest way to undo the last merge is to press Ctrl+Z immediately after merging the cells . This key combination undoes the last action performed, returning the range to its previous state, both in content and formatting.
If you've already continued working on the sheet and several actions have taken place since you merged the cells, you can unmerge them from the Home tab . First, select the merged cell or cells you want to unmerge.
With the merged cell selected, go to Home, locate the Merge & Center button, and click it or the drop-down arrow . If you have a merged cell selected, the available option will be "Unmerge Cells"; clicking it will undo the merge.
After separating, the contents of the merged cell remain in the cell to the left (or the first cell of the original range), while the rest of the cells become empty again, ready for you to type whatever you need or copy data into them.
Some interface descriptions mention that this option appears as "Split Cells" within the Merge & Center menu . The behavior is the same: returning the cells to their individual state without attempting to reconstruct any content that might have been present before merging.
Split the text of a cell into multiple columns
In addition to working with merged cells, Excel has a powerful tool for splitting the contents of a cell or column into multiple columns . It's the opposite of concatenation: instead of joining text, you separate it using 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 separately . Another frequent scenario is having complete addresses in a single cell and wanting to divide them into street, number, and postal code for better analysis.
To do this, first select the cell or column containing the text you want to snip . Make sure to select all rows with data, as the wizard will work on the entire selected range.
Next, go to the Data tab and choose the Text to Columns option . This opens the Convert 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 comma , and click Next. The other option, "Fixed width," is used when fields always occupy the same number of characters, which is less common.
In the next step, select 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 division matches your expectations.
As you move to the final step of the wizard, Excel lets you define the format for each new column that will be generated . You 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 format.
Next, you'll need to specify where you want to place the result. You can choose a different location for the resulting columns , for 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 splits the content of the original column into several new columns using the delimiters you selected . The text appears neatly separated, ideal for filtering, sorting, or using in more complex formulas.
Join cell contents with the & symbol in formulas
If you're not just looking for cells to appear as one, but to combine text from multiple cells without losing the information in each , the best alternative is to use formulas with the ampersand (&) symbol to concatenate.
This symbol allows you to combine the contents of several cells into a single formula . For example, if you have the first name in A2, the last name in B2, and the street address in C2, you can create a complete address in a separate cell by combining all those fragments in the order you want.
A very practical example is when you manage customer lists with the 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 & 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, interleaving spaces and commas to make the result readable. Each fixed text snippet is enclosed in quotation marks and linked to the cell references using ampersands (&).
This way, the content appears perfectly ordered and separated by spaces and punctuation , even if the source cells only contained 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 isn't limited to addresses; it's a powerful tool for creating dynamic messages, combining the results of other formulas, or generating descriptive labels . For 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 MATCH, among many others . For example, you could check if an address has all the necessary components and, based on that check, concatenate only the valid fields, or construct messages that warn of errors or incomplete data.
Merging and adjusting cells in Excel 365
In more recent versions like Excel 365, the merging tools are complemented very well by the Wrap Text option , which 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 to use Wrap Text so that Excel adjusts the row height and makes automatic line breaks within the same cell.
The recommended workflow for merging in Excel 365 is very clear: first, select the cells you want to merge ; second, open the Merge & Center menu; third, choose one of the available options (Merge & Center, Merge Horizontally, Merge Cells, or Split Cells).
In the same workspace, you can also select the Wrap Text tool so that the vertical size of the cell adapts to the content . This 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 be displayed on multiple lines within the same cell, and then click the Wrap Text button on the Home tab. If you need to turn off wrapping, simply click the same button again.
This combination of tools (merge, center, and wrap) helps you create much more readable tables without sacrificing data structure . You 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 available space.
Don't forget that if you want to learn in depth how 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.
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.