Column Fill down in Numbers

Hi Leonard,

with the first cell selected, hover the cursor over the bottom edge of the cell until you see a yellow dot (the "Fill Handle").

Drag the yellow dot down.

You can also fill formulas down with that method.

Regards,

Ian.

What Yellowbox said, with some added notes:

If you are filling down: Dates, Month names, Weekday names, or Text ending with a number, Numbers will automatically increment the values as they are filled down. To prevent this, enter the same value in the first and second cells, select both cells, then fill down.

If you are filling down Numbers, and do want them to increment, enter the starting number in the first cell, establish the increment by entering the second value in the second cell, select both cells, then fill down.

Alternate 'fill' method:

If you are filling a long column,you can enter the value in the first cell, click on the cell to select it, scroll to the bottom of the table, shift-click on the last cell to expand the selection to all cells in the column, Paste.

Regards,

Barry

Or if you're keyboard-oriented:

1. Select the cell with the value you want in the whole column
2. Type command-c to copy.
3. Type shift-command-downarrow to select the column.
4. Type command-v to paste.

SG