Excel series auto fill missing

Copper Contributor

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

11 Replies
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-...
Kind regards
Hans
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

@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.

Hi Hans, The option menu is not display this. I think because it an Online version.
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.

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

@Victor2022 

If you want to create a series of numbers in Excel Online, enter the first two numbers in - for example - A1 and A2.

Then select A1:A2.

You should see a tiny square in the lower right corner of the bottom cell (A2 in this example). See 1. below.

When you move the mouse pointer over this square, it will change to a black cross. See 2. below.

Drag the mouse pointer down as far as you want. When you release it, Excel will extend the first two numbers to a series. See 3. below.

S1183.png

Hi Hans, It works! I don't know how to thank you. I have been trying this for months.
Thank you very much for your help.
Regards,

Victor2022
Hi HAns,

Any help for this timesheet? I don't know how to write the formula.


DATE WORKING HOURS HOURS
START TIME ON SITE OFF SITE FINISH TIME STD HOURS x1.5 x2 TOTAL
14/02/2022 07:40 09:00 17:15 19:00
15/02/2022 07:10 08:45 15:40 17:15
16/02/2022 05:00 06:00 17:30 19:00
17/02/2022 07:30 09:15 17:00 17:40
18/02/2022 06:30 08:00 16:00 17:00

TOTAL HOURS 0 0 0 0



@Victor2022 ,

Hi Hans, Any help for this timesheet?

 

DATEWORKING HOURSHOURS
START TIMEON SITEOFF SITEFINISH TIMESTD HOURSx1.5x2TOTAL
14/02/202207:4009:0017:1519:00    
15/02/202207:1008:4515:4017:15    
16/02/202205:0006:0017:3019:00    
17/02/202207:3009:1517:0017:40    
18/02/202206:3008:0016:0017:00    
         
    TOTAL HOURS 0000

@Victor2022 

Is that table correct? I don't understand it...