Increment Cell Numbers

[digitalfish]

I have a small question for some excel 2000 guru...

When I drag (using the bottom right-hand series extender) a numerical cell
excel will sometimes increment the number automatically, and other times it
will only duplicate the same number in each of the cells. How does excel
decide whether to increment or not?

Thanks,
df

 

[Andy Brown]

df,

I dunno, maybe it's something to do with the cell format. BTAIM, you can
work round it -- if you want it to be incrementing and it isn't (or vice
versa), just before you let go hold down CTRL.

Rgds,
Andy

 

[Andy Brown]

Mine *doesn't* increment by default. XL Help says you need to guide it by
eg: entering 1 in A1, 2 in A2, selecting *both* and then dragging down.

"Advanced Fill" options can be accessed with right-click & drag, eg:
Series -- Step Value = 7 is good for week commencing dates.

Rgds,
Andy