« Converting text to dates | Main | Basic functions : SUBTOTAL »
February 24, 2005
Filling a Cell Range with a Series
A quick way to fill a range of cells with a series of values that increase/decrease in a geometric fashion.
Let us consider the simple example below. We wish to complete the series of values atrting at B3 (shaded).
The Fill Series dialog is invoked with Edit - Fill - Series as shown below.
OOo Calc makes it's best guess regarding the continuation of the series.
In this example, we will elave everything at the default settings and close the dialog with OK
The completed series! Next,we will look at handling dates.
The Fill Series dialog is invoked with Edit - Fill - Series as shown below.
OOo Calc makes it's best guess regarding the continuation of the series.
In this example, we will elave everything at the default settings and close the dialog with OK
The completed series! Next,we will look at handling dates.
Posted by Dave at February 24, 2005 05:41 AM
Comments
Help is there a way to map a keyboard short cut for any of the fill commands? I'm lost without ctrl d and ctrl r filling down and right.
Posted by: adam at October 28, 2005 12:26 PM