Nest cells in Excel 2010
I was directed here from Stack Overflow... hope you guys can help
I have been looking into trying to nest cells in Excel, much like how the folder tree system works in File Explorer, or the folder system in Outlook.
Further examples would be having the little box with a '+' in it to expand the selection, then the '-' to contract. I've searched Google to look for any help but couldn't really find anything, perhaps this means it cannot be done but thought I'd ask here to get some expert advice.
Thanks
Someone in Stack Overflow mentioned Outlines, which I'm currently looking at
EDIT: Outlines worked perfectly.
microsoft-excel microsoft-excel-2010
asked Jul 3 '12 at 13:24
benben
724
add a comment |
I was directed here from Stack Overflow... hope you guys can help
I have been looking into trying to nest cells in Excel, much like how the folder tree system works in File Explorer, or the folder system in Outlook.
Further examples would be having the little box with a '+' in it to expand the selection, then the '-' to contract. I've searched Google to look for any help but couldn't really find anything, perhaps this means it cannot be done but thought I'd ask here to get some expert advice.
Thanks
Someone in Stack Overflow mentioned Outlines, which I'm currently looking at
EDIT: Outlines worked perfectly.
microsoft-excel microsoft-excel-2010
asked Jul 3 '12 at 13:24
benben
724
4
Hello Ben, if you have found a solution to this question, please post it as an answer and accept it, for future visitors.
– Paul
Jul 3 '12 at 13:50
1
You could have asked a moderator to migrate your question to here by raising a flag on it over there. That way, we retain the responses. Remember that these sites are meant as a reference for other people to use not just the person that asked the question.
– Julian Knight
Jul 5 '12 at 16:48
add a comment |
I was directed here from Stack Overflow... hope you guys can help
I have been looking into trying to nest cells in Excel, much like how the folder tree system works in File Explorer, or the folder system in Outlook.
Further examples would be having the little box with a '+' in it to expand the selection, then the '-' to contract. I've searched Google to look for any help but couldn't really find anything, perhaps this means it cannot be done but thought I'd ask here to get some expert advice.
Thanks
Someone in Stack Overflow mentioned Outlines, which I'm currently looking at
EDIT: Outlines worked perfectly.
microsoft-excel microsoft-excel-2010
asked Jul 3 '12 at 13:24
benben
724
I was directed here from Stack Overflow... hope you guys can help
I have been looking into trying to nest cells in Excel, much like how the folder tree system works in File Explorer, or the folder system in Outlook.
Further examples would be having the little box with a '+' in it to expand the selection, then the '-' to contract. I've searched Google to look for any help but couldn't really find anything, perhaps this means it cannot be done but thought I'd ask here to get some expert advice.
Thanks
Someone in Stack Overflow mentioned Outlines, which I'm currently looking at
EDIT: Outlines worked perfectly.
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
asked Jul 3 '12 at 13:24
benben
724
asked Jul 3 '12 at 13:24
benben
724
asked Jul 3 '12 at 13:24
benben
724
asked Jul 3 '12 at 13:24
benben
724
asked Jul 3 '12 at 13:24
benben
724
724
4
Hello Ben, if you have found a solution to this question, please post it as an answer and accept it, for future visitors.
– Paul
Jul 3 '12 at 13:50
1
You could have asked a moderator to migrate your question to here by raising a flag on it over there. That way, we retain the responses. Remember that these sites are meant as a reference for other people to use not just the person that asked the question.
– Julian Knight
Jul 5 '12 at 16:48
add a comment |
4
Hello Ben, if you have found a solution to this question, please post it as an answer and accept it, for future visitors.
– Paul
Jul 3 '12 at 13:50
1
You could have asked a moderator to migrate your question to here by raising a flag on it over there. That way, we retain the responses. Remember that these sites are meant as a reference for other people to use not just the person that asked the question.
– Julian Knight
Jul 5 '12 at 16:48
4
4
Hello Ben, if you have found a solution to this question, please post it as an answer and accept it, for future visitors.
– Paul
Jul 3 '12 at 13:50
Hello Ben, if you have found a solution to this question, please post it as an answer and accept it, for future visitors.
– Paul
Jul 3 '12 at 13:50
1
1
You could have asked a moderator to migrate your question to here by raising a flag on it over there. That way, we retain the responses. Remember that these sites are meant as a reference for other people to use not just the person that asked the question.
– Julian Knight
Jul 5 '12 at 16:48
You could have asked a moderator to migrate your question to here by raising a flag on it over there. That way, we retain the responses. Remember that these sites are meant as a reference for other people to use not just the person that asked the question.
– Julian Knight
Jul 5 '12 at 16:48
add a comment |
1 Answer
1
active
oldest
votes
Select the rows you want to nest together and then, in the Data ribbon, click Group.
A new column appears to the left of the row headers. Clicking the - collapses the rows. Clicking the + expands the rows.
answered Jan 29 '16 at 19:40
Engineer ToastEngineer Toast
2,9181828
add a comment |
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%2f444398%2fnest-cells-in-excel-2010%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
Select the rows you want to nest together and then, in the Data ribbon, click Group.
A new column appears to the left of the row headers. Clicking the - collapses the rows. Clicking the + expands the rows.
answered Jan 29 '16 at 19:40
Engineer ToastEngineer Toast
2,9181828
add a comment |
Select the rows you want to nest together and then, in the Data ribbon, click Group.
A new column appears to the left of the row headers. Clicking the - collapses the rows. Clicking the + expands the rows.
answered Jan 29 '16 at 19:40
Engineer ToastEngineer Toast
2,9181828
add a comment |
Select the rows you want to nest together and then, in the Data ribbon, click Group.
A new column appears to the left of the row headers. Clicking the - collapses the rows. Clicking the + expands the rows.
answered Jan 29 '16 at 19:40
Engineer ToastEngineer Toast
2,9181828
Select the rows you want to nest together and then, in the Data ribbon, click Group.
A new column appears to the left of the row headers. Clicking the - collapses the rows. Clicking the + expands the rows.
answered Jan 29 '16 at 19:40
Engineer ToastEngineer Toast
2,9181828
answered Jan 29 '16 at 19:40
Engineer ToastEngineer Toast
2,9181828
answered Jan 29 '16 at 19:40
Engineer ToastEngineer Toast
2,9181828
answered Jan 29 '16 at 19:40
Engineer ToastEngineer Toast
2,9181828
2,9181828
add a comment |
add a comment |
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.
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%2f444398%2fnest-cells-in-excel-2010%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
4
Hello Ben, if you have found a solution to this question, please post it as an answer and accept it, for future visitors.
– Paul
Jul 3 '12 at 13:50
1
You could have asked a moderator to migrate your question to here by raising a flag on it over there. That way, we retain the responses. Remember that these sites are meant as a reference for other people to use not just the person that asked the question.
– Julian Knight
Jul 5 '12 at 16:48