Forum Discussion

Victor2022

Copper Contributor

Feb 27, 2022

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

excel

hansleroy

Iron Contributor

Feb 27, 2022

Hi,
Not sure what I can tell you -more- than a video tutorial. And in any case, all I can say will be text.
Start reading this:
Fill data automatically in worksheet cells
https://support.microsoft.com/en-us/office/fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db
Kind regards
Hans

Victor2022
Copper Contributor
Feb 27, 2022
Hi Hans, Thanks for your response. The "Fill" icon is missing on my excel windows I don't know why? When I type 1 and drag it down, it does not give me the option to select the series function. I used to do it with 2007 office.

Thanks,
Victor
- HansVogelaar
  MVP
  Feb 27, 2022
  Victor2022
  
  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.
  - Victor2022
    Copper Contributor
    Feb 27, 2022
    Hi Hans, This is the search I found from the excel web help but I don't understand this:
    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.
    I don't how to do it.
    Thanks,
    Victor