6 Replies Latest reply: Apr 18, 2013 5:25 AM by jaxjason
Level 1 (0 points)

How do I set multiple cells to use a single cell value to calculate from without having to input each formula separately when in a table?

• ###### 1. Re: Numbers-Setting one cell value and dragging formulas
Level 5 (4,560 points)

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.

Regards,

Ian.

• ###### 2. Re: Numbers-Setting one cell value and dragging formulas
Level 5 (4,560 points)

Hi Ox,

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

Regards,

Ian

• ###### 3. Re: Numbers-Setting one cell value and dragging formulas
Level 5 (4,560 points)

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.

• ###### 4. Re: Numbers-Setting one cell value and dragging formulas
Level 1 (0 points)

Hi Ian, thanks for the help. Your last solution has nailed it.

• ###### 5. Re: Numbers-Setting one cell value and dragging formulas
Level 5 (4,560 points)

Hi Ox,

Thank for the green tick.

Regards,

Ian.

• ###### 6. Re: Numbers-Setting one cell value and dragging formulas
Level 4 (3,325 points)

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

Jason