Learn how to apply AutoFill to Data Series in Microsoft Excel. AutoFill fills cells with data that follows a sequence or is based on data in other cells.

AutoFill is also useful in applying the formula to empty cells in Excel. For some users, AutoFill is not working in Excel . This article lists some solutions that will help you fix this problem.

You can save time by creating an AutoFill series in Excel 2003 as follows: Enter the values and then select the list. Choose Options from the Tools menu. Click the Custom Lists tab.

Please note: This item is from our archives and was published in 2002. It is provided for historical reference. The content may be out of date and links may no longer function. Q. One of the really ...

For example, using the data range shown below, you might enter a SUM() function that sums B3:E3 in cell F3. Then, you’d use the fill handle to copy that formula to F4:F6.