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).

series1.jpg

The Fill Series dialog is invoked with Edit - Fill - Series as shown below.

series2.jpg

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

series3.jpg

The completed series! Next,we will look at handling dates.

series4.jpg

Leave a Reply