« A simple recursive macro: GCD | Main | Looking Up Data In tables I »
September 10, 2004
Auto Filling Cells
Use this procedure to automatically increment data as you fill down a column or across a row.1.Select the cell range whose existing contents you want to extend to more cells. Then release the mouse button.
2.Move the mouse pointer on top of the automatic fill handle in the lower right of the selected cell. The mouse cursor turns into a target cross.
3.Click and hold down the left mouse button on the automatic fill handle, and drag in the desired direction of the fill, selecting all the cells you want to contain data.
Here are a few examples of how the automatic fill sequence works:
The sequence 1, 2 becomes 1, 2, 3, 4, and so on
The sequence 1, 3 becomes 1, 3, 5, 7, and so on
The cell content "Quarter 1" becomes Quarter 1, Quarter 2, Quarter 3, and so on
Automatic fill only increments data that OpenOffice.org Calc recognizes, such as numbers, dates and cell references. If Calc does not recognize data, automatic fill duplicates the data exactly. However, you can create sort lists that contain lists that Calc will recognize and automatically increment. To create a sort list, choose Tools - Options - Spreadsheet - Sort Lists
If you just want to copy the range without changing the values, hold down the Ctrl key while dragging.
Posted by Dave at September 10, 2004 05:25 AM
Comments
This seems to fail when it comes to filtered tables. What happens is that all the values in the rows in between the filtered rows gets the value. This should not be the case. The filtered ones are supposed to be the ONLY ones that will change. Anybody knows how to do this?
Posted by: Lawrence Salmingo at October 23, 2005 08:03 PM