Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Fast AutoFill.
Written by Allen Wyatt (last updated April 17, 2021)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365
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 Excel in Microsoft 365. 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 editing tool that comes in particularly handy when you are first creating a worksheet. You may, at ...
Discover MoreThe AutoFill feature can be used for more than just incrementing information into cells. This tip explains how to access ...
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 © 2024 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here:
Comments