Excel Rounding Shortcut: Change Decimals or Values

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, 9 to show fewer decimal places; press the keys in sequence, not all at once. This shortcut changes how numbers look, not their stored values. To actually round a number for calculations, use the ROUND function, such as =ROUND(A2,2). Decide whether you need a display change or a changed value before you start.

What You’ll Need

  • An Excel workbook with the numbers you want to round or display with fewer decimal places.
  • For the Windows shortcut, Excel for Microsoft 365 on Windows. The ribbon button is available on other Excel platforms, although keyboard shortcuts can differ.
  • If you need actual rounded results, a blank column or destination cells for a formula such as ROUND.

Step-by-Step

  1. Choose what you mean by rounding. If you only want a tidier view, use Decrease Decimal. It changes the number format, so formulas still use the original stored number. If calculations must use the rounded result, use ROUND in a formula. For example, a cell displaying 4.57 could still contain 4.5678 after formatting; a formula returning 4.57 creates a rounded result in another cell.
  2. Select the cells to format. Click a single cell, or drag across a range. To select an entire column, click its letter at the top of the worksheet. You can also hold Ctrl while selecting separate, non-adjacent ranges on Windows. Check that you have selected the intended cells before using the shortcut, because it applies to the full selection.
  3. Use the Windows shortcut to reduce displayed decimals. Press and release Alt, then press H, then press 9. In other words, use the sequence Alt, H, 9; do not hold all three keys down together. H opens the Home ribbon key tips, and 9 activates Decrease Decimal. Repeat the sequence to remove additional displayed decimal places. The result may be rounded visually according to the number format, while the underlying values remain unchanged.
  4. Use the ribbon if the key sequence is inconvenient. Go to Home and find the Number group. Select Decrease Decimal, usually shown with a left-pointing arrow beside decimal places. Each click reduces the number of decimal places displayed. Select Increase Decimal to show more places again. If the ribbon is collapsed or the window is narrow, expand the ribbon or widen the Excel window to locate the controls.
  5. Set a specific number of displayed places. Select the cells and press Ctrl+1 on Windows to open Format Cells. On the Number tab, choose Number and set Decimal places to the count you want, then select OK. This is useful when you want exactly two displayed places rather than pressing Decrease Decimal an unknown number of times. The setting still affects appearance rather than changing the stored values.
  6. Use ROUND when you need an actual rounded result. Assume the original number is in A2 and you want a result in B2 rounded to two decimal places. Enter =ROUND(A2,2) in B2 and press Enter. If A2 contains 12.345, the formula returns 12.35. The second argument specifies the number of decimal places: 2 means two places, 0 means a whole number, and -1 means rounding to the nearest ten.
  7. Fill the formula down if there are more rows. Select the cell containing the ROUND formula and drag its fill handle, the small square at the lower-right corner, down the column. Excel adjusts the reference for each row. Alternatively, double-click the fill handle when the adjacent column contains a continuous list. Review the first and last results to confirm the formula reached all intended rows.
  8. Replace the original values only if that is really required. If you want a separate rounded column, keep the original data and use the formula results. If you need rounded numbers in place of the originals, copy the result cells, select the destination, and choose Home > Paste > Paste Values. This replaces formulas with their current results. Save a copy first if you may need the unrounded source numbers later.
  9. Check the result in context. Confirm both the displayed digits and any totals or later calculations that depend on the values. A formatted cell can look rounded while totals continue to use extra hidden decimal places. A ROUND formula changes the calculated result in its own cell, but other formulas will use that result only if they refer to the rounded cell.

On Mac, there is no matching universal Alt, H, 9 sequence. Select the cells and use Home > Decrease Decimal, or open Format Cells with Command+1 and set Decimal places. In Excel for the web, use the Home ribbon controls; keyboard behavior may depend on the browser and its shortcuts. The Windows sequence above is for the desktop Excel app.

