How to Round Cell Values without Formulas in Excel Office 365?
Tags: kutoolsexceltutorial, roundcellvalueswitho, kutools
Published: 2020-10-15 12:03:13

---
title: How to Round Cell Values without Formulas in Excel Office 365?
published: true
date: 2020-10-15 11:58:59 UTC
tags: KutoolsExcelTutorial,RoundCellValueswitho,Kutools
canonical_url: https://geekexcel.com/how-to-round-cell-values-without-formulas-in-excel-office-365/
---

In this article, we are going to see how to **Round Cell Values without Formulas in Excel Office 365** using **Kutools.** Let’s step into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Rounding a Range of Values:

- You need to **select the Range** that you want to round the numbers.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-22.png)<figcaption id="caption-attachment-15787">Example</figcaption>

- On the **Kutools Tab, select** the **Round** option.

![Select the Round option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Round-option.png)<figcaption id="caption-attachment-15788">Select the Round option</figcaption>

- Then, it will display the **Round without Formula Dialog box**.
- You need to **specify** the **Decimal place** using the given drop-down list.
- Then, **choose** the **Rounding** option under the **Option** section.

![Round without Formula Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Round-without-Formula-Dialog-box.png)<figcaption id="caption-attachment-15789">Round without Formula Dialog box</figcaption>

- **Hit** the **OK** button to get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-16.png)<figcaption id="caption-attachment-15791">Result</figcaption>

### Note:

- You can also round numbers using the formula. Refer to this article: [ROUND Function](https://geekexcel.com/how-to-use-excel-round-function-in-office-365-with-examples/)

## Steps for Rounding Up the Range of Input Values:

- You need to **select the Range** that you want to round the numbers.

![Example Values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-Values.png)<figcaption id="caption-attachment-15792">Example Values</figcaption>

- On the **Kutools Tab, select** the **Round** option.

![Select the Round option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Round-option.png)<figcaption id="caption-attachment-15788">Select the Round option</figcaption>

- Then, it will display the **Round without Formula Dialog box**.
- You need to **specify** the **Decimal place** using the given drop-down list.
- Then, **choose** the **Rounding Up** option under the **Option** section.

![Round without Formula Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-18.png)<figcaption id="caption-attachment-15793">Round without Formula Dialog box</figcaption>

- **Click** the **OK** button to get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-31.png)<figcaption id="caption-attachment-15794">Output</figcaption>

### Tips:

- Use [ROUNDUP Function](https://geekexcel.com/how-to-use-excel-roundup-function-in-office-365/) for rounding up the input numbers using formulas.

## Rounding Down Values in Excel:

- You need to **select the Range** that you want to round the numbers.

![select the Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-15.png)<figcaption id="caption-attachment-15797">select the Range</figcaption>

- On the **Kutools Tab, select** the **Round** option.

![Select the Round option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Round-option.png)<figcaption id="caption-attachment-15788">Select the Round option</figcaption>

- Then, it will display the **Round without Formula Dialog box**.
- You need to **specify** the **Decimal place** using the given drop-down list.
- Then, **choose** the **Rounding Down** option under the **Option** section.

![Round without Formula Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-13.png)<figcaption id="caption-attachment-15798">Round without Formula Dialog box</figcaption>

- **Hit** the **OK** button to get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-7.png)<figcaption id="caption-attachment-15799">Result</figcaption>

### Added Info:

- You can also use the [ROUNDDOWN Function](https://geekexcel.com/how-to-use-excel-rounddown-function-in-office-365/) of Excel for rounding down the values.

## Steps for Rounding to Even:

- You need to **select the Range** that you want to round the numbers.

![select the Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-6.png)<figcaption id="caption-attachment-15800">select the Range</figcaption>

- On the **Kutools Tab, select** the **Round** option.

![Select the Round option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Round-option.png)<figcaption id="caption-attachment-15788">Select the Round option</figcaption>

- Then, it will display the **Round without Formula Dialog box**.
- You need to **specify** the **Decimal place** using the given drop-down list.
- Then, **choose** the **Rounding**  **to Even** option under the **Option** section.

![Round without Formula Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6-4.png)<figcaption id="caption-attachment-15801">Round without Formula Dialog box</figcaption>

- At last, **hit** the **OK** button to get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/7-3.png)<figcaption id="caption-attachment-15802">Output</figcaption>

In this way, you can easily round the values in the Excel worksheet.

## End of the Article:

In this article, you can understand the steps to **Round Cell Values without Formulas in Excel Office 365** using **Kutools. ** Give your **feedback** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Fill Cell References from Multiple Worksheets](https://geekexcel.com/how-to-fill-cell-references-from-multiple-worksheets-in-excel/)
- [Clear All Formatting of a Range in Excel](https://geekexcel.com/how-to-clear-all-formatting-of-a-range-in-excel-office-365/)