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?
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.
Sign up to join this communityI 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?
Found a way.
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.
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.
Cheers
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:
Filling a column can use the shortcut combination "option + command + \".
Steps: