Question posted 2012 · +10 upvotes
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.
Accepted answer +14 upvotes
- 20120209, 20120210 in two rows
- select both
- drag downward by click in right down of selection
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.