Make a Spreadsheet in Excel

A spreadsheet is a great tool for adding the total of a series of items. This article explains how to make a basic spreadsheet in Microsoft Excel, using a simple expense report as an example.

Steps

1. Open Excel.
2. Notice there are rows and columns.
   • 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.
3. Click cell A1 and type: Item.
4. Click cell B1 and type: Cost.
5. Click cell A2 and type: Printing.
6. Click in cell B2 and type 80.00.
   • After you click outside of cell B2, 80 will show in cell B2.
7. Click cell A3 and type: Postage.
8. Click cell B3 and type: 75.55.
   • After you click outside of cell B3, 75.55 will show in cell B3.
9. Click cell A4 and type: Envelopes.
10. Click cell B4 and type: 6.00.
    • After you click outside of the cell B4, 6 will show in cell B4.
11. Click cell A5 and type: Total.
12. Click cell B5 and type: =SUM(B2:B4).
13. Click in another cell. 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.
14. Click Save.

Tips

• These tips work in Excel 2003 and may also work in earlier versions of Excel.
• Select cells B2 to B4.

Things You'll Need

• A computer with Windows/Mac OSX OS
• Microsoft Excel

Related Articles

• Create an Image from a Excel Spreadsheet
• Use Solver in Microsoft Excel
• Create an Excel Financial Calculator
• Do a Break Even Chart in Excel
• Apply Conditional Formatting in Excel
• Edit Data in Microsoft Excel
• Print Cell Formulas Used on an Excel Spreadsheet
• Make Tables Using Microsoft Excel
• Create a Google Map With Excel Data and Fusion Tables
• Generate a Number Series in MS Excel

See also

• Create a Sin and Cos Circle in Excel
• Add a Header or Footer in Excel 2007
• Calculate CAGR in Excel
• Use Excel for Your Finances
• Parse Data in Excel
• Create Custom Lists in Excel
• Remove Leading or Trailing Zeros in Excel
• Remove Spaces Between Characters and Numbers in Excel
• Use Vlookup With an Excel Spreadsheet
• Create a User Defined Function in Microsoft Excel

Read more ...

What links here

• Compare Data in Excel
• Extreme Coupon
• Write a Status Report
• Create a Calendar in Microsoft Excel
• Be a Good Receptionist
• Add Header Row in Excel
• Add Rows to a Pivot Table
• Add a New Tab in Excel
• Become a Social Media Marketer
• Calculate Age on Excel

Read more ...