Feb 27 2022 11:52 AM
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
Feb 27 2022 12:15 PM
Feb 27 2022 12:20 PM
Feb 27 2022 01:23 PM
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.
Feb 27 2022 01:30 PM
Feb 27 2022 01:35 PM
Feb 27 2022 01:39 PM
Feb 27 2022 02:07 PM
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.
Feb 27 2022 02:37 PM
Feb 27 2022 03:35 PM
Feb 27 2022 03:36 PM
Hi Hans, Any help for this timesheet?
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 |
Feb 28 2022 03:35 AM
Is that table correct? I don't understand it...