Thread: auto sequence
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default auto sequence

Forgot one, type 1 in a cell, hold down ctrl and copy down and it will
increment


--
Regards,

Peo Sjoblom



"Peo Sjoblom" wrote in message
...
What does that mean? Accumulator?

http://www.mcgimpsey.com/excel/accumulator.html

If you mean that if you have a number in a cell like 1 and when you copy
it down it will change to 2 in the next cell and 3 and so on. Right click
and copy then select fill series or select a range of cells and use
editfillseries or put 1 in one cell and 2 in the next and grab both
cells and copy down


--
Regards,

Peo Sjoblom





"samszoo4" wrote in message
...
how to make a cell advance numericialy