How to Make a Spreadsheet in Excel

Step-by-Step Guide

1. 1

   Step 1: Open Excel.

   Each column has a capital letter on the top to show what column it is.
   
   Each row has a number to the immediate left of the first column, to show what row it is.
   
   Each cell is identified by a unique address consisting of the column letter followed by the row number.
   
   For example, the address of the cell in the first column, first row is A1.
   
   The address of the cell in the second column, third row is B3.
   
   If you click a cell, the cell address appears just above column A. ,,,, After you click outside of cell B2, 80 will show in cell B2. ,, After you click outside of cell B3,
   75.55 will show in cell B3. ,, After you click outside of the cell B4, 6 will show in cell B4. ,,, A total of
   161.55 will show in cell B5.
   
   SUM(B2:
   B4) is a formula.
   
   Formulas are used to perform math functions in Excel.
   
   It is essential to put equals sign (=) just before a formula, so that Excel knows that it is a formula. ,
2. 2

   Step 2: Notice there are rows and columns.

3. 3

   Step 3: Click cell A1 and type: Item.

4. 4

   Step 4: Click cell B1 and type: Cost.

5. 5

   Step 5: Click cell A2 and type: Printing.

6. 6

   Step 6: Click in cell B2 and type 80.00.

7. 7

   Step 7: Click cell A3 and type: Postage.

8. 8

   Step 8: Click cell B3 and type: 75.55.

9. 9

   Step 9: Click cell A4 and type: Envelopes.

10. 10

    Step 10: Click cell B4 and type: 6.00.

11. 11

    Step 11: Click cell A5 and type: Total.

12. 12

    Step 12: Click cell B5 and type: =SUM(B2:B4).

13. 13

    Step 13: Click in another cell.

14. 14

    Step 14: Click Save.

Detailed Guide

About the Author