Things You'll Need:
- Microsoft Office Excel version 2000 to 2007
-
Step 1
Start Microsoft Excel. It will automatically open a new worksheet. Notice the letters that run across the top of the worksheet. These letters refer to the columns beneath them. The numbers that are listed vertically down the left side of the worksheet refer to the rows. The cells in the spreadsheet are referenced by the row and column that intersect there.
-
Step 2
Click on cell A1 to select it. Enter a header for the first column of the spreadsheet. For example, if you are making a spreadhsheet to track customer payments, the first heading might be "Customer Name." Click on cell A2 and enter the next heading, entering as many new headings as needed, one in each cell.
-
Step 3
Click on cell B1 and enter the first item that corresponds with the heading in cell A1. Continue entering corresponding information into the remaining cells and columns.
-
Step 4
Total the numbers in any column or row. Click on the cell that you want to contain the total and then click the "AutoSum" button. AutoSum will suggest a row or column to be added. If it is correct, click "OK." If not, select the correct range of cells using the mouse.
-
Step 5
Insert other functions by clicking the "Insert Function" button to the left of the Function bar. Type a word or short description of what you want to do and click "Go." Click on a function in the list to see a description below it, and click "OK" to insert a function.
