Pages (Apple) Question
- Started
- Last post
- 3 Responses
- craigatkinson
Making an invoice in Pages with formulae in a table.
Item /Quantity / Price / Discount / Total...Is there a way of repeating the formula per line to generate the total per line, without having to code each cell?
So for example, first row A2+B2=D2
second row, A3+B3=D3
and so on...?
- prophetone0
can you select the cells and then drag below and it repeats the formula like with excel? i have no idea otherwise.
- prophetone0
(1) create only the useful rows
(2) use the same formula in every cells of a single column.
Asuming that every existing cells of column G contain the formula:
=E*F
when you will add a new row, the formula will be inserted automatically.If you failed to do that, assuming that row 1 is an header one, insert
=E*F (or =E2*F2) in cell G2 then select the circular handle at the right bottom of the cell and drag it to the bottom of the column.You will get =E*F in every cells
or
=E3*F3
=E4*F4
=E5*F5
- craigatkinson0
I just copied and pasted the row, why I didn't think of that I have no idea. 2 years I've spent repeating the cell formula. Fuck.
- Software is like that. Do things the hard way for years. Then find the shortcut and feel bitter.boobs