How to Add Two Cells in Excel

One of the best things about a spreadsheet is using formulas to calculate values automatically. When you tell Microsoft Excel to add two cells (perhaps the cells that represent the number of men and women in a class that you are teaching), the program will automatically recalculate the answer if the values of the cells being added change. These steps work with Microsoft Excel 97.

Instructions

Things You'll Need:

• Excel Book
• Microsoft Excel
• Microsoft Office

1. Start Microsoft Excel, and open the file you want to use.
   
   
2. Click on the cell in which you want the total to appear.
   
   
3. Press the + key on the keyboard. This character will appear in the cell and in the Formula Bar.
   
   
4. Click on the first cell you want to add. That cell's name, such as B6, appears in the Formula Bar after the + sign.
   
   
5. Press the + key again.
   
   
6. Click on the second cell you want to add. That cell's name appears in the Formula Bar.
   
   
7. Press Enter to complete the equation. The total will appear in the initial cell.
   

Posted in: Office