Custom sorting list
I wanted sort pivot data according to the months and not from A to Z.
The monthly sorting is not included in my Excel, therefore, I tried to add a custom sorting from the Excel options (options-> advance-> general-> edit custom lists). However, when I click on the edit custom lists tab it doesn't open up and doesn't allow me to create any custom lists.
I have the same problem with sorting data even when it is not in a pivot table.
Any ideas how to solve the problem?
Excel settings
microsoft-excel sorting
asked Jan 30 at 14:50
EleonoraEleonora
13
|
show 1 more comment
I wanted sort pivot data according to the months and not from A to Z.
The monthly sorting is not included in my Excel, therefore, I tried to add a custom sorting from the Excel options (options-> advance-> general-> edit custom lists). However, when I click on the edit custom lists tab it doesn't open up and doesn't allow me to create any custom lists.
I have the same problem with sorting data even when it is not in a pivot table.
Any ideas how to solve the problem?
Excel settings
microsoft-excel sorting
asked Jan 30 at 14:50
EleonoraEleonora
13
this may contain a good reference/solution..
– p._phidot_
Jan 31 at 2:00
How about creating a list in Worksheet first and then selecting the list range to Custom list?
– Lee
Jan 31 at 8:31
@Lee that is exactly my problem. I cannot create any Custom lists.
– Eleonora
Jan 31 at 12:19
@p._phidot_ thanks I have a look and hopefully find a solution!
– Eleonora
Jan 31 at 12:19
I think we can't recommend a solution coz you didn't share a sample file/screenshot/data.. || You may share these, so that we may proceed here. ( :
– p._phidot_
Feb 1 at 0:44
|
show 1 more comment
I wanted sort pivot data according to the months and not from A to Z.
The monthly sorting is not included in my Excel, therefore, I tried to add a custom sorting from the Excel options (options-> advance-> general-> edit custom lists). However, when I click on the edit custom lists tab it doesn't open up and doesn't allow me to create any custom lists.
I have the same problem with sorting data even when it is not in a pivot table.
Any ideas how to solve the problem?
Excel settings
microsoft-excel sorting
asked Jan 30 at 14:50
EleonoraEleonora
13
I wanted sort pivot data according to the months and not from A to Z.
The monthly sorting is not included in my Excel, therefore, I tried to add a custom sorting from the Excel options (options-> advance-> general-> edit custom lists). However, when I click on the edit custom lists tab it doesn't open up and doesn't allow me to create any custom lists.
I have the same problem with sorting data even when it is not in a pivot table.
Any ideas how to solve the problem?
Excel settings
microsoft-excel sorting
microsoft-excel sorting
asked Jan 30 at 14:50
EleonoraEleonora
13
asked Jan 30 at 14:50
EleonoraEleonora
13
edited Feb 1 at 14:28
Eleonora
asked Jan 30 at 14:50
EleonoraEleonora
13
asked Jan 30 at 14:50
EleonoraEleonora
13
asked Jan 30 at 14:50
EleonoraEleonora
13
13
this may contain a good reference/solution..
– p._phidot_
Jan 31 at 2:00
How about creating a list in Worksheet first and then selecting the list range to Custom list?
– Lee
Jan 31 at 8:31
@Lee that is exactly my problem. I cannot create any Custom lists.
– Eleonora
Jan 31 at 12:19
@p._phidot_ thanks I have a look and hopefully find a solution!
– Eleonora
Jan 31 at 12:19
I think we can't recommend a solution coz you didn't share a sample file/screenshot/data.. || You may share these, so that we may proceed here. ( :
– p._phidot_
Feb 1 at 0:44
|
show 1 more comment
this may contain a good reference/solution..
– p._phidot_
Jan 31 at 2:00
How about creating a list in Worksheet first and then selecting the list range to Custom list?
– Lee
Jan 31 at 8:31
@Lee that is exactly my problem. I cannot create any Custom lists.
– Eleonora
Jan 31 at 12:19
@p._phidot_ thanks I have a look and hopefully find a solution!
– Eleonora
Jan 31 at 12:19
I think we can't recommend a solution coz you didn't share a sample file/screenshot/data.. || You may share these, so that we may proceed here. ( :
– p._phidot_
Feb 1 at 0:44
this may contain a good reference/solution..
– p._phidot_
Jan 31 at 2:00
this may contain a good reference/solution..
– p._phidot_
Jan 31 at 2:00
How about creating a list in Worksheet first and then selecting the list range to Custom list?
– Lee
Jan 31 at 8:31
How about creating a list in Worksheet first and then selecting the list range to Custom list?
– Lee
Jan 31 at 8:31
@Lee that is exactly my problem. I cannot create any Custom lists.
– Eleonora
Jan 31 at 12:19
@Lee that is exactly my problem. I cannot create any Custom lists.
– Eleonora
Jan 31 at 12:19
@p._phidot_ thanks I have a look and hopefully find a solution!
– Eleonora
Jan 31 at 12:19
@p._phidot_ thanks I have a look and hopefully find a solution!
– Eleonora
Jan 31 at 12:19
I think we can't recommend a solution coz you didn't share a sample file/screenshot/data.. || You may share these, so that we may proceed here. ( :
– p._phidot_
Feb 1 at 0:44
I think we can't recommend a solution coz you didn't share a sample file/screenshot/data.. || You may share these, so that we may proceed here. ( :
– p._phidot_
Feb 1 at 0:44
|
show 1 more comment
0
active
oldest
votes
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%2f1400115%2fcustom-sorting-list%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1400115%2fcustom-sorting-list%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
this may contain a good reference/solution..
– p._phidot_
Jan 31 at 2:00
How about creating a list in Worksheet first and then selecting the list range to Custom list?
– Lee
Jan 31 at 8:31
@Lee that is exactly my problem. I cannot create any Custom lists.
– Eleonora
Jan 31 at 12:19
@p._phidot_ thanks I have a look and hopefully find a solution!
– Eleonora
Jan 31 at 12:19
I think we can't recommend a solution coz you didn't share a sample file/screenshot/data.. || You may share these, so that we may proceed here. ( :
– p._phidot_
Feb 1 at 0:44