Common Mistakes

  • Assuming Decrease Decimal changes the value. It changes the display format only. A cell containing 7.986 can show 7.99 while calculations still use 7.986. Use ROUND if downstream calculations must use a rounded number.
  • Pressing the shortcut as a chord. Alt, H, 9 is a sequence of key tips, not a three-key combination. Press and release each key as the ribbon responds. If the sequence does not work, click Decrease Decimal on the Home tab instead.
  • Rounding the wrong direction. ROUND rounds to the nearest specified place. It does not always round upward. For a value that must always move away from zero, use ROUNDUP; for a value that must move toward zero, use ROUNDDOWN.
  • Using the wrong number of places. In ROUND(A2,2), the 2 means two decimal places; it does not mean round to the nearest two. Use 0 for whole numbers or a negative digit count for tens, hundreds, and larger place values.
  • Overwriting source data without a backup. Paste Values can replace formulas or original values. Keep a copy of the source column or save a backup workbook before replacing data you may need to audit.
  • Expecting a formula result to update a different total automatically. A total that references the original column will continue using that column. Update the total to reference the rounded-results column if that is the intended calculation.

Tips

  • Use Decrease Decimal for reports, tables, and charts where the extra digits are distracting but precision should be preserved in the workbook.
  • Use ROUND for calculations where the rounded amount must feed later formulas, such as rounding each line item before adding the line items. Decide whether the rounding rule applies to each item or only to the final total; those approaches can produce different answers.
  • To round to a whole number, assume the original value is in A2 and the formula goes in B2: =ROUND(A2,0). If A2 is 18.6, B2 returns 19.
  • To round every value in a list, keep the original column intact and create rounded results in a neighboring column. This makes it easier to compare the source and the rounded figures and to change the number of decimal places later.
  • Use Format Cells when a whole range must have an exact, consistent display. The decimal-place setting is easier to verify than repeatedly applying a shortcut, especially when cells have mixed number formats.
  • Remember that currency symbols and separators are also formatting. Changing the displayed decimal places does not convert a number into a different currency or alter its stored amount.

Troubleshooting

The Alt, H, 9 sequence does nothing: Confirm that you are using Excel desktop for Windows and press the keys one after another. If a menu or another app intercepts the shortcut, use Home > Decrease Decimal. On Mac, use the ribbon rather than expecting the Windows key-tip sequence.

The cell still shows too many digits: Check that the intended cells are selected and that the cell is not using a format that prevents the expected display. Open Ctrl+1 on Windows, choose Number, and set Decimal places directly. If the cell contains text that looks like a number, number formatting will not work until you convert it to a numeric value.

The number of decimals changes, but a total seems unchanged: That is expected when you used formatting. The total may calculate from the full stored values. Create rounded values with ROUND and make the total refer to those results if you need calculations based on rounded numbers.

The formula returns an error: Check that the source cell contains a number and that the formula begins with an equals sign. For example, with the source value in A2 and the result in B2, enter =ROUND(A2,2). If your Excel regional settings use semicolons as argument separators, Excel may require =ROUND(A2;2) instead of the comma version shown here.

The result seems to round the wrong way: ROUND uses nearest-value rounding, while ROUNDUP and ROUNDDOWN deliberately force a direction. Verify the number of decimal places and the function you chose, especially for negative values or values close to a midpoint.

Frequently Asked Questions

What is the shortcut key to round off in Excel?
On Excel for Microsoft 365 on Windows, press Alt, H, 9 in sequence to decrease the displayed decimal places. It changes formatting, not the underlying number. There is no equivalent universal Windows shortcut that inserts a ROUND formula.

How do I round a number to two decimal places?
With the number in A2 and the result intended for B2, enter =ROUND(A2,2) in B2. For example, 6.478 returns 6.48. Use the Decrease Decimal button instead if you only want to change how many digits appear.

Can I round numbers without a formula?
Yes. Select the cells and use Home > Decrease Decimal, or set Decimal places in Format Cells. This is a visual change; it does not replace the values used in calculations.

How do I round up rather than to the nearest value?
Assuming the number is in A2 and the result belongs in B2, enter =ROUNDUP(A2,2) to round away from zero to two decimal places. For 3.141, it returns 3.15. ROUNDUP behaves this way for negative numbers too, moving farther from zero.

Does Excel have the same rounding shortcut on Mac?
The Windows Alt, H, 9 key-tip sequence is not a universal Mac shortcut. On Mac, select Home > Decrease Decimal, or press Command+1 to open Format Cells and choose the decimal-place setting you need.

Why does a displayed 2.35 produce a different total?
The cell may only be formatted to show two decimal places while retaining additional digits. Use ROUND to create values rounded to two places and make the total formula use those rounded results if that is the required calculation.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.