How do I split a cell in Excel?
How do I split a cell in Excel?
Link to YouTube video
If you've arrived on this page through a Google search, you will be both disappointed and pleased to know that:
You can't actually split cells in Excel
But you can kind of work around it, so it looks like you've split a cell.
OK, so point 1 doesn't need a lot of coverage; there just isn't an option to "split cell" like there is in Microsoft Word. When I first came across this restriction, I had just begun working with Excel, and I was certain that I just wasn't looking hard enough. 18 years later and I still haven't stumbled across that feature so here's how to work around it instead.
So let's imagine you have made the table below, and you decide that you actually want to split column B so that instead of "Name / Surname" you have two separate columns:
Instead of splitting column B (or splitting any of the...