Entering Values Quickly with AutoFill
AutoFill is a feature that automatically fills in data based on the data in adjacent cells. Using the fill handle, you can enter data in a series, or you can copy values or formulas to adjacent cells. A single cell entry can result in a repeating value or label, or the results can be a more complex series. You can enter your value or label, and then complete entries such as days of the week, weeks of the year, months of the year, or consecutive numbering.
Enter Repeating Data or Series Using AutoFill
Select the first cell in the range you want to fill.
Enter the starting value to be repeated, or in a series. ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
