9

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?

  • Fill it with data meaning: a) Copy the data from the top cell to all cells b) Fill and increment the value? – Saaru Lindestøkke May 2 '16 at 21:09
  • Either. If the column should be 'True' copy that down into all 20,000 cells. If it should be 1,2,3 incrementing copy those 3 numbers and fill down incrementing. – Joshua Dance May 3 '16 at 23:04
18

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.

6

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

enter image description here

  • If you actually want the values (eg: if you need to change the order of the rows and added the new column to keep track of original order), you can copy the whole column then "paste formula values". – drevicko Feb 12 at 0:59
1

To expand upon the above answers, if you would like to do this using only the keyboard, you can simulate the Ctrl-D and Ctrl-R shortcuts from Excel by adding a keyboard shortcut to that menu item in System Preferences.

This is how:

  1. Open System Preferences > Keyboard
  2. Under the Shortcuts tab, click the + button.
  3. In the resulting sheet, select Numbers.app for the Application.
  4. For Menu Title, enter Autofill Down, exactly as it is in the menu item.
  5. For Keyboard Shortcut, press the key combination you want to assign, e.g. Ctrl-D or Ctrl-R.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .