Open a worksheet as an example.

02

Right-click a cell and select Format Cell.

03

Set the cell to a numeric value and the number of decimal places to 0.

04

Click the Brush Format command.

05

Drop down all cells to complete the setting.

end

0 1

02

03

04

05

Function method:

0 1

Switch to the Formula tab.

02

Click the rounding function in Math and Trigonometric Functions.

03

The first parameter selects the reference cell.

04

Set the second parameter to 0, and then click OK.

05

Drop down to fill the cell and complete the rounding operation.