How to Split a Cell in Excel 2016
video description
Date: 2023-07-08
Related videos
Comments and reviews: 6
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.
reply
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.
reply
Nemo
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.
reply
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.
reply
Fernando
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.
reply
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.
reply
KALIGHAT2003
Go slow. Every step should be explained as if you are teaching a novice. As a teacher don't assume the other person knows a lot. Your instructions are too fast for somebody who is learning how to do the splitting.
reply
Go slow. Every step should be explained as if you are teaching a novice. As a teacher don't assume the other person knows a lot. Your instructions are too fast for somebody who is learning how to do the splitting.
reply
Rebel
Please, please, please create a tutorial on how to actually split a single cell WITHOUT putting data into 2 columns.
reply
Please, please, please create a tutorial on how to actually split a single cell WITHOUT putting data into 2 columns.
reply
Jenny
This is more like splitting words and distributing to the number of cells but it is not splitting a cell.
reply
This is more like splitting words and distributing to the number of cells but it is not splitting a cell.
reply
Add a review, comment
Other channel videos
