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.