13

I use osx numbers app. I have a large CSV file. And I want to apply a formula for an entire column. Adding formula to a cell and then dragging is not practical. Isn't there any other way?

3
  • sum(a:a) works in Excel etc.
    – Paul
    Sep 1, 2016 at 6:28
  • It's a custom formula not an aggregate function Sep 1, 2016 at 8:04
  • 6
    Copy the first cell with the formula. Type shift+command+down_arrow to select the column. Paste.
    – creidhne
    Sep 1, 2016 at 8:11

2 Answers 2

28

Answer is as @creidhne mentioned in the comments:

Copy the first cell with the formula. Type shift+command+down_arrow to select the column. Paste.

P.s. I'm placing this as the answer to help others see the answer right away. @creidhne if you answer it here I'll remove mine so you can get credit.

0
1

Another way is to select the entire column by clicking on the table's column name (above it's first row) when you enter the formula.

For example the first column is identified by a rectangle that contains the letter A. Clicking on the rectangle that shows the A will select the first column.

An extra advantage is the formula remains valid when more rows are added: all rows continue to be used.

You must log in to answer this question.

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