Apache OpenOffice Community Forum

Hi everyone,

I'm not sure if I'm using the right terminology, but I what i'd like to do is to create a sequential list of numbers in a column, say from 1 to 100, or whatever, without having to type the numbers myself. I'd like the program to complete the list for me.

for example:

1
2
3
4
5
6
7
8
9
10
11
...
and so on....until
100


Is there a quick and easy way to do this? I couldn't find this in the menus or in the help. I'm using Windows XP with OO v.2.3.0

Thanks in advance.
Cacique

The simple method for a few cells:
1) Enter the first number ("1") in a cell, then click on that cell, so it has the black outline.
2) Click on the little black blob in the lower right corner of the outline, hold and drag down. You will see a tooltip appear with first "2", then "3"... counting up as you drag the outline to cover more cells.
3) Keep dragging downward until the number reads "100". Just drag off the window at the bottom, and Calc will scroll to follow the mouse. The tooltip numbers will keep counting up. When the number gets near 100, move the mouse back into the window and the scrolling will stop. Move the mouse up or down until the tooltip number reads exactly "100".
4) Release the mouse and Calc will fill in the numbers 1-100 for you.

An alternative method, easier for large number of cells:
1) Click on the cell where you entered "1".
2) Type Ctrl+Shift+Down (arrow); many cells are selected (black).
3) Menu: Edit > Fill > Series. The Start value should already be "1", enter "100" for the End value, then click "OK".
4) Type Ctrl+Up (arrow) twice to move the cursor back to the start of your numbers

You can use either of these techniques to fill cells with almost any series of numbers.

Hi,

Thanks a lot! I tried both methods and they both work a trick.

BTW, what is the right term for this kind of function? Because I couldn't find it in the help but I didn't really know what to search for either, lol.

The Calc help refers to this as "Auto fill"; you can read about it in the help under "auto filling cells" in the Index tab.