Excel pre-defined Styles keep coming back
MS Excel, MS Home and Business 2016.
Looking at the ribbon, Home Tab, "Styles box", on a full width screen.
I see "Conditional Formatting", "Format as Table" and then a bunch of pre-defined Styles available to just click on.
By default, in the first few rows, I have a bunch of "60% Accent" options, and then "Neutral 2" (yellow/orange) and "Title 2" (blue on white) etc. etc.
In my particular Sheet, I've defined some custom stylings, and saved those stylings. Now those stylings show up in the "Styles" grid, so that I can easily re-use them. Great!
It's annoying that they're not at the top of the Styles box, so I right-click on some of the pre-built ones and choose "Delete". They go away. Now my custom styles are the ones at the top of the box. Whoopee! Success!
And now I save and close my sheet and re-open it. Styles box still looks as it did when I closed the sheet. Hooray!
So far everything is behaving exactly as I would hope / expect.
The trouble is, this is at least the 4th time I've gone through the process of removing the "irrelevant" styles - they keep coming back. I don't know what causes them - I haven't got a way to forcibly reproduce it :(
What's going on, and can I stop it from happening?
microsoft-excel microsoft-office ribbon
asked Dec 21 '18 at 16:11
Brondahl
1157
add a comment |
MS Excel, MS Home and Business 2016.
Looking at the ribbon, Home Tab, "Styles box", on a full width screen.
I see "Conditional Formatting", "Format as Table" and then a bunch of pre-defined Styles available to just click on.
By default, in the first few rows, I have a bunch of "60% Accent" options, and then "Neutral 2" (yellow/orange) and "Title 2" (blue on white) etc. etc.
In my particular Sheet, I've defined some custom stylings, and saved those stylings. Now those stylings show up in the "Styles" grid, so that I can easily re-use them. Great!
It's annoying that they're not at the top of the Styles box, so I right-click on some of the pre-built ones and choose "Delete". They go away. Now my custom styles are the ones at the top of the box. Whoopee! Success!
And now I save and close my sheet and re-open it. Styles box still looks as it did when I closed the sheet. Hooray!
So far everything is behaving exactly as I would hope / expect.
The trouble is, this is at least the 4th time I've gone through the process of removing the "irrelevant" styles - they keep coming back. I don't know what causes them - I haven't got a way to forcibly reproduce it :(
What's going on, and can I stop it from happening?
microsoft-excel microsoft-office ribbon
asked Dec 21 '18 at 16:11
Brondahl
1157
Your custom styles should appear at the top of the "Styles" grid in any case. The order of the sections in my grid are: "Custom", "Good, Bad and Neutral", "Data and Model", "Titles and Headings", "Themed Cell Styles" (this is the section you are trying to delete), "Number Format". I'm not particularly surprised that the default sections keep coming back, but you shouldn't need to delete then as the "Custom" section should be at the top anyway.
– Blackwood
Dec 21 '18 at 16:34
@Bla ooh, interesting ... I don't normally click on the "More" arrow on the bottom right. Clicking on that, I get the same sub-sections you've listed there. I'll take a look at what in them, then next time it goes screwy.
– Brondahl
Dec 21 '18 at 17:33
add a comment |
MS Excel, MS Home and Business 2016.
Looking at the ribbon, Home Tab, "Styles box", on a full width screen.
I see "Conditional Formatting", "Format as Table" and then a bunch of pre-defined Styles available to just click on.
By default, in the first few rows, I have a bunch of "60% Accent" options, and then "Neutral 2" (yellow/orange) and "Title 2" (blue on white) etc. etc.
In my particular Sheet, I've defined some custom stylings, and saved those stylings. Now those stylings show up in the "Styles" grid, so that I can easily re-use them. Great!
It's annoying that they're not at the top of the Styles box, so I right-click on some of the pre-built ones and choose "Delete". They go away. Now my custom styles are the ones at the top of the box. Whoopee! Success!
And now I save and close my sheet and re-open it. Styles box still looks as it did when I closed the sheet. Hooray!
So far everything is behaving exactly as I would hope / expect.
The trouble is, this is at least the 4th time I've gone through the process of removing the "irrelevant" styles - they keep coming back. I don't know what causes them - I haven't got a way to forcibly reproduce it :(
What's going on, and can I stop it from happening?
microsoft-excel microsoft-office ribbon
asked Dec 21 '18 at 16:11
Brondahl
1157
MS Excel, MS Home and Business 2016.
Looking at the ribbon, Home Tab, "Styles box", on a full width screen.
I see "Conditional Formatting", "Format as Table" and then a bunch of pre-defined Styles available to just click on.
By default, in the first few rows, I have a bunch of "60% Accent" options, and then "Neutral 2" (yellow/orange) and "Title 2" (blue on white) etc. etc.
In my particular Sheet, I've defined some custom stylings, and saved those stylings. Now those stylings show up in the "Styles" grid, so that I can easily re-use them. Great!
It's annoying that they're not at the top of the Styles box, so I right-click on some of the pre-built ones and choose "Delete". They go away. Now my custom styles are the ones at the top of the box. Whoopee! Success!
And now I save and close my sheet and re-open it. Styles box still looks as it did when I closed the sheet. Hooray!
So far everything is behaving exactly as I would hope / expect.
The trouble is, this is at least the 4th time I've gone through the process of removing the "irrelevant" styles - they keep coming back. I don't know what causes them - I haven't got a way to forcibly reproduce it :(
What's going on, and can I stop it from happening?
microsoft-excel microsoft-office ribbon
microsoft-excel microsoft-office ribbon
asked Dec 21 '18 at 16:11
Brondahl
1157
asked Dec 21 '18 at 16:11
Brondahl
1157
asked Dec 21 '18 at 16:11
Brondahl
1157
asked Dec 21 '18 at 16:11
Brondahl
1157
asked Dec 21 '18 at 16:11
Brondahl
1157
1157
Your custom styles should appear at the top of the "Styles" grid in any case. The order of the sections in my grid are: "Custom", "Good, Bad and Neutral", "Data and Model", "Titles and Headings", "Themed Cell Styles" (this is the section you are trying to delete), "Number Format". I'm not particularly surprised that the default sections keep coming back, but you shouldn't need to delete then as the "Custom" section should be at the top anyway.
– Blackwood
Dec 21 '18 at 16:34
@Bla ooh, interesting ... I don't normally click on the "More" arrow on the bottom right. Clicking on that, I get the same sub-sections you've listed there. I'll take a look at what in them, then next time it goes screwy.
– Brondahl
Dec 21 '18 at 17:33
add a comment |
Your custom styles should appear at the top of the "Styles" grid in any case. The order of the sections in my grid are: "Custom", "Good, Bad and Neutral", "Data and Model", "Titles and Headings", "Themed Cell Styles" (this is the section you are trying to delete), "Number Format". I'm not particularly surprised that the default sections keep coming back, but you shouldn't need to delete then as the "Custom" section should be at the top anyway.
– Blackwood
Dec 21 '18 at 16:34
@Bla ooh, interesting ... I don't normally click on the "More" arrow on the bottom right. Clicking on that, I get the same sub-sections you've listed there. I'll take a look at what in them, then next time it goes screwy.
– Brondahl
Dec 21 '18 at 17:33
Your custom styles should appear at the top of the "Styles" grid in any case. The order of the sections in my grid are: "Custom", "Good, Bad and Neutral", "Data and Model", "Titles and Headings", "Themed Cell Styles" (this is the section you are trying to delete), "Number Format". I'm not particularly surprised that the default sections keep coming back, but you shouldn't need to delete then as the "Custom" section should be at the top anyway.
– Blackwood
Dec 21 '18 at 16:34
Your custom styles should appear at the top of the "Styles" grid in any case. The order of the sections in my grid are: "Custom", "Good, Bad and Neutral", "Data and Model", "Titles and Headings", "Themed Cell Styles" (this is the section you are trying to delete), "Number Format". I'm not particularly surprised that the default sections keep coming back, but you shouldn't need to delete then as the "Custom" section should be at the top anyway.
– Blackwood
Dec 21 '18 at 16:34
@Bla ooh, interesting ... I don't normally click on the "More" arrow on the bottom right. Clicking on that, I get the same sub-sections you've listed there. I'll take a look at what in them, then next time it goes screwy.
– Brondahl
Dec 21 '18 at 17:33
@Bla ooh, interesting ... I don't normally click on the "More" arrow on the bottom right. Clicking on that, I get the same sub-sections you've listed there. I'll take a look at what in them, then next time it goes screwy.
– Brondahl
Dec 21 '18 at 17:33
add a 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%2f1386708%2fexcel-pre-defined-styles-keep-coming-back%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.
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%2f1386708%2fexcel-pre-defined-styles-keep-coming-back%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
Your custom styles should appear at the top of the "Styles" grid in any case. The order of the sections in my grid are: "Custom", "Good, Bad and Neutral", "Data and Model", "Titles and Headings", "Themed Cell Styles" (this is the section you are trying to delete), "Number Format". I'm not particularly surprised that the default sections keep coming back, but you shouldn't need to delete then as the "Custom" section should be at the top anyway.
– Blackwood
Dec 21 '18 at 16:34
@Bla ooh, interesting ... I don't normally click on the "More" arrow on the bottom right. Clicking on that, I get the same sub-sections you've listed there. I'll take a look at what in them, then next time it goes screwy.
– Brondahl
Dec 21 '18 at 17:33