Is it possible to split a cell into two columns or rows without affecting other cells?
Is it possible to split a cell into two columns or rows without affecting other cells?
Ask me how to hate XL.
Yes it is, but you're going to need to provide more detail if you want people to explain how you would do it in your own particular circumstances.
Ok. I attached a file FORUM.XLSX
I just want something like that.
Ah okay, I think I understand better, you want to split an actual cell rather than the contents of a cell?
In that case, no, you can't do that. You could instead merge all the surrounding cells - for instance you could merge G9:H9 into one larger cell. However this can lead to other issues, depending on what you're doing.
What is the reason you need to have two data items in the same cell? Is it just for visual appeal? Why can't you have data in cells G8 and H8?
If you really do want it to look like that, so ad suggested and merge the 2 cells above and below, and leave that as 2 cells
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks