Excel because that civicpride-kusatsu.net 365 Excel for civicpride-kusatsu.net 365 for Mac Excel because that the web Excel 2021 Excel 2021 because that Mac Excel 2019 Excel 2019 because that Mac Excel 2016 Excel 2016 because that Mac Excel 2013 Excel for iPad Excel for iPhone Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less

You can"t split an individual cell, but you have the right to make it appear as if a cell has been split by merger the cells above it.

You are watching: The opposite of merging cells is splitting a merged cell


Important: When you merge multiple cells, the contents of only one cabinet (the upper-left cell because that left-to-right languages, or the upper-right cell because that right-to-left languages) appear in the combined cell. The materials of the various other cells the you merge are deleted.


After merging cells, you can break-up a an unified cell right into separate cells again. If girlfriend don"t remember where you have combined cells, you deserve to use the Find command to easily locate an unified cells.

Merging combines 2 or an ext cells to create a new, larger cell. This is a great way to produce a label that spans number of columns.

In the instance here, cells A1, B1, and also C1 were merged to produce the brand “Monthly Sales” to explain the information in rows 2 with 7.

Merge cells

Merge 2 or an ext cells by complying with these steps:

Select 2 or an ext adjacent cell you desire to merge.

Important: Ensure that the data you desire to retain is in the upper-left cell, and keep in mind the all data in the other linked cells will be deleted. To retain any data native those other cells, just copy it to one more place in the worksheet—before you merge.

On the Home tab, choose Merge & Center.



If Merge & Center is disabled, ensure the you’re not editing a cell—and the cell you want to unify aren’t formatted as an Excel table. Cells formatted together a table frequently display alternating shaded rows, and also perhaps filter arrows on the tower headings.

To merge cells without centering, click the arrowhead next come Merge and Center, and then click Merge Across or Merge Cells.

Unmerge cells

If you must reverse a cell merge, click onto the an unified cell and also then pick Unmerge Cells item in the Merge & center menu (see the number above).

Split text native one cell into multiple cells

You can take the text in one or more cells, and distribute it to multiple cells. This is the contrary of concatenation, in which you incorporate text from two or much more cells right into one cell.

For example, girlfriend can split a obelisk containing full names right into separate very first Name and Last name columns:


Follow the steps below to split text into multiple columns:

Select the cabinet or tower that contains the message you desire to split.

Note: Select as plenty of rows as you want, yet no more than one column. Also, ensure that are adequate empty columns to the right—so that none of your data is deleted. Simply include empty columns, if necessary.

Click Data >Text to Columns, which display screens the Convert message to Columns Wizard.

Click Delimited > Next.

Check the Space box, and clear the remainder of the boxes. Or, check both the Comma and Space crate if that is exactly how your message is split (such as "Reyes, Javiers", with a comma and room between the names). A preview the the data appears in the panel at the bottom the the popup window.


Click Next and also then select the layout for your new columns. If you don"t desire the default format, select a format such as Text, then click the second column of data in the Data preview window, and click the same style again. Repeat this for all the the columns in the preview window.


Click the

switch to the right of the Destination
box to please the popup window.

Anywhere in her workbook, pick the cells that you desire to save the split data. Because that example, if girlfriend are separating a complete name right into a first name column and a last surname column, choose the appropriate variety of cells in two adjacent columns.


Click the

button to increase the popup home window again, and then click the Finish button.


Merging combines two or an ext cells to produce a new, larger cell. This is a an excellent way to produce a label that spans number of columns. For example, below cells A1, B1, and also C1 were merged to develop the label “Monthly Sales” to describe the info in rows 2 v 7.

Merge cells

Click the first cell and also press Shift while you click the critical cell in the range you want to merge.

Important: Make certain only among the cells in the variety has data.

Click Home > Merge & Center.

If Merge & Center is dimmed, make certain you’re not editing and enhancing a cabinet or the cells you desire to unify aren’t inside a table.

Tip: To merge cell without centering the data, click the an unified cell and also then click the left, center or right alignment choices next come Merge & Center.

If you adjust your mind, you can always undo the merge by clicking the merged cell and clicking Merge & Center.

Unmerge cells

To unmerge cells immediately after merger them, press Ctrl + Z. Otherwise execute this:

Click the linked cell and click Home > Merge & Center.

The data in the combined cell move to the left cell when the cells split.

See more: How To Get Your Cousin To Like You, 10 Reasons Why Your Cousins Are Your Best Friends


Need an ext help?

You can always ask an professional in the Excel technology Community or acquire civicpride-kusatsu.net in the answer community.