How to Round a Range of Cells in Excel

If you have a range of cells within an Excel workbook, and you want to round these numbers to a certain number of places beyond the decimal, follow these easy steps.

Instructions

Difficulty: Easy

Things You’ll Need:

• A computer and Excel software.

1. Select the cells that you want to round. If you want all of them, left click with the curser on the first cell to select, hold down the shift key, and move the curser to the last cell. This will select all files.
   
   If you only want some files, and wish to skip others, hold down the CTRL key while selecting.
2. Left click menu Once you've selected the cells that you want to round, click your left mouse button. A menu will come up with many options, choose "Format Cells".
3. Choose number of decimal places A menu will come up, with several tabs along the top of the form. Choose "Number". Under Number, there are several choices that will allow rounding. For instance, the second choice in the categories is also "Number". If you click on Number with your cursor, you will be offered the option of setting the number of decimal places. If you choose "2", for instance, all numbers will be rounded to two places beyond the decimal point.
4. All cells rounded to two places beyond the decimal Done!

Tips & Warnings

• Save your file before experimenting. If you do something that gives you a result that you don't like, use the Edit pull-down menu, and choose to Undo the changes that you made. If you really do something that you can't undo, which is highly unlikely, just close the file without saving your changes. Then you can re-open the saved file and start over.