Menu
There is a column like the above,now, i want to add some records as the following:
20120210
20120211
20120212
20120213
......
Is there a way to make them auto increment and filled with a batch. thank you.
864
Just fill in your first cell with =COLUMN(A1) , select the cell, then expand the selection to the rest of the cells you want your numbers to be in. Note: if you add or delete rows, you will need to set the auto-numbering again by selecting the first cell and dragging or double-clicking again to restore the pattern.
168
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
