Numbers

Click once on the first cell of the row or column to select it. Type = to open the Formula Editor.

Enter the formula into the editor. Click the green chekcmark button to confirm the formula and close the editor.

With the cell still selected, press command-C to copy the cell, its format, and the formula.

With the cell still selected, press the shift key and click the last cell in the row or column to add that cell and all cells between it and the first cell to the selection.

Press command-V to Paste.

Note: Formulas filled to a row will increment column references by one as they are filled into the cells along the row. For column references that are to remain addressing the same column in all copies of the formula, Click each of the cell and range references in turn, click the vmark in the lozenge, and check the box to Preserve Column. Row references will not change as a formula is filled into cells in the same row.

       Formulas filled to a column will increment row references by one as they are filled into the cells down the column. For row references that are to remain addressing the same row in all copies of the formula, Click each of the cell and range references in turn, click the vmark in the lozenge, and check the box to Preserve Row. Column references will not change as a formula is filled into cells in the same column.

You can also fill formulas left or right in a row or up or down in a column by hovering the mouse pointer near the edge of the cell on the side you want to fill toward. A yellow-filled circle will appear at the middle of that edge of the cell, Grab it with the mouse pointer and drag in the direction you want to fill the formula.

Fill control shown on bottom edge of cell:

Regards,

Barry