Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Wilsonzoo
 
Posts: n/a
Default HOW TO USE FILL SERIES

I am trying to fill column in sequence stepping ten each time. Ex. a10, a20,
a30
If I put the sequence in the first two cells and extend down and click fill
series it changes it to single sequence. Ex. a10,a11, a12.
I have tried highlighting, clicking edit then fill series, column, growth,
step value 10, stop value (range), ok, then tried the fill series again and
it always goes back to single sequence.

Help would be appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
RagDyer
 
Posts: n/a
Default HOW TO USE FILL SERIES

Just enter the first 2 numbers of the sequence in the first 2 cells and then
select *both* cells.
Click on the fill handle of the 2 cell *selection* and drag down as needed.

When you release the mouse, the series is already filled in place.
No other mouse action is required.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Wilsonzoo" wrote in message
...
I am trying to fill column in sequence stepping ten each time. Ex. a10,

a20,
a30
If I put the sequence in the first two cells and extend down and click

fill
series it changes it to single sequence. Ex. a10,a11, a12.
I have tried highlighting, clicking edit then fill series, column, growth,
step value 10, stop value (range), ok, then tried the fill series again

and
it always goes back to single sequence.

Help would be appreciated.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
JG
 
Posts: n/a
Default HOW TO USE FILL SERIES

If I'm understanding you correctly....I would enter the first two cells the
way you want them a10, a20 and then highlight them both and while they are
highlighted left click on the little box at the bottom right of the highlight
and drag down as far as you want to go.

"Wilsonzoo" wrote:

I am trying to fill column in sequence stepping ten each time. Ex. a10, a20,
a30
If I put the sequence in the first two cells and extend down and click fill
series it changes it to single sequence. Ex. a10,a11, a12.
I have tried highlighting, clicking edit then fill series, column, growth,
step value 10, stop value (range), ok, then tried the fill series again and
it always goes back to single sequence.

Help would be appreciated.

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 04:21 PM.

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"