How to Round in Excel

Step-by-Step Guide

1. 1

   Step 1: Enter your data series into your Excel spreadsheet.

   Save it frequently to avoid losing data.
2. 2

   Step 2: Highlight any cell(s) you want rounded.

   For multiple cells, highlight by clicking on the top left-most cell of the data and dragging your cursor down and to the right until you’ve reached the bottom right-most cell.
   
   The cells you’ve highlighted should automatically shade if you’ve highlighted correctly. , Scroll down the drop down menu until you find “Format Cells.” , Then, choose “Number” in the list on the left hand side of the box. , For instance, if you want to round the number
   16.47334 to 1 decimal place, make sure the “Decimal Places” box shows “1.” After clicking “Ok,” the number should read “16.5.” For example, if you want to round the number
   846.19 to a whole number, make sure the “Decimal Places” box shows “0.” After clicking “Ok,” the number should read “846.” , In order to ensure that this change is made with the entire sheet going forward, return to the sheet and click anywhere to remove highlighting.
   
   Click the “Format” menu at the top and choose “Cells.” Repeat the action, choosing the Number tab and the Number section.
   
   Then, ensure the Decimal Places number is listed as desired.
3. 3

   Step 3: Right-click your mouse on any highlighted cell.

4. 4

   Step 4: Ensure you are in the “Number” tab in the formatting dialogue box.

5. 5

   Step 5: Find the place where it says “Decimal Places.” Click on the arrow button

6. 6

   Step 6: up or down

7. 7

   Step 7: until you get to the desired amount of decimal places.

8. 8

   Step 8: Click “Ok” to apply your changes and return to your sheet.

Detailed Guide

About the Author