keyboard equivalent of dragging the little black square to generate sequence
What is the keyboard way of generating a sequence?
The pic below shows libre office calc. In order to generate the sequence of numbers 1 to 10. I simply enter few numbers of the sequence (in ascending order) one below the other. In this case three numbers. I select all three. And I click and drag the little black box as pointed out in the image until I reach my desired ending number.
How to achieve this via keyboard only?
keyboard spreadsheet libreoffice-calc
asked Mar 3 '14 at 17:36
deostrolldeostroll
88861633
add a comment |
What is the keyboard way of generating a sequence?
The pic below shows libre office calc. In order to generate the sequence of numbers 1 to 10. I simply enter few numbers of the sequence (in ascending order) one below the other. In this case three numbers. I select all three. And I click and drag the little black box as pointed out in the image until I reach my desired ending number.
How to achieve this via keyboard only?
keyboard spreadsheet libreoffice-calc
asked Mar 3 '14 at 17:36
deostrolldeostroll
88861633
add a comment |
What is the keyboard way of generating a sequence?
The pic below shows libre office calc. In order to generate the sequence of numbers 1 to 10. I simply enter few numbers of the sequence (in ascending order) one below the other. In this case three numbers. I select all three. And I click and drag the little black box as pointed out in the image until I reach my desired ending number.
How to achieve this via keyboard only?
keyboard spreadsheet libreoffice-calc
asked Mar 3 '14 at 17:36
deostrolldeostroll
88861633
What is the keyboard way of generating a sequence?
The pic below shows libre office calc. In order to generate the sequence of numbers 1 to 10. I simply enter few numbers of the sequence (in ascending order) one below the other. In this case three numbers. I select all three. And I click and drag the little black box as pointed out in the image until I reach my desired ending number.
How to achieve this via keyboard only?
keyboard spreadsheet libreoffice-calc
keyboard spreadsheet libreoffice-calc
asked Mar 3 '14 at 17:36
deostrolldeostroll
88861633
asked Mar 3 '14 at 17:36
deostrolldeostroll
88861633
asked Mar 3 '14 at 17:36
deostrolldeostroll
88861633
asked Mar 3 '14 at 17:36
deostrolldeostroll
88861633
asked Mar 3 '14 at 17:36
deostrolldeostroll
88861633
88861633
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
- Enter the first number of the sequence
- Select the range to fill (SHIFT+Down)
Use Alt to navigate the menu: Alt+e, i, e, Enter
This is a shortcut for
Edit->Fill->Series
As a mnemonic, adapt the children's song "Old Macdonald," substituting IO (Input/Output) for the Enter key:
Old Macdonald had a series of animals, (alt) E I E IO
answered Mar 3 '14 at 17:53
bonsaivikingbonsaiviking
1,34888
add a comment |
The keyboard equivalent to the requested function is placed under the Edit->Fill->Series command in the menu. In newer LibreOffice versions the location is Sheet->Fill Cells->Series....
Before running the command, select the cells to be filled in by using Shift + navigation keys (Shift+Down in the case of OP).
Then you may use mnemonics for running the command. Or even better, set a custom keyboard shortcut via Tools->Customize...->Keyboard. In the dialog, select Category = Edit, Function = Fill Series and set for example Ctrl+Enter as the shortcut.
answered Jan 5 at 18:33
Petr BodnárPetr Bodnár
214
add a comment |
According to LibreOffice's Help page for Calc there is no keyboard shortcut for that.
answered Mar 3 '14 at 17:46
KruugKruug
4,94721828
Evidence (proof) of absence or absence of evidence (proof)?
– nutty about natty
Apr 18 '17 at 7:50
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%2f724040%2fkeyboard-equivalent-of-dragging-the-little-black-square-to-generate-sequence%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
- Enter the first number of the sequence
- Select the range to fill (SHIFT+Down)
Use Alt to navigate the menu: Alt+e, i, e, Enter
This is a shortcut for
Edit->Fill->Series
As a mnemonic, adapt the children's song "Old Macdonald," substituting IO (Input/Output) for the Enter key:
Old Macdonald had a series of animals, (alt) E I E IO
answered Mar 3 '14 at 17:53
bonsaivikingbonsaiviking
1,34888
add a comment |
- Enter the first number of the sequence
- Select the range to fill (SHIFT+Down)
Use Alt to navigate the menu: Alt+e, i, e, Enter
This is a shortcut for
Edit->Fill->Series
As a mnemonic, adapt the children's song "Old Macdonald," substituting IO (Input/Output) for the Enter key:
Old Macdonald had a series of animals, (alt) E I E IO
answered Mar 3 '14 at 17:53
bonsaivikingbonsaiviking
1,34888
add a comment |
- Enter the first number of the sequence
- Select the range to fill (SHIFT+Down)
Use Alt to navigate the menu: Alt+e, i, e, Enter
This is a shortcut for
Edit->Fill->Series
As a mnemonic, adapt the children's song "Old Macdonald," substituting IO (Input/Output) for the Enter key:
Old Macdonald had a series of animals, (alt) E I E IO
answered Mar 3 '14 at 17:53
bonsaivikingbonsaiviking
1,34888
- Enter the first number of the sequence
- Select the range to fill (SHIFT+Down)
Use Alt to navigate the menu: Alt+e, i, e, Enter
This is a shortcut for
Edit->Fill->Series
As a mnemonic, adapt the children's song "Old Macdonald," substituting IO (Input/Output) for the Enter key:
Old Macdonald had a series of animals, (alt) E I E IO
answered Mar 3 '14 at 17:53
bonsaivikingbonsaiviking
1,34888
answered Mar 3 '14 at 17:53
bonsaivikingbonsaiviking
1,34888
answered Mar 3 '14 at 17:53
bonsaivikingbonsaiviking
1,34888
answered Mar 3 '14 at 17:53
bonsaivikingbonsaiviking
1,34888
1,34888
add a comment |
add a comment |
The keyboard equivalent to the requested function is placed under the Edit->Fill->Series command in the menu. In newer LibreOffice versions the location is Sheet->Fill Cells->Series....
Before running the command, select the cells to be filled in by using Shift + navigation keys (Shift+Down in the case of OP).
Then you may use mnemonics for running the command. Or even better, set a custom keyboard shortcut via Tools->Customize...->Keyboard. In the dialog, select Category = Edit, Function = Fill Series and set for example Ctrl+Enter as the shortcut.
answered Jan 5 at 18:33
Petr BodnárPetr Bodnár
214
add a comment |
The keyboard equivalent to the requested function is placed under the Edit->Fill->Series command in the menu. In newer LibreOffice versions the location is Sheet->Fill Cells->Series....
Before running the command, select the cells to be filled in by using Shift + navigation keys (Shift+Down in the case of OP).
Then you may use mnemonics for running the command. Or even better, set a custom keyboard shortcut via Tools->Customize...->Keyboard. In the dialog, select Category = Edit, Function = Fill Series and set for example Ctrl+Enter as the shortcut.
answered Jan 5 at 18:33
Petr BodnárPetr Bodnár
214
add a comment |
The keyboard equivalent to the requested function is placed under the Edit->Fill->Series command in the menu. In newer LibreOffice versions the location is Sheet->Fill Cells->Series....
Before running the command, select the cells to be filled in by using Shift + navigation keys (Shift+Down in the case of OP).
Then you may use mnemonics for running the command. Or even better, set a custom keyboard shortcut via Tools->Customize...->Keyboard. In the dialog, select Category = Edit, Function = Fill Series and set for example Ctrl+Enter as the shortcut.
answered Jan 5 at 18:33
Petr BodnárPetr Bodnár
214
The keyboard equivalent to the requested function is placed under the Edit->Fill->Series command in the menu. In newer LibreOffice versions the location is Sheet->Fill Cells->Series....
Before running the command, select the cells to be filled in by using Shift + navigation keys (Shift+Down in the case of OP).
Then you may use mnemonics for running the command. Or even better, set a custom keyboard shortcut via Tools->Customize...->Keyboard. In the dialog, select Category = Edit, Function = Fill Series and set for example Ctrl+Enter as the shortcut.
answered Jan 5 at 18:33
Petr BodnárPetr Bodnár
214
edited Jan 5 at 18:43
answered Jan 5 at 18:33
Petr BodnárPetr Bodnár
214
answered Jan 5 at 18:33
Petr BodnárPetr Bodnár
214
answered Jan 5 at 18:33
Petr BodnárPetr Bodnár
214
214
add a comment |
add a comment |
According to LibreOffice's Help page for Calc there is no keyboard shortcut for that.
answered Mar 3 '14 at 17:46
KruugKruug
4,94721828
Evidence (proof) of absence or absence of evidence (proof)?
– nutty about natty
Apr 18 '17 at 7:50
add a comment |
According to LibreOffice's Help page for Calc there is no keyboard shortcut for that.
answered Mar 3 '14 at 17:46
KruugKruug
4,94721828
Evidence (proof) of absence or absence of evidence (proof)?
– nutty about natty
Apr 18 '17 at 7:50
add a comment |
According to LibreOffice's Help page for Calc there is no keyboard shortcut for that.
answered Mar 3 '14 at 17:46
KruugKruug
4,94721828
According to LibreOffice's Help page for Calc there is no keyboard shortcut for that.
answered Mar 3 '14 at 17:46
KruugKruug
4,94721828
answered Mar 3 '14 at 17:46
KruugKruug
4,94721828
answered Mar 3 '14 at 17:46
KruugKruug
4,94721828
answered Mar 3 '14 at 17:46
KruugKruug
4,94721828
4,94721828
Evidence (proof) of absence or absence of evidence (proof)?
– nutty about natty
Apr 18 '17 at 7:50
add a comment |
Evidence (proof) of absence or absence of evidence (proof)?
– nutty about natty
Apr 18 '17 at 7:50
Evidence (proof) of absence or absence of evidence (proof)?
– nutty about natty
Apr 18 '17 at 7:50
Evidence (proof) of absence or absence of evidence (proof)?
– nutty about natty
Apr 18 '17 at 7:50
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%2f724040%2fkeyboard-equivalent-of-dragging-the-little-black-square-to-generate-sequence%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
