How to Add a ROUND Formula to Multiple Cells in Excel

This is the sample dataset.

Add Round Formula to Multiple Cells in Excel

Method 1 – Dragging the Fill Handle Icon to Apply the ROUND Formula

Steps

Select D5 and enter the following formula:

=ROUND(B5,0)

D5 displays the rounded version of the number in B5.

Dragging Fill Handle Icon to Add Round Formula to Multiple Cells in Excel

Drag down the Fill Handle to the rest of the cells.

Dragging Fill Handle Icon to Add Round Formula to Multiple Cells in Excel

D5:D12 displays the rounded version of the numbers in B5:B12.

Dragging Fill Handle Icon to Add Round Formula to Multiple Cells in Excel

Method 2 – Embedding a VBA Macro to Round Multiple Cells in Excel

Steps

Go to the Developer tab and click Visual Basic.

Embedding VBA Macro to Add Round Formula to Multiple Cells in Excel

Click Insert > Module

In the Module window, enter the following code:

Sub Mul_round_formula()

Dim x As Range
Dim y As Range
Dim z As Integer

On Error Resume Next
xTitleId = "Enter Range of the Cells to be Rounded"

Set y = Application.Selection
Set y = Application.InputBox("Range", xTitleId, y.Address, Type:=8)
z = Application.InputBox("Decimal", xTitleId, Type:=1)

For Each x In y
    x.Value = Application.WorksheetFunction.Round(x.Value, z)
Next

End Sub

Embedding VBA Macro to Add Round Formula to Multiple Cells in Excel