Rounding question

[williewombat]

So I figured out how to do a formula cell by cell to round a number, but for a long list how do I get the cells to round without having to manually type in the formula over and over?

Capture.PNG

[Logit]

Click on C2

A small dot appears on the border, lower right corner.

Left click and hold the dot

Drag down the column as far as needed.

[Sam Capricci]

in general you just double click the bottom right of the cell with the formula where it shows as a box and it auto populates the formula down the entire list.

[kersplash]

Put all your data in a table, then when you create the first formula in a column it will automatically populate the entire column.

Also the formulas expand and contract with your table.

No more copying formulas.