| View previous topic :: View next topic |
| Author |
Message |
Obolensky
General User
Joined: 09 Mar 2011
Posts: 6
|
 Posted: Thu Mar 10, 2011 1:08 pm Post subject: Extending number - click and drag on the corner of cells |
 |
|
Hi
I'm trying to extend a list of ID numbers. The column is called ID and the first six cells have a 1 in, the next six have a 2 in and so on upto about 20 so far. When I click and drag on the corner it goes back one and does each one twice, is there a quicker way of doing this than typing each ID number out 6 times? |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Thu Mar 10, 2011 1:30 pm Post subject: Re: Extending number - click and drag on the corner of cells |
|
|
| Obolensky wrote: | Hi
I'm trying to extend a list of ID numbers. The column is called ID and the first six cells have a 1 in, the next six have a 2 in and so on upto about 20 so far. When I click and drag on the corner it goes back one and does each one twice, is there a quicker way of doing this than typing each ID number out 6 times? |
Im not quite sure I understand what you're doing but if I select a sequence of 111222333 in a column and drag I get what I think you want. 111222333444555 and so on.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
Obolensky
General User
Joined: 09 Mar 2011
Posts: 6
|
| Posted: Thu Mar 10, 2011 1:50 pm Post subject: Re: Extending number - click and drag on the corner of cells |
|
|
| jrkrideau wrote: | | Obolensky wrote: | Hi
I'm trying to extend a list of ID numbers. The column is called ID and the first six cells have a 1 in, the next six have a 2 in and so on upto about 20 so far. When I click and drag on the corner it goes back one and does each one twice, is there a quicker way of doing this than typing each ID number out 6 times? |
Im not quite sure I understand what you're doing but if I select a sequence of 111222333 in a column and drag I get what I think you want. 111222333444555 and so on. |
Not for me, it is what I want to do and I've tried it by doing 111222333 and dragging and after that it goes to 222333444333444 (i.e. goes back one number, does three correctly, goes back one number, does three correctly and so on) |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Thu Mar 10, 2011 2:11 pm Post subject: Re: Extending number - click and drag on the corner of cells |
|
|
| Obolensky wrote: | | jrkrideau wrote: | | Obolensky wrote: | Hi
I'm trying to extend a list of ID numbers. The column is called ID and the first six cells have a 1 in, the next six have a 2 in and so on upto about 20 so far. When I click and drag on the corner it goes back one and does each one twice, is there a quicker way of doing this than typing each ID number out 6 times? |
Im not quite sure I understand what you're doing but if I select a sequence of 111222333 in a column and drag I get what I think you want. 111222333444555 and so on. |
Not for me, it is what I want to do and I've tried it by doing 111222333 and dragging and after that it goes to 222333444333444 (i.e. goes back one number, does three correctly, goes back one number, does three correctly and so on) |
You are selecting the entire sequence? Are you sure that you have numbers and not text
Blast it , a quick check and it even get the sequence when I deliberately formatted the cells as text. I don't have a clue at the moment.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
Obolensky
General User
Joined: 09 Mar 2011
Posts: 6
|
| Posted: Thu Mar 10, 2011 3:32 pm Post subject: Re: Extending number - click and drag on the corner of cells |
|
|
| jrkrideau wrote: | | Obolensky wrote: | | jrkrideau wrote: | | Obolensky wrote: | Hi
I'm trying to extend a list of ID numbers. The column is called ID and the first six cells have a 1 in, the next six have a 2 in and so on upto about 20 so far. When I click and drag on the corner it goes back one and does each one twice, is there a quicker way of doing this than typing each ID number out 6 times? |
Im not quite sure I understand what you're doing but if I select a sequence of 111222333 in a column and drag I get what I think you want. 111222333444555 and so on. |
Not for me, it is what I want to do and I've tried it by doing 111222333 and dragging and after that it goes to 222333444333444 (i.e. goes back one number, does three correctly, goes back one number, does three correctly and so on) |
You are selecting the entire sequence? Are you sure that you have numbers and not text
Blast it , a quick check and it even get the sequence when I deliberately formatted the cells as text. I don't have a clue at the moment. |
I am doing both of those. |
|
| Back to top |
|
|
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 330
Location: victoria
|
| Posted: Thu Mar 10, 2011 10:57 pm Post subject: |
|
|
Assuming in column a.
Fill your first six rows with your 1
In row 7
and drag that formula down. |
|
| Back to top |
|
|
|
