How to Split a Cell in Excel 2016

Join us on Facebook
Our App

In this tutorial, we’re going to show you how to split a cell in Excel 2016.

Firstly, if the cell is a merged cell, simply click the Merge & Center button to unmerge it or go under the drop-down and click Unmerge Cells.

If it is a singular cell with multiple words or something that can be parsed easily, go under the Data tab and click Text to Columns. The default values will work for our example, click Finish. Each word in the cell will be spread across one per column.

[howtechoffice]

*CONTEST IS VALID TILL DECEMBER 22, 2019*

[zxcvfr]

YOU DID NOT SPLIT ONE CELL. this is annoying click bait

[samsungacademy]

You splitted cells content between cells not the cell itself so please improve!

[remotecont]

This is more like splitting words and distributing to the number of cells but it is not splitting a cell.

[fernandoloizides]

Hi, thank you for the video and the fast way you explain things. I need to split an empty cell into two (it has not been merged and I don't want to shift any of the surrounding cells anywhere). How would I be able to do this? Thank you for your time.

[lindahuffaker]

Thanks for the great (and brief) video. Just what I needed!

[AbominableHuman]

You didn't split the cell, you split existing data between existing cells using the spaces.

[Cartoonicus]

I have one big long vertical cell that wraps. How to I add more cells into the cell to the right of it, so that I don't have a Giant empty space?

[beastlybob]

perfect! exactly what I needed and well explained

[MrFishPirate]

Here's how I found how to do it. Depending on the size of your document, might be a bit of a task.
A2 has data, and in A1 you want to have two cells without affecting A2.
Insert a column before A, so this is the new A, and the previous A is now B.
Select A2 and B2, click "Merge & Center, " and then align as you choose.
This new cell is now wider, so you will need to adjust the width of column B accordingly.
Works same for rows.
Not ideal, but it works. Hope it helps.

[nemod]

It's not possible in Excel at current approach. Because by splitting vertically, lets say A1, you need to add additional cells to it. Which can only be like a1, aa1, aaa1. Or if splitting horizontally, it could be a11, a111, a111. Or simmilar. I wish they go that way, it would be so helpful.

[mpurintun]

Wrong procedure for "split a cell".  You split the content of a cell.  Big difference.

[AngeliaGurnerpersonal]

Please, please, please create a tutorial on how to actually split a single cell WITHOUT putting data into 2 columns.

[davudfarzullayev]

at no point you split a sell in this does anyone know how to actually do it?

[howtechoffice]

❗ Subscribe To Our Main YouTube Channel

[maxcrads]

you haven't split the sell lol how do you make one cell become two cells

[IAmTehAg]

This is exactly what I wanted lol. what the fuck was everyone else trying to do?

[olican]

That's text to columns, it doesnt actually split the cell...

[JohnDoeL]

ahaha
that's so fucked up :)))

I've been trying to do this since awhile now and no tutorial shows this..

[Xman-lgqg]

you didn't split a cell - what's happening here?