Fill down formula in Numbers 3.2

Question

Level 1

4 points

Fill down formula in Numbers 3.2

This seems like rather a simple task in Excel ... write a formula, mark the cell and double click on the cross to apply it to the whole column.

How is this done in Numbers 3.2? I know there is a handle in the middle once you mark a cell, but you have to manually pull it down ... I found some old forum posts which mentioned to use Insert > Fill > Fill down (or similar) but this function does not seem to exist in Numbers 3.2. Can someone please explain how this is done in an easy fashion in Numbers 3.2?

Thanks,

Diddy

Posted on Jul 15, 2014 5:24 AM

Reply

Answer 1

Yellowbox

Level 7

22,523 points

Jul 15, 2014 5:51 AM in response to diddy81

Hi Diddy,

In Numbers 3.2, the Fill command is under Menu > Table > Autofill Cell > Autofill Right (or Left, Down Up).

To select all Body Cells in a column (but not select Headers and Footers), double click on the column label (A, B, C etc.). Then Fill.

Another way is to copy the cell that you want to fill down, select the body cells and paste.

Regards,

Ian.

Reply

Answer 2

diddy81 Author

Level 1

4 points

Jul 15, 2014 5:59 AM in response to Yellowbox

Awesome! Thanks a lot! What a time-saver! I'll have to assign a keyboard shortcut to this in the System Preferences.

Reply