Program Sets > MS Excel

Copying contents of cells - automatic increment

(1/1)

bahhumbug:
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.
 
BUT
 
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
 
????

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

Navigation

[0] Message Index

Go to full version