#1   Report Post  
Posted to microsoft.public.excel.misc
D J R
 
Posts: n/a
Default fill series

Looking for the diiferent ways to fill series in excel
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit / Fill / Series Pauline Excel Discussion (Misc queries) 5 December 7th 05 07:17 PM
Excel should not automatically extend series or fill values whisperlm Excel Discussion (Misc queries) 0 July 13th 05 07:06 PM
Fill Series option grayed out kodismom Excel Discussion (Misc queries) 1 June 1st 05 01:06 AM
fill series J. Kopp Excel Discussion (Misc queries) 1 February 1st 05 11:23 PM
fill series grayed out (not available, disactivated) Michel Dion (from IMS Health in Canada) Excel Discussion (Misc queries) 1 December 17th 04 02:35 AM


All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"