Mixing
Excel pivot table formatting keeps changing
Suppose I have a pivot table:
Now if I add a column in it turns into this:
Clearly the formatting has messed up on the lighter blue cells at the top. I wish these to be the same dark blue as the original.
Even worse it does this when even just the values of the raw data behind the pivot changes, let alone adding columns etc.
Is there a fix for this to lock the formatting as I am having to update many such pivots and changing the colour each time I make a single change on the raw data or want to add a new column on every pivot is getting tedious.
I have looked online and looked into preserve cell width + formatting option bt messing with those has not helped.
Any ideas?
PS: Can anyone embed the images for me?
excel pivot-table
edited Nov 20 '18 at 15:10
JNevill
31.7k31544
asked Nov 20 '18 at 14:55
user9940344user9940344
63
add a comment |
Suppose I have a pivot table:
Now if I add a column in it turns into this:
Clearly the formatting has messed up on the lighter blue cells at the top. I wish these to be the same dark blue as the original.
Even worse it does this when even just the values of the raw data behind the pivot changes, let alone adding columns etc.
Is there a fix for this to lock the formatting as I am having to update many such pivots and changing the colour each time I make a single change on the raw data or want to add a new column on every pivot is getting tedious.
I have looked online and looked into preserve cell width + formatting option bt messing with those has not helped.
Any ideas?
PS: Can anyone embed the images for me?
excel pivot-table
edited Nov 20 '18 at 15:10
JNevill
31.7k31544
asked Nov 20 '18 at 14:55
user9940344user9940344
63
In future, try smaller screen shots :) I have also had issues with pivots and formatting so I have just stopped formatting them and or stick to pre-designed formats. Hope someone else has a better answer as I will be saving this question!
– urdearboy
Nov 20 '18 at 14:57
Thanks for the advice, I have added smaller screenshots can you see them properly?
– user9940344
Nov 20 '18 at 15:05
Voting to move this to superuser.com since it has nothing to do with programming.
– JNevill
Nov 20 '18 at 15:11
add a comment |
Suppose I have a pivot table:
Now if I add a column in it turns into this:
Clearly the formatting has messed up on the lighter blue cells at the top. I wish these to be the same dark blue as the original.
Even worse it does this when even just the values of the raw data behind the pivot changes, let alone adding columns etc.
Is there a fix for this to lock the formatting as I am having to update many such pivots and changing the colour each time I make a single change on the raw data or want to add a new column on every pivot is getting tedious.
I have looked online and looked into preserve cell width + formatting option bt messing with those has not helped.
Any ideas?
PS: Can anyone embed the images for me?
excel pivot-table
edited Nov 20 '18 at 15:10
JNevill
31.7k31544
asked Nov 20 '18 at 14:55
user9940344user9940344
63
Suppose I have a pivot table:
Now if I add a column in it turns into this:
Clearly the formatting has messed up on the lighter blue cells at the top. I wish these to be the same dark blue as the original.
Even worse it does this when even just the values of the raw data behind the pivot changes, let alone adding columns etc.
Is there a fix for this to lock the formatting as I am having to update many such pivots and changing the colour each time I make a single change on the raw data or want to add a new column on every pivot is getting tedious.
I have looked online and looked into preserve cell width + formatting option bt messing with those has not helped.
Any ideas?
PS: Can anyone embed the images for me?
excel pivot-table
excel pivot-table
edited Nov 20 '18 at 15:10
JNevill
31.7k31544
asked Nov 20 '18 at 14:55
user9940344user9940344
63
edited Nov 20 '18 at 15:10
JNevill
31.7k31544
asked Nov 20 '18 at 14:55
user9940344user9940344
63
edited Nov 20 '18 at 15:10
JNevill
31.7k31544
edited Nov 20 '18 at 15:10
JNevill
31.7k31544
edited Nov 20 '18 at 15:10
JNevill
31.7k31544
31.7k31544
asked Nov 20 '18 at 14:55
user9940344user9940344
63
asked Nov 20 '18 at 14:55
user9940344user9940344
63
asked Nov 20 '18 at 14:55
user9940344user9940344
63
63
In future, try smaller screen shots :) I have also had issues with pivots and formatting so I have just stopped formatting them and or stick to pre-designed formats. Hope someone else has a better answer as I will be saving this question!
– urdearboy
Nov 20 '18 at 14:57
Thanks for the advice, I have added smaller screenshots can you see them properly?
– user9940344
Nov 20 '18 at 15:05
Voting to move this to superuser.com since it has nothing to do with programming.
– JNevill
Nov 20 '18 at 15:11
add a comment |
In future, try smaller screen shots :) I have also had issues with pivots and formatting so I have just stopped formatting them and or stick to pre-designed formats. Hope someone else has a better answer as I will be saving this question!
– urdearboy
Nov 20 '18 at 14:57
Thanks for the advice, I have added smaller screenshots can you see them properly?
– user9940344
Nov 20 '18 at 15:05
Voting to move this to superuser.com since it has nothing to do with programming.
– JNevill
Nov 20 '18 at 15:11
In future, try smaller screen shots :) I have also had issues with pivots and formatting so I have just stopped formatting them and or stick to pre-designed formats. Hope someone else has a better answer as I will be saving this question!
– urdearboy
Nov 20 '18 at 14:57
In future, try smaller screen shots :) I have also had issues with pivots and formatting so I have just stopped formatting them and or stick to pre-designed formats. Hope someone else has a better answer as I will be saving this question!
– urdearboy
Nov 20 '18 at 14:57
Thanks for the advice, I have added smaller screenshots can you see them properly?
– user9940344
Nov 20 '18 at 15:05
Thanks for the advice, I have added smaller screenshots can you see them properly?
– user9940344
Nov 20 '18 at 15:05
Voting to move this to superuser.com since it has nothing to do with programming.
– JNevill
Nov 20 '18 at 15:11
Voting to move this to superuser.com since it has nothing to do with programming.
– JNevill
Nov 20 '18 at 15:11
add a comment |
1 Answer
1
active
oldest
votes
If you want to preserve the formatting, you need to add a new pivot table style. Within a pivot table, choose Design on the ribbon. You'll see swatches of the existing pivot table styles. Choose the down arrow and "New Pivot Table Style."
This dialog box will appear.
From here, you could specify the header, total row, and row styles you'd want. Once applied to a pivot table, new columns won't affect the style.
answered Nov 20 '18 at 15:10
extensionhelpextensionhelp
2557
This worked great thank you!
– user9940344
Nov 20 '18 at 15:31
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53395692%2fexcel-pivot-table-formatting-keeps-changing%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
If you want to preserve the formatting, you need to add a new pivot table style. Within a pivot table, choose Design on the ribbon. You'll see swatches of the existing pivot table styles. Choose the down arrow and "New Pivot Table Style."
This dialog box will appear.
From here, you could specify the header, total row, and row styles you'd want. Once applied to a pivot table, new columns won't affect the style.
answered Nov 20 '18 at 15:10
extensionhelpextensionhelp
2557
This worked great thank you!
– user9940344
Nov 20 '18 at 15:31
add a comment |
If you want to preserve the formatting, you need to add a new pivot table style. Within a pivot table, choose Design on the ribbon. You'll see swatches of the existing pivot table styles. Choose the down arrow and "New Pivot Table Style."
This dialog box will appear.
From here, you could specify the header, total row, and row styles you'd want. Once applied to a pivot table, new columns won't affect the style.
answered Nov 20 '18 at 15:10
extensionhelpextensionhelp
2557
This worked great thank you!
– user9940344
Nov 20 '18 at 15:31
add a comment |
If you want to preserve the formatting, you need to add a new pivot table style. Within a pivot table, choose Design on the ribbon. You'll see swatches of the existing pivot table styles. Choose the down arrow and "New Pivot Table Style."
This dialog box will appear.
From here, you could specify the header, total row, and row styles you'd want. Once applied to a pivot table, new columns won't affect the style.
answered Nov 20 '18 at 15:10
extensionhelpextensionhelp
2557
If you want to preserve the formatting, you need to add a new pivot table style. Within a pivot table, choose Design on the ribbon. You'll see swatches of the existing pivot table styles. Choose the down arrow and "New Pivot Table Style."
This dialog box will appear.
From here, you could specify the header, total row, and row styles you'd want. Once applied to a pivot table, new columns won't affect the style.
answered Nov 20 '18 at 15:10
extensionhelpextensionhelp
2557
answered Nov 20 '18 at 15:10
extensionhelpextensionhelp
2557
answered Nov 20 '18 at 15:10
extensionhelpextensionhelp
2557
answered Nov 20 '18 at 15:10
extensionhelpextensionhelp
2557
2557
This worked great thank you!
– user9940344
Nov 20 '18 at 15:31
add a comment |
This worked great thank you!
– user9940344
Nov 20 '18 at 15:31
This worked great thank you!
– user9940344
Nov 20 '18 at 15:31
This worked great thank you!
– user9940344
Nov 20 '18 at 15:31
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53395692%2fexcel-pivot-table-formatting-keeps-changing%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
In future, try smaller screen shots :) I have also had issues with pivots and formatting so I have just stopped formatting them and or stick to pre-designed formats. Hope someone else has a better answer as I will be saving this question!
– urdearboy
Nov 20 '18 at 14:57
Thanks for the advice, I have added smaller screenshots can you see them properly?
– user9940344
Nov 20 '18 at 15:05
Voting to move this to superuser.com since it has nothing to do with programming.
– JNevill
Nov 20 '18 at 15:11