Fill cells with numeric values - OpenOffice.org Calc

How-To: Fill cells with numeric values - OpenOffice.org Calc

Calc has a feature that lets you fill in consecutive numbers in cells easily.
To use this AutoFill feature, first type in the starting number you want for the series. In this case we are putting in the number one.
Next, click on the cell where the number is.
Now, on the bottom right corner of the cell selection box, you will see a black square. This is the "fill handle."
Click and hold the left mouse button on it.
Afterwards, while holding the button move the mouse downwards.
A red outline appears. This indicates the selected cells that will be filled in by numbers..
Just release the button when you have finished selecting cells.
Once the button is released, the cells selected will be filled with the numbers. Notice that they have appeared in order from the first cell.
You can of course do this for rows as well. Just click again on the first cell.
Next, find the fill handle and click and hold the left mouse button on it.
Now, move your mouse to the right. Notice again the red outline indicating the cells being selected.
Now just release the mouse button to place the numbers.
Great! You now know how to use the auto-fill feature for numbers.

Fill cells with numeric values

This screencast demonstrates how to fill cells with numeric values. You learn:

For advanced functionality with similar results see:

OpenOffice.org™ is a trademark of OpenOffice.org.

Name:	*
Email address:	*