formula and fuctions

Copper Contributor

i am looking to create a sheet that has several formulas per row, and this would re occurring throughout the sheet. is there way to create a formula that can be copied and pasted. also using the down fill.

1 Reply

@ja4891coxnet All the formula in your schedule can be copied down already, simply by dragging or double-clicking on the "fill handle" (i.e. the small square in the bottom right-hand corner of the selected cell). The (relative) references will be updated automatically. But I would like to mention that you don't need to wrap every formula in a SUM( .... ) function. It suffices to write =A1+B1 or =A1*B1.