Program Sets > MS Excel

Copying contents of cells - automatic increment


I don't understand this.
If I put a 1 into a cell and copy down expecting each cell to be incremented by 1 i.e 1, 2, 3, 4 etc  it doesn't work.  I just get a 1 in each cell.
if I put HP5550-M001 into the first cell and copy down expecting the content to be copied without incrementing  ... it does increment
i.e HP5550-M005, HP5550-M006, HP5550-M007 etc

put 2 into the second cell and you'll be fine. It shouldn't really with m007 as there has been no series defined.


[0] Message Index

Go to full version