• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Round in Excel

May 24, 2021 by Andrew Childress
How to round in Excel

It’s often useful to round numbers to make them easier to work with. This is a simple task in a spreadsheet. Here's how to round in Excel.

It’s often useful to round numbers to make them easier to work with. This is a simple task in a spreadsheet. Let’s learn how to round in Microsoft Excel.

How to Round in Excel (With the Menu)

Excel offers two quick ways to round numbers. Consider a number like 5.7473. It would be easier to work with if it was rounded to 5.747, 5.75, 5.7, or 6. To round using Excel’s built-in decimal menu, click into the cell containing your number.

Then, go to the Home tab on Excel’s ribbon. Near the middle, you’ll see the Decrease Decimal button.

Round Excel

Click it once, and Excel will remove a decimal, rounding your number down to 5.747. Continue clicking, all the way to the ultimate iteration, 6. 

Round numbers in Excel

Want to add the decimals back? Simply click the adjacent Increase Decimal button.

How to Round in Excel (With Formulas)

You can also round in Excel by using the ROUND function inside a formula. This is useful if you have large datasets and want to copy the formula across them.

Consider a number like 8.5730595. You want to quickly round it to three decimal places. You can do that with a formula.

Begin by clicking into any empty cell. Type = to begin a formula, then type ROUND(. Your formula will be:

=ROUND(

Then, click into the cell containing the number you want to round. Here, that’s cell C3. Then, type a comma. Now, Excel will ask you how many decimal places you want to round to. Here, it’s 3, so type 3, and then ). Your finished formula is:

=ROUND(C3,3)

Round in Excel

Hit Enter, and Excel returns your solution: 8.573. 

How to round in Excel

if you had other values, you could copy the formula by dragging on the corner of the cell to quickly round the balance of your dataset.

As you can see, Excel offers two quick and easy ways to round numbers.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Concatenate in Excel
Next Post:Print Area in ExcelSet print area Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top