iPad Docs | Numbers | How do I copy a formula over multiple columns?

iPad Docs » Numbers » How do I copy a formula over multiple columns?

Learn how to copy a formula over multiple cells

Tap, Pause and Tap Again

To copy a formula you need to open up the cell editor. To do this you must:

1. Tap on the cell you want to copy.
2. Lift your finger and pause for a brief moment.
3. Tap the cell again.

The cell editor will appear. Select Fill.

A yellow border will appear around the cell. Drag it in the direction you want to copy the formula.

Here you can see we are going to copy the formula over two additional columns.

Once you release your finger, the formula will be copied.

Prev: How do I add a calculation?

Next: How do I copy a formula over multiple columns vertically?

Saturday May 01 at 04:17 AM Oscar Waczynski

I would just like to thank you for this, maybe it's obvious for some but I couldn't figure it out.

Tuesday Jun 22 at 09:44 PM Csblue

thank you. i have been battling over an hour with numbers looking for this.

Monday Jul 26 at 08:27 PM Venezian

How do you copy a formula in one cell to the cells in the same column below it? I cannot seem to find a way to do this.

Any advice gratefully received - thanks

Saturday Aug 21 at 09:00 AM Stuart

Ditto, thank you again!

Wednesday Nov 24 at 06:27 PM Karl Proctor

Thanks for this. Once I'd read this, it enabled me to do everything that I needed on Numbers.

I'm sure it's in the Apple documentation somewhere, but this was so easy to follow.

Wednesday Nov 24 at 11:52 PM Greg DeVore

@Venezian - Sorry this took so long to do. Here is a lesson that shows you how to copy cells vertically.