Numbers-Setting one cell value and dragging formulas

Hi Ox,

Enter the formula in a cell at the top (or left) of your range of cells.

Press return.

Click once on that cell and you will see a small white circle bottom right of that cell.

Drag the circle down to fill a column, or right to fill a row.

Or,

Click in the first cell, then shift-click to select to the end of the range.

Menu > Insert > Fill.

Regards,

Ian.

Hi Ox,

Page 81 of the Numbers'09 User Guide: Autofilling Table Cells.

The Guide is available for download from the Numbers Help Menu.

Regards,

Ian

Hi Ox,

multiple cells to use a single cell value to calculate from

Maybe you mean this:

The single cell value in A2 is fixed for all formulas in Column C. Use the $ notation (absolute cell reference)

Formula in C2 (and filled down) is =$A$2*B2

Row numbers for B change as you fill down. $A$2 is constant in all rows of C

Regards,

Ian.

Hi Ox,

I misread your question at first, but I finally got there.

Thank for the green tick.

Regards,

Ian.

Page 129 in the numbers manual talks about absolute referencing (the $ in the formula)

Jason