by **acknak** » Wed Dec 19, 2007 8:32 pm

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.

AOO4/LO5 • Linux • Fedora 23