Forum Discussion
Excel series auto fill missing
Hi, I am having trouble to fill series on office excel. I have googled it on Youtube but not help. Can someone please help. Thanks
Select File > Options.
Select Advanced in the navigation pane on the left.
In the 'Editing options' section, make sure that the check box 'Enable fill handle and cell drag-and-drop' is ticked, then click OK.
Project values in a series
In Excel for the web, you can project values in a series by using worksheet functions, or you can click and drag the fill handle to create a linear trend of numbers. But you can’t create a growth trend by using the fill handle.
Here’s how you use the fill handle to create a linear trend of numbers in Excel for the web:
Select at least two cells that contain the starting values for the trend.
If you want to increase the accuracy of the trend series, select additional starting values.
Drag the fill handle in the direction that you want to fill with increasing values or decreasing values.
In Excel for the web, you can project values in a series by using worksheet functions, or you can click and drag the fill handle to create a linear trend of numbers. But you can’t create a growth trend by using the fill handle.
Here’s how you use the fill handle to create a linear trend of numbers in Excel for the web:
Select at least two cells that contain the starting values for the trend.
If you want to increase the accuracy of the trend series, select additional starting values.
Drag the fill handle in the direction that you want to fill with increasing values or decreasing values.