Hi, David, this is nice, is there any tutorial you recommend for this kind of tasks? Thanks!
2008/12/23 D & L Koch <[email protected]>: > zhang zhengquan wrote: >> >> Thanks Jerry, it works magic! >> >> 2008/12/23 Jerry Feldman <[email protected]>: >> >>> >>> On 12/23/2008 03:16 PM, zhang zhengquan wrote: >>> >>>> >>>> Dear openoffice Calc users: >>>> I am pretty new to openoffice and I would like to know >>>> how to generate a sequence of numbers from 1-60 in a column, >>>> >>>> I hope it will look like this >>>> 1 >>>> blank >>>> blank >>>> blank >>>> 2 >>>> blank >>>> blank >>>> blank >>>> 3 >>>> blank >>>> blank >>>> blank >>>> >>>> >>>> >>>> >>> >>> You can do something like: (assuming column A; >>> In A1 place a 1 >>> Leave A2, A3, A4 blank >>> In A5 enter a formula "=A1+1" >>> Select cells A2 through A5, click Edit Copy, or ctrl-C, or the copy >>> icon.. >>> Then place your cursor into the cells to want to copy into, such as A6 >>> through A43, then click on Edit/Paste, Control-V, or the paste icon. >>> >>> This is simplistic, but it works. >>> >>> -- >>> Jerry Feldman <[email protected]> >>> Boston Linux and Unix >>> PGP key id: 537C5846 >>> PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 584 >>> > > Even easier, place the 1, then highlight the cell containing the 1 as well > as the next four empty cells. The bottom (empty) cell will have a block box > outlining it. Click on the "handle" in the lower right corner of that box, > hold, and drag the "handle" downward as far as needed. Every 4th cell will > have a number increasing by one. No formula needed. > > --David Koch > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
