How do I select non-adjacent ranges in libreoffice calc?
I'd like to perform an operation on a set of non adjacent ranges in LibreOffice calc.
I can type: C4:GA4 into the "name" box in order to select a single range. Is there a way to select non adjacent ranges (eg. C4:GA4,C15:GA15), or am I stuck using the tedious and error-prone Ctrl-click and drag method?
Edit: To clarify, I want a way to SELECT these ranges. I'm not attempting to feed them into a formula. In this particular case, I want to select a set of ranges for use in building a chart. There are enough ranges that selecting each manually would be very time consuming.
libreoffice-calc
asked Feb 13 '13 at 17:22
vezultvezult
12115
add a comment |
I'd like to perform an operation on a set of non adjacent ranges in LibreOffice calc.
I can type: C4:GA4 into the "name" box in order to select a single range. Is there a way to select non adjacent ranges (eg. C4:GA4,C15:GA15), or am I stuck using the tedious and error-prone Ctrl-click and drag method?
Edit: To clarify, I want a way to SELECT these ranges. I'm not attempting to feed them into a formula. In this particular case, I want to select a set of ranges for use in building a chart. There are enough ranges that selecting each manually would be very time consuming.
libreoffice-calc
asked Feb 13 '13 at 17:22
vezultvezult
12115
add a comment |
I'd like to perform an operation on a set of non adjacent ranges in LibreOffice calc.
I can type: C4:GA4 into the "name" box in order to select a single range. Is there a way to select non adjacent ranges (eg. C4:GA4,C15:GA15), or am I stuck using the tedious and error-prone Ctrl-click and drag method?
Edit: To clarify, I want a way to SELECT these ranges. I'm not attempting to feed them into a formula. In this particular case, I want to select a set of ranges for use in building a chart. There are enough ranges that selecting each manually would be very time consuming.
libreoffice-calc
asked Feb 13 '13 at 17:22
vezultvezult
12115
I'd like to perform an operation on a set of non adjacent ranges in LibreOffice calc.
I can type: C4:GA4 into the "name" box in order to select a single range. Is there a way to select non adjacent ranges (eg. C4:GA4,C15:GA15), or am I stuck using the tedious and error-prone Ctrl-click and drag method?
Edit: To clarify, I want a way to SELECT these ranges. I'm not attempting to feed them into a formula. In this particular case, I want to select a set of ranges for use in building a chart. There are enough ranges that selecting each manually would be very time consuming.
libreoffice-calc
libreoffice-calc
asked Feb 13 '13 at 17:22
vezultvezult
12115
asked Feb 13 '13 at 17:22
vezultvezult
12115
edited Feb 13 '13 at 18:53
vezult
asked Feb 13 '13 at 17:22
vezultvezult
12115
asked Feb 13 '13 at 17:22
vezultvezult
12115
asked Feb 13 '13 at 17:22
vezultvezult
12115
12115
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
If I am reading your question correctly, calc allows use of multiple non-adjacent ranges in formulae:
The basic example I tried was:
=SUM(B2:B3,D2:D3,F2:F3)
Where it successfully applied SUM calculating every range.
I hope that answers your question.
answered Feb 13 '13 at 18:38
StonestormStonestorm
451211
Unfortunately, that's not really what I'm after. I've modified my question so that it is (hopefully) more clear.
– vezult
Feb 13 '13 at 18:53
add a comment |
One thing that you can do is to use another selection mode instead of the standard, then copy the contents to another place (choose an upper left cell) and perform the desired calculation.
My suggestion for your case.
In the calc window, at the bottom, in the middle of the window, there are two symbols, The one on the left is grey. So, you select one of the cells at the extreme of the range (ex. C4). Then, you can press the adding selection. Press CTRL + SHIPT + RIGHT cursor to move to the other end of the contiguous block of cells (you're now at GA4).
Copy the cells to another sheet and possibly transpose the selection so that you have the cells in one column.
Repeat it to the 15th row and paste (and transpose) it to the end of the last set pasted. Name the extended set.
Now perform the calculation you need.
answered Feb 13 '13 at 18:58
LuisLuis
602713
This doesn't scale well. If, for example, I needed to do that 50 times for very long rows...it would take forever. It is slightly less error prone than using the mouse, I'll give you that.
– vezult
Feb 13 '13 at 19:06
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%2f550667%2fhow-do-i-select-non-adjacent-ranges-in-libreoffice-calc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
If I am reading your question correctly, calc allows use of multiple non-adjacent ranges in formulae:
The basic example I tried was:
=SUM(B2:B3,D2:D3,F2:F3)
Where it successfully applied SUM calculating every range.
I hope that answers your question.
answered Feb 13 '13 at 18:38
StonestormStonestorm
451211
Unfortunately, that's not really what I'm after. I've modified my question so that it is (hopefully) more clear.
– vezult
Feb 13 '13 at 18:53
add a comment |
If I am reading your question correctly, calc allows use of multiple non-adjacent ranges in formulae:
The basic example I tried was:
=SUM(B2:B3,D2:D3,F2:F3)
Where it successfully applied SUM calculating every range.
I hope that answers your question.
answered Feb 13 '13 at 18:38
StonestormStonestorm
451211
Unfortunately, that's not really what I'm after. I've modified my question so that it is (hopefully) more clear.
– vezult
Feb 13 '13 at 18:53
add a comment |
If I am reading your question correctly, calc allows use of multiple non-adjacent ranges in formulae:
The basic example I tried was:
=SUM(B2:B3,D2:D3,F2:F3)
Where it successfully applied SUM calculating every range.
I hope that answers your question.
answered Feb 13 '13 at 18:38
StonestormStonestorm
451211
If I am reading your question correctly, calc allows use of multiple non-adjacent ranges in formulae:
The basic example I tried was:
=SUM(B2:B3,D2:D3,F2:F3)
Where it successfully applied SUM calculating every range.
I hope that answers your question.
answered Feb 13 '13 at 18:38
StonestormStonestorm
451211
answered Feb 13 '13 at 18:38
StonestormStonestorm
451211
answered Feb 13 '13 at 18:38
StonestormStonestorm
451211
answered Feb 13 '13 at 18:38
StonestormStonestorm
451211
451211
Unfortunately, that's not really what I'm after. I've modified my question so that it is (hopefully) more clear.
– vezult
Feb 13 '13 at 18:53
add a comment |
Unfortunately, that's not really what I'm after. I've modified my question so that it is (hopefully) more clear.
– vezult
Feb 13 '13 at 18:53
Unfortunately, that's not really what I'm after. I've modified my question so that it is (hopefully) more clear.
– vezult
Feb 13 '13 at 18:53
Unfortunately, that's not really what I'm after. I've modified my question so that it is (hopefully) more clear.
– vezult
Feb 13 '13 at 18:53
add a comment |
One thing that you can do is to use another selection mode instead of the standard, then copy the contents to another place (choose an upper left cell) and perform the desired calculation.
My suggestion for your case.
In the calc window, at the bottom, in the middle of the window, there are two symbols, The one on the left is grey. So, you select one of the cells at the extreme of the range (ex. C4). Then, you can press the adding selection. Press CTRL + SHIPT + RIGHT cursor to move to the other end of the contiguous block of cells (you're now at GA4).
Copy the cells to another sheet and possibly transpose the selection so that you have the cells in one column.
Repeat it to the 15th row and paste (and transpose) it to the end of the last set pasted. Name the extended set.
Now perform the calculation you need.
answered Feb 13 '13 at 18:58
LuisLuis
602713
This doesn't scale well. If, for example, I needed to do that 50 times for very long rows...it would take forever. It is slightly less error prone than using the mouse, I'll give you that.
– vezult
Feb 13 '13 at 19:06
add a comment |
One thing that you can do is to use another selection mode instead of the standard, then copy the contents to another place (choose an upper left cell) and perform the desired calculation.
My suggestion for your case.
In the calc window, at the bottom, in the middle of the window, there are two symbols, The one on the left is grey. So, you select one of the cells at the extreme of the range (ex. C4). Then, you can press the adding selection. Press CTRL + SHIPT + RIGHT cursor to move to the other end of the contiguous block of cells (you're now at GA4).
Copy the cells to another sheet and possibly transpose the selection so that you have the cells in one column.
Repeat it to the 15th row and paste (and transpose) it to the end of the last set pasted. Name the extended set.
Now perform the calculation you need.
answered Feb 13 '13 at 18:58
LuisLuis
602713
This doesn't scale well. If, for example, I needed to do that 50 times for very long rows...it would take forever. It is slightly less error prone than using the mouse, I'll give you that.
– vezult
Feb 13 '13 at 19:06
add a comment |
One thing that you can do is to use another selection mode instead of the standard, then copy the contents to another place (choose an upper left cell) and perform the desired calculation.
My suggestion for your case.
In the calc window, at the bottom, in the middle of the window, there are two symbols, The one on the left is grey. So, you select one of the cells at the extreme of the range (ex. C4). Then, you can press the adding selection. Press CTRL + SHIPT + RIGHT cursor to move to the other end of the contiguous block of cells (you're now at GA4).
Copy the cells to another sheet and possibly transpose the selection so that you have the cells in one column.
Repeat it to the 15th row and paste (and transpose) it to the end of the last set pasted. Name the extended set.
Now perform the calculation you need.
answered Feb 13 '13 at 18:58
LuisLuis
602713
One thing that you can do is to use another selection mode instead of the standard, then copy the contents to another place (choose an upper left cell) and perform the desired calculation.
My suggestion for your case.
In the calc window, at the bottom, in the middle of the window, there are two symbols, The one on the left is grey. So, you select one of the cells at the extreme of the range (ex. C4). Then, you can press the adding selection. Press CTRL + SHIPT + RIGHT cursor to move to the other end of the contiguous block of cells (you're now at GA4).
Copy the cells to another sheet and possibly transpose the selection so that you have the cells in one column.
Repeat it to the 15th row and paste (and transpose) it to the end of the last set pasted. Name the extended set.
Now perform the calculation you need.
answered Feb 13 '13 at 18:58
LuisLuis
602713
answered Feb 13 '13 at 18:58
LuisLuis
602713
answered Feb 13 '13 at 18:58
LuisLuis
602713
answered Feb 13 '13 at 18:58
LuisLuis
602713
602713
This doesn't scale well. If, for example, I needed to do that 50 times for very long rows...it would take forever. It is slightly less error prone than using the mouse, I'll give you that.
– vezult
Feb 13 '13 at 19:06
add a comment |
This doesn't scale well. If, for example, I needed to do that 50 times for very long rows...it would take forever. It is slightly less error prone than using the mouse, I'll give you that.
– vezult
Feb 13 '13 at 19:06
This doesn't scale well. If, for example, I needed to do that 50 times for very long rows...it would take forever. It is slightly less error prone than using the mouse, I'll give you that.
– vezult
Feb 13 '13 at 19:06
This doesn't scale well. If, for example, I needed to do that 50 times for very long rows...it would take forever. It is slightly less error prone than using the mouse, I'll give you that.
– vezult
Feb 13 '13 at 19:06
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%2f550667%2fhow-do-i-select-non-adjacent-ranges-in-libreoffice-calc%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
