Apple Numbers will not continue total in the D column
When I tab over to the D (cost) in column 2 why will it will not continue the
total automatically. It worked the first time I used it.
Mac mini, macOS 13.3
When I tab over to the D (cost) in column 2 why will it will not continue the
total automatically. It worked the first time I used it.
Mac mini, macOS 13.3
Hi R,
I don't know why the formula did not automatically fill down when pressing return. Perhaps Numbers expects a certain pattern of entries. Anyway, fill down like this:
Click once on D2 to see the formula in the bottom left of the window. All good.
To fill that formula down, hover the cursor over the bottom border of D2 to see the yellow dot (the Fill Handle).
Drag the yellow dot down
Regards,
Ian.
Hi Retoucher,
D3 has no formula. Fill down from D2 to D3
Regards,
Ian.
Sorry Ian, I'm clueless. Not sure what you mean when you state, fill down from D2 to D3. When I filled out the first invoice I simply inserted the info in A,B, and C on row 2 and when I tabbed over to D it automatically gave the correct amount. Then I would hit return which landed me on column A line 3 and I would repeat the process and when it got to column D it automatically entered the correct amount once more. I used the same invoice and deleted the bottom lines but when I started to fill the form out again and tabbed over to column D it stayed blank and did not enter a new total.
That worked! I'll continue to explore, when I'm able as to why the amount sometimes and sometimes will not appear automatically but this is a great work around and I really appreciate you taking time to help!
Apple Numbers will not continue total in the D column