Written by Allen Wyatt (last updated April 17, 2021)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
The AutoFill feature in Excel is a great boon to certain types of editing. The basic use of the feature (clicking and dragging on the AutoFill handle) has been covered in other ExcelTips. There is another way you can use the AutoFill handle, however, that is a wonderful time-saving feature.
Suppose you have a column full of values in column A. For instance, you have values in the cells A3 through A417. Now, suppose you want to fill adjacent cells in column B with a sequential values, 1 through 415. Try this:
That's it! No dragging at all, and you now have cells B5:B417 filled with sequential values. Cool, huh?
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10672) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Excel here: Fast AutoFill.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
If you need to fill a number of cells with a specific sequence of characters (such as the alphabet), there are several ...
Discover MoreAutoFill is a great tool for filling cells with data. What do you do when it doesn't work like you expect, however? ...
Discover MoreWhen entering data into a worksheet, you may have a need to fill a range of cells with a group of random numbers. This ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-04-19 09:17:47
Lisa
I tried this tip, the first time, it just copied the #2 all the way down, rather than sequentially. The 2nd time, I had to change the format from general to number then it worked. So perhaps add that to the instructions? Default cell format is General. How would this work if you wanted the cells to run a through z?
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments