How apply formula to entire table column?

Question

Level 1

8 points

How apply formula to entire table column?

Video: http://cl.ly/1c0K2R113E1m?_ga=1.223869659.1754762103.1426151886

As you can see in the video, I have a simple table where one of the columns have a formula and gets values from the first formula.

In Excel, Numbers etc, I can just drag down this formula and quickly apply the formula to the entire column.

Example: if the formula is A1*5, dragging it down would make B1*5 on the second row, C1*5 on the third row etc.

How can I get this to work in a Pages v5.5 table?

Thanks!

Posted on Mar 12, 2015 2:24 AM

Reply

Answer 1

VikingOSX

Level 10

123,992 points

Mar 12, 2015 7:02 AM in response to johannnnn

Let's copy a first column cell's formula downwards. Select the cell, and as you pass your mouse pointer over the bottom border, you will notice a yellow dot and directional arrows. Click and hold on that yellow dot for second, and the entire cell will gain a yellow border. Now, simply drag downwards from the yellow dot to replicate its formula.

Reply

Answer 2

Dec 13, 2015 2:40 PM in response to VikingOSX

I can never seem to find straightforward answers like yours to simple questions in the so-called Help. Do you know where this basic info is located in Help? Thank you for your answer. It saved me a lot of time.

Reply

Answer 3

VikingOSX

Level 10

123,992 points

Dec 13, 2015 3:16 PM in response to PiNdaSkai

There is modest discussion about dragging cells in Pages Help : Add Tables and Charts : Add Tables : Select tables, cells, rows, and columns : Select Cells.

Apple really needed to write, and update, a proper Pages v5 manual that incorporates more than the online Help provides.

Reply