Download example
autofill.xls

Menu Link
Edit > Fill > Series…

AutoFill can automatically enter a series of values in any cells you select, which makes AutoFill is a great time saving feature. Just make sure the first cells contain the values and increment, then let AutoFill do the rest.