How to fill down in Numbers without dragging?

I have a 20,000 line spreadsheet in Apple Numbers, and I need to fill a column with data. I don't want to sit there dragging down the fill handle for thousands of rows.

How can I fill the whole column with a value?

Solution 1:

Found a way.

1. Select the column
2. Deselect the header row (Cmd click on the header row cell)
3. Table Menu > Autofill Cells > Autofill Down

This will ​not​ infer a pattern. (ex 1,2,3 it will just copy down 1,1,1)

If you’re expect it to interpolate, you have to click-drag.

It will fill down formulas and they will be correct.

Solution 2:

It is late for response here.

I have a file with 65500 rows which I need to add sequence of numbers (1,2,3,etc) to it. This is how you do it.

Row 1, column 1 type 1 In Row 2, column 2 type use formula to add the value of number 1 ( check the attachment)

Now do this as @Joshua Dance suggested.

1. Select the column
2. Deselect the header row and the row 1 (Cmd click on the header row cell)
3. Table Menu > Autofill Cells > Autofill Down

Cheers