CODEWITHSUNDEEP
excel
user1188320
user1188320

Reputation: 575

how to make the record auto increment and filled in excel?

enter image description here

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.

Upvotes: 11

Views: 20366

Answers (1)

Riskhan
Riskhan

Reputation: 4472

  1. 20120209, 20120210 in two rows
  2. select both
  3. drag downward by click in right down of selection

Upvotes: 16

Related Questions