Increment Cell Numbers

  • Thread starter Thread starter digitalfish
  • Start date Start date
D

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
 
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
 
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
 
Andy Brown said:
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
Click to expand...

Thanks for that Andy, works a treat.

df
 
Back
Top