How can I divide cells into two parts in Excel?
For example I want to divide cell B2 into two parts, without inserting any new row or column. Please see the screenshot below:
microsoft-excel-2010 worksheet-function vba
edited Sep 23 '15 at 9:10
bertieb
5,547112342
asked Sep 23 '15 at 9:06
ramji
46127
|
show 5 more comments
For example I want to divide cell B2 into two parts, without inserting any new row or column. Please see the screenshot below:
microsoft-excel-2010 worksheet-function vba
edited Sep 23 '15 at 9:10
bertieb
5,547112342
asked Sep 23 '15 at 9:06
ramji
46127
I want to divide a cell into two or more parts which should also let me select the divided part of the cell.
– ramji
Sep 23 '15 at 9:08
Hi ramji, welcome to Super User. Thanks for the screenshot to illustrate what you would like, but I don't understand how it shows what you want. Can you make it any clearer?
– bertieb
Sep 23 '15 at 9:11
@bertieb the screenshot shows a cell that has 2 parts. I wonder how you achieved that though as to my knowledge that is not possible. Did you draw that line yourself perhaps?
– LPChip
Sep 23 '15 at 9:12
@LPChip oh, my mistake- could not see that (bad eyesight), thanks for pointing it out
– bertieb
Sep 23 '15 at 9:13
3
I am pretty sure Excel does not have a unit smaller than a single cell. You could achieve this by merging B&C for all rows except row 2. How about explaining why you want this, there may be alternative approaches.
– Paul
Sep 23 '15 at 9:14
|
show 5 more comments
For example I want to divide cell B2 into two parts, without inserting any new row or column. Please see the screenshot below:
microsoft-excel-2010 worksheet-function vba
edited Sep 23 '15 at 9:10
bertieb
5,547112342
asked Sep 23 '15 at 9:06
ramji
46127
For example I want to divide cell B2 into two parts, without inserting any new row or column. Please see the screenshot below:
microsoft-excel-2010 worksheet-function vba
microsoft-excel-2010 worksheet-function vba
edited Sep 23 '15 at 9:10
bertieb
5,547112342
asked Sep 23 '15 at 9:06
ramji
46127
edited Sep 23 '15 at 9:10
bertieb
5,547112342
asked Sep 23 '15 at 9:06
ramji
46127
edited Sep 23 '15 at 9:10
bertieb
5,547112342
edited Sep 23 '15 at 9:10
bertieb
5,547112342
edited Sep 23 '15 at 9:10
bertieb
5,547112342
5,547112342
asked Sep 23 '15 at 9:06
ramji
46127
asked Sep 23 '15 at 9:06
ramji
46127
asked Sep 23 '15 at 9:06
ramji
46127
46127
I want to divide a cell into two or more parts which should also let me select the divided part of the cell.
– ramji
Sep 23 '15 at 9:08
Hi ramji, welcome to Super User. Thanks for the screenshot to illustrate what you would like, but I don't understand how it shows what you want. Can you make it any clearer?
– bertieb
Sep 23 '15 at 9:11
@bertieb the screenshot shows a cell that has 2 parts. I wonder how you achieved that though as to my knowledge that is not possible. Did you draw that line yourself perhaps?
– LPChip
Sep 23 '15 at 9:12
@LPChip oh, my mistake- could not see that (bad eyesight), thanks for pointing it out
– bertieb
Sep 23 '15 at 9:13
3
I am pretty sure Excel does not have a unit smaller than a single cell. You could achieve this by merging B&C for all rows except row 2. How about explaining why you want this, there may be alternative approaches.
– Paul
Sep 23 '15 at 9:14
|
show 5 more comments
I want to divide a cell into two or more parts which should also let me select the divided part of the cell.
– ramji
Sep 23 '15 at 9:08
Hi ramji, welcome to Super User. Thanks for the screenshot to illustrate what you would like, but I don't understand how it shows what you want. Can you make it any clearer?
– bertieb
Sep 23 '15 at 9:11
@bertieb the screenshot shows a cell that has 2 parts. I wonder how you achieved that though as to my knowledge that is not possible. Did you draw that line yourself perhaps?
– LPChip
Sep 23 '15 at 9:12
@LPChip oh, my mistake- could not see that (bad eyesight), thanks for pointing it out
– bertieb
Sep 23 '15 at 9:13
3
I am pretty sure Excel does not have a unit smaller than a single cell. You could achieve this by merging B&C for all rows except row 2. How about explaining why you want this, there may be alternative approaches.
– Paul
Sep 23 '15 at 9:14
I want to divide a cell into two or more parts which should also let me select the divided part of the cell.
– ramji
Sep 23 '15 at 9:08
I want to divide a cell into two or more parts which should also let me select the divided part of the cell.
– ramji
Sep 23 '15 at 9:08
Hi ramji, welcome to Super User. Thanks for the screenshot to illustrate what you would like, but I don't understand how it shows what you want. Can you make it any clearer?
– bertieb
Sep 23 '15 at 9:11
Hi ramji, welcome to Super User. Thanks for the screenshot to illustrate what you would like, but I don't understand how it shows what you want. Can you make it any clearer?
– bertieb
Sep 23 '15 at 9:11
@bertieb the screenshot shows a cell that has 2 parts. I wonder how you achieved that though as to my knowledge that is not possible. Did you draw that line yourself perhaps?
– LPChip
Sep 23 '15 at 9:12
@bertieb the screenshot shows a cell that has 2 parts. I wonder how you achieved that though as to my knowledge that is not possible. Did you draw that line yourself perhaps?
– LPChip
Sep 23 '15 at 9:12
@LPChip oh, my mistake- could not see that (bad eyesight), thanks for pointing it out
– bertieb
Sep 23 '15 at 9:13
@LPChip oh, my mistake- could not see that (bad eyesight), thanks for pointing it out
– bertieb
Sep 23 '15 at 9:13
3
3
I am pretty sure Excel does not have a unit smaller than a single cell. You could achieve this by merging B&C for all rows except row 2. How about explaining why you want this, there may be alternative approaches.
– Paul
Sep 23 '15 at 9:14
I am pretty sure Excel does not have a unit smaller than a single cell. You could achieve this by merging B&C for all rows except row 2. How about explaining why you want this, there may be alternative approaches.
– Paul
Sep 23 '15 at 9:14
|
show 5 more comments
1 Answer
1
active
oldest
votes
It is not possible to split an Excel cell into smaller parts (rows, columns).
This concept exists in Word tables or in html, but not in Excel.
When designing a spreadsheet you need to start from the smallest unit in a table, which is a cell. As discussed in the comments to your question, you can merge cells to span several rows or several columns.
Merged cells introduce problems with aspects of data selection, though, so use them with caution. Instead of merging cells across several columns, it is often better to use the cell alignment "Center across selection".
answered Sep 23 '15 at 11:09
teylyn
16.9k22539
This does not answer the question nor it is quality answer. Of course you can split cells into smaller parts.
– amrx
Aug 30 '16 at 17:55
1
@Baron, pray please tell me how you split a cell in Excel into smaller parts. Post that as an answer and you'll have my upvote.
– teylyn
Aug 30 '16 at 20:40
The page explains how to merge split cells, computerhope.com/issues/ch000874.htm
– amrx
Aug 30 '16 at 21:21
@Baron And there you have it. They show how to merge cells. They show how to split merged cells back into single cells. But there is NO WAY to split a single cell that is not part of a merged cell. Please read the question and understand the problem before shooting down a correct answer. I suggest you take back your downvote.
– teylyn
Aug 30 '16 at 21:49
@Baron Nothing more to say? I'm eagerly awaiting your response. Prove your claim that single cells can be split or take back your downvote. I challenge you.
– teylyn
Sep 2 '16 at 23:16
|
show 2 more comments
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f977001%2fhow-can-i-divide-cells-into-two-parts-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It is not possible to split an Excel cell into smaller parts (rows, columns).
This concept exists in Word tables or in html, but not in Excel.
When designing a spreadsheet you need to start from the smallest unit in a table, which is a cell. As discussed in the comments to your question, you can merge cells to span several rows or several columns.
Merged cells introduce problems with aspects of data selection, though, so use them with caution. Instead of merging cells across several columns, it is often better to use the cell alignment "Center across selection".
answered Sep 23 '15 at 11:09
teylyn
16.9k22539
This does not answer the question nor it is quality answer. Of course you can split cells into smaller parts.
– amrx
Aug 30 '16 at 17:55
1
@Baron, pray please tell me how you split a cell in Excel into smaller parts. Post that as an answer and you'll have my upvote.
– teylyn
Aug 30 '16 at 20:40
The page explains how to merge split cells, computerhope.com/issues/ch000874.htm
– amrx
Aug 30 '16 at 21:21
@Baron And there you have it. They show how to merge cells. They show how to split merged cells back into single cells. But there is NO WAY to split a single cell that is not part of a merged cell. Please read the question and understand the problem before shooting down a correct answer. I suggest you take back your downvote.
– teylyn
Aug 30 '16 at 21:49
@Baron Nothing more to say? I'm eagerly awaiting your response. Prove your claim that single cells can be split or take back your downvote. I challenge you.
– teylyn
Sep 2 '16 at 23:16
|
show 2 more comments
It is not possible to split an Excel cell into smaller parts (rows, columns).
This concept exists in Word tables or in html, but not in Excel.
When designing a spreadsheet you need to start from the smallest unit in a table, which is a cell. As discussed in the comments to your question, you can merge cells to span several rows or several columns.
Merged cells introduce problems with aspects of data selection, though, so use them with caution. Instead of merging cells across several columns, it is often better to use the cell alignment "Center across selection".
answered Sep 23 '15 at 11:09
teylyn
16.9k22539
This does not answer the question nor it is quality answer. Of course you can split cells into smaller parts.
– amrx
Aug 30 '16 at 17:55
1
@Baron, pray please tell me how you split a cell in Excel into smaller parts. Post that as an answer and you'll have my upvote.
– teylyn
Aug 30 '16 at 20:40
The page explains how to merge split cells, computerhope.com/issues/ch000874.htm
– amrx
Aug 30 '16 at 21:21
@Baron And there you have it. They show how to merge cells. They show how to split merged cells back into single cells. But there is NO WAY to split a single cell that is not part of a merged cell. Please read the question and understand the problem before shooting down a correct answer. I suggest you take back your downvote.
– teylyn
Aug 30 '16 at 21:49
@Baron Nothing more to say? I'm eagerly awaiting your response. Prove your claim that single cells can be split or take back your downvote. I challenge you.
– teylyn
Sep 2 '16 at 23:16
|
show 2 more comments
It is not possible to split an Excel cell into smaller parts (rows, columns).
This concept exists in Word tables or in html, but not in Excel.
When designing a spreadsheet you need to start from the smallest unit in a table, which is a cell. As discussed in the comments to your question, you can merge cells to span several rows or several columns.
Merged cells introduce problems with aspects of data selection, though, so use them with caution. Instead of merging cells across several columns, it is often better to use the cell alignment "Center across selection".
answered Sep 23 '15 at 11:09
teylyn
16.9k22539
It is not possible to split an Excel cell into smaller parts (rows, columns).
This concept exists in Word tables or in html, but not in Excel.
When designing a spreadsheet you need to start from the smallest unit in a table, which is a cell. As discussed in the comments to your question, you can merge cells to span several rows or several columns.
Merged cells introduce problems with aspects of data selection, though, so use them with caution. Instead of merging cells across several columns, it is often better to use the cell alignment "Center across selection".
answered Sep 23 '15 at 11:09
teylyn
16.9k22539
answered Sep 23 '15 at 11:09
teylyn
16.9k22539
answered Sep 23 '15 at 11:09
teylyn
16.9k22539
answered Sep 23 '15 at 11:09
teylyn
16.9k22539
16.9k22539
This does not answer the question nor it is quality answer. Of course you can split cells into smaller parts.
– amrx
Aug 30 '16 at 17:55
1
@Baron, pray please tell me how you split a cell in Excel into smaller parts. Post that as an answer and you'll have my upvote.
– teylyn
Aug 30 '16 at 20:40
The page explains how to merge split cells, computerhope.com/issues/ch000874.htm
– amrx
Aug 30 '16 at 21:21
@Baron And there you have it. They show how to merge cells. They show how to split merged cells back into single cells. But there is NO WAY to split a single cell that is not part of a merged cell. Please read the question and understand the problem before shooting down a correct answer. I suggest you take back your downvote.
– teylyn
Aug 30 '16 at 21:49
@Baron Nothing more to say? I'm eagerly awaiting your response. Prove your claim that single cells can be split or take back your downvote. I challenge you.
– teylyn
Sep 2 '16 at 23:16
|
show 2 more comments
This does not answer the question nor it is quality answer. Of course you can split cells into smaller parts.
– amrx
Aug 30 '16 at 17:55
1
@Baron, pray please tell me how you split a cell in Excel into smaller parts. Post that as an answer and you'll have my upvote.
– teylyn
Aug 30 '16 at 20:40
The page explains how to merge split cells, computerhope.com/issues/ch000874.htm
– amrx
Aug 30 '16 at 21:21
@Baron And there you have it. They show how to merge cells. They show how to split merged cells back into single cells. But there is NO WAY to split a single cell that is not part of a merged cell. Please read the question and understand the problem before shooting down a correct answer. I suggest you take back your downvote.
– teylyn
Aug 30 '16 at 21:49
@Baron Nothing more to say? I'm eagerly awaiting your response. Prove your claim that single cells can be split or take back your downvote. I challenge you.
– teylyn
Sep 2 '16 at 23:16
This does not answer the question nor it is quality answer. Of course you can split cells into smaller parts.
– amrx
Aug 30 '16 at 17:55
This does not answer the question nor it is quality answer. Of course you can split cells into smaller parts.
– amrx
Aug 30 '16 at 17:55
1
1
@Baron, pray please tell me how you split a cell in Excel into smaller parts. Post that as an answer and you'll have my upvote.
– teylyn
Aug 30 '16 at 20:40
@Baron, pray please tell me how you split a cell in Excel into smaller parts. Post that as an answer and you'll have my upvote.
– teylyn
Aug 30 '16 at 20:40
The page explains how to merge split cells, computerhope.com/issues/ch000874.htm
– amrx
Aug 30 '16 at 21:21
The page explains how to merge split cells, computerhope.com/issues/ch000874.htm
– amrx
Aug 30 '16 at 21:21
@Baron And there you have it. They show how to merge cells. They show how to split merged cells back into single cells. But there is NO WAY to split a single cell that is not part of a merged cell. Please read the question and understand the problem before shooting down a correct answer. I suggest you take back your downvote.
– teylyn
Aug 30 '16 at 21:49
@Baron And there you have it. They show how to merge cells. They show how to split merged cells back into single cells. But there is NO WAY to split a single cell that is not part of a merged cell. Please read the question and understand the problem before shooting down a correct answer. I suggest you take back your downvote.
– teylyn
Aug 30 '16 at 21:49
@Baron Nothing more to say? I'm eagerly awaiting your response. Prove your claim that single cells can be split or take back your downvote. I challenge you.
– teylyn
Sep 2 '16 at 23:16
@Baron Nothing more to say? I'm eagerly awaiting your response. Prove your claim that single cells can be split or take back your downvote. I challenge you.
– teylyn
Sep 2 '16 at 23:16
|
show 2 more comments
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f977001%2fhow-can-i-divide-cells-into-two-parts-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I want to divide a cell into two or more parts which should also let me select the divided part of the cell.
– ramji
Sep 23 '15 at 9:08
Hi ramji, welcome to Super User. Thanks for the screenshot to illustrate what you would like, but I don't understand how it shows what you want. Can you make it any clearer?
– bertieb
Sep 23 '15 at 9:11
@bertieb the screenshot shows a cell that has 2 parts. I wonder how you achieved that though as to my knowledge that is not possible. Did you draw that line yourself perhaps?
– LPChip
Sep 23 '15 at 9:12
@LPChip oh, my mistake- could not see that (bad eyesight), thanks for pointing it out
– bertieb
Sep 23 '15 at 9:13
3
I am pretty sure Excel does not have a unit smaller than a single cell. You could achieve this by merging B&C for all rows except row 2. How about explaining why you want this, there may be alternative approaches.
– Paul
Sep 23 '15 at 9:14