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.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
AutoFill is a great editing tool that comes in particularly handy when you are first creating a worksheet. You may, at ...
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 MoreDon't want people using your workbook to be able to use AutoFill? You can add two quick macros that disable and enable ...
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.
Comments