How to keep pivot table from expanding into occupied rows and columnsAdding multiple value columns to a pivot...
Compress command output by piping to bzip2
How to prevent users from executing commands through browser URL
Every character has a name - does this lead to too many named characters?
Process to change collation on a database
Citing paywalled articles accessed via illegal web sharing
Can you earn endless XP using a Flameskull and its self-revival feature?
Program that converts a number to a letter of the alphabet
How to explain planetary rings pulsating?
Difference between two quite-similar Terminal commands
Grade 10 Analytic Geometry Question 23- Incredibly hard
Slow moving projectiles from a hand-held weapon - how do they reach the target?
Would a National Army of mercenaries be a feasible idea?
Book where aliens are selecting humans for food consumption
Where are a monster’s hit dice found in the stat block?
What is the purpose of easy combat scenarios that don't need resource expenditure?
Why did the villain in the first Men in Black movie care about Earth's Cockroaches?
What's a good word to describe a public place that looks like it wouldn't be rough?
It took me a lot of time to make this, pls like. (YouTube Comments #1)
What is the wife of a henpecked husband called?
Does Improved Divine Smite trigger when a paladin makes an unarmed strike?
Groups acting on trees
How to tag distinct options/entities without giving any an implicit priority or suggested order?
Parsing a string of key-value pairs as a dictionary
why a subspace is closed?
How to keep pivot table from expanding into occupied rows and columns
Adding multiple value columns to a pivot tableRefreshing Pivot Table clears Values and Column Labels fieldsHow to remove the “blank” column or row in the pivot tableHave Pivot Chart show only some columns in pivot tableFilter a pivot table based on the values in specific columnsSearch table and combine rows with identical A and B columns and add their value in C columnCannot sort Excel Pivot Table by two or more columnsHow to limit a pivot table to show only centain number of rowsHow to compare fields in Pivot TableHow to sort duplicate rows of values into unique rows and multiple columns
I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations are, and eventually must delete their contents if I wish to keep on making the pivot table "bigger". Is there a way to border a pivot table with say 2 empty rows and columns around it, so that even if I want to make the pivot table bigger, there still exists a border between it and my calculations?
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 pivot-table
edited Jun 8 '15 at 19:52
Excellll
11.1k74163
asked Jun 8 '15 at 18:49
Rey MalileRey Malile
11
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations are, and eventually must delete their contents if I wish to keep on making the pivot table "bigger". Is there a way to border a pivot table with say 2 empty rows and columns around it, so that even if I want to make the pivot table bigger, there still exists a border between it and my calculations?
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 pivot-table
edited Jun 8 '15 at 19:52
Excellll
11.1k74163
asked Jun 8 '15 at 18:49
Rey MalileRey Malile
11
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
You can manually add the rows and columns, but the Pivot Table will not respect the "boundaries" you have created for it. If you want to ensure no overlap, you need to take advantage of some knowledge of how many rows/columns could be there. e.g.: if months are columns, there can only be 12, etc. If you have no known limit, then you are stuck and probably want to put the formulas somewhere else.
– Byron Wall
Jun 8 '15 at 19:48
add a comment |
I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations are, and eventually must delete their contents if I wish to keep on making the pivot table "bigger". Is there a way to border a pivot table with say 2 empty rows and columns around it, so that even if I want to make the pivot table bigger, there still exists a border between it and my calculations?
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 pivot-table
edited Jun 8 '15 at 19:52
Excellll
11.1k74163
asked Jun 8 '15 at 18:49
Rey MalileRey Malile
11
I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations are, and eventually must delete their contents if I wish to keep on making the pivot table "bigger". Is there a way to border a pivot table with say 2 empty rows and columns around it, so that even if I want to make the pivot table bigger, there still exists a border between it and my calculations?
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 pivot-table
microsoft-excel microsoft-excel-2010 microsoft-excel-2007 pivot-table
edited Jun 8 '15 at 19:52
Excellll
11.1k74163
asked Jun 8 '15 at 18:49
Rey MalileRey Malile
11
edited Jun 8 '15 at 19:52
Excellll
11.1k74163
asked Jun 8 '15 at 18:49
Rey MalileRey Malile
11
edited Jun 8 '15 at 19:52
Excellll
11.1k74163
edited Jun 8 '15 at 19:52
Excellll
11.1k74163
edited Jun 8 '15 at 19:52
Excellll
11.1k74163
11.1k74163
asked Jun 8 '15 at 18:49
Rey MalileRey Malile
11
asked Jun 8 '15 at 18:49
Rey MalileRey Malile
11
asked Jun 8 '15 at 18:49
Rey MalileRey Malile
11
11
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
You can manually add the rows and columns, but the Pivot Table will not respect the "boundaries" you have created for it. If you want to ensure no overlap, you need to take advantage of some knowledge of how many rows/columns could be there. e.g.: if months are columns, there can only be 12, etc. If you have no known limit, then you are stuck and probably want to put the formulas somewhere else.
– Byron Wall
Jun 8 '15 at 19:48
add a comment |
You can manually add the rows and columns, but the Pivot Table will not respect the "boundaries" you have created for it. If you want to ensure no overlap, you need to take advantage of some knowledge of how many rows/columns could be there. e.g.: if months are columns, there can only be 12, etc. If you have no known limit, then you are stuck and probably want to put the formulas somewhere else.
– Byron Wall
Jun 8 '15 at 19:48
You can manually add the rows and columns, but the Pivot Table will not respect the "boundaries" you have created for it. If you want to ensure no overlap, you need to take advantage of some knowledge of how many rows/columns could be there. e.g.: if months are columns, there can only be 12, etc. If you have no known limit, then you are stuck and probably want to put the formulas somewhere else.
– Byron Wall
Jun 8 '15 at 19:48
You can manually add the rows and columns, but the Pivot Table will not respect the "boundaries" you have created for it. If you want to ensure no overlap, you need to take advantage of some knowledge of how many rows/columns could be there. e.g.: if months are columns, there can only be 12, etc. If you have no known limit, then you are stuck and probably want to put the formulas somewhere else.
– Byron Wall
Jun 8 '15 at 19:48
add a comment |
1 Answer
1
active
oldest
votes
Pivot tables will expand down and to the right and will not care if there is any other data already in the cells. You may want to re-arrange your sheet to have formulas to the left and above any pivot table. That way, there is no risk of the pivot overwriting your formulas.
answered Jun 8 '15 at 22:26
teylynteylyn
17.3k22539
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%2f925372%2fhow-to-keep-pivot-table-from-expanding-into-occupied-rows-and-columns%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
Pivot tables will expand down and to the right and will not care if there is any other data already in the cells. You may want to re-arrange your sheet to have formulas to the left and above any pivot table. That way, there is no risk of the pivot overwriting your formulas.
answered Jun 8 '15 at 22:26
teylynteylyn
17.3k22539
add a comment |
Pivot tables will expand down and to the right and will not care if there is any other data already in the cells. You may want to re-arrange your sheet to have formulas to the left and above any pivot table. That way, there is no risk of the pivot overwriting your formulas.
answered Jun 8 '15 at 22:26
teylynteylyn
17.3k22539
add a comment |
Pivot tables will expand down and to the right and will not care if there is any other data already in the cells. You may want to re-arrange your sheet to have formulas to the left and above any pivot table. That way, there is no risk of the pivot overwriting your formulas.
answered Jun 8 '15 at 22:26
teylynteylyn
17.3k22539
Pivot tables will expand down and to the right and will not care if there is any other data already in the cells. You may want to re-arrange your sheet to have formulas to the left and above any pivot table. That way, there is no risk of the pivot overwriting your formulas.
answered Jun 8 '15 at 22:26
teylynteylyn
17.3k22539
answered Jun 8 '15 at 22:26
teylynteylyn
17.3k22539
answered Jun 8 '15 at 22:26
teylynteylyn
17.3k22539
answered Jun 8 '15 at 22:26
teylynteylyn
17.3k22539
17.3k22539
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%2f925372%2fhow-to-keep-pivot-table-from-expanding-into-occupied-rows-and-columns%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
You can manually add the rows and columns, but the Pivot Table will not respect the "boundaries" you have created for it. If you want to ensure no overlap, you need to take advantage of some knowledge of how many rows/columns could be there. e.g.: if months are columns, there can only be 12, etc. If you have no known limit, then you are stuck and probably want to put the formulas somewhere else.
– Byron Wall
Jun 8 '15 at 19:48