ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   fill series (https://www.excelbanter.com/excel-discussion-misc-queries/60431-fill-series.html)

D J R

fill series
 
Looking for the diiferent ways to fill series in excel

Gord Dibben

fill series
 
Here are a few.

1. Enter 1 in A1. Right-click and drag down 12 rows. Release button and
"Fill Series"

2. Enter 1 in A1, 2 in A2. Select both and left-click drag down 12 rows.

3. Select A1:A12. In A1 type 1 then EditFillSeriesLinear. Enter a Step
Value if you wish.

4. For a unique fill series........ToolsOptionsCustom ListsNew. Type your
items in comma-delimited. Enter the first in A1 then left-click drag down.


Gord Dibben Excel MVP




On Wed, 14 Dec 2005 12:34:45 -0800, "D J R"
wrote:

Looking for the diiferent ways to fill series in excel


Ron Coderre

fill series
 
Start he

From the Excel main menu....
EditFillSeries...then play with the settings.

Post back with questions?

***********
Regards,
Ron


"D J R" wrote:

Looking for the diiferent ways to fill series in excel



All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com