How to Create an Invoice in MS Excel in Office 97

Written by anne hirsh
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create an Invoice in MS Excel in Office 97
Excel can simplify invoices by doing much of the work for you. (Blue pen in front of invoice image by millann from

Microsoft Excel is a spreadsheet program that can be used for a variety of tasks. The primary benefit to using Excel to generate an invoice is that Excel's built-in functions can be set up to act as an automatic calculator so that your expenses will automatically be tallied. You can customize your Excel invoice with your preferred fonts and layout, but the basic components and formulas will remain the same for any invoice.

Skill level:
Moderately Easy


  1. 1

    Open a blank Excel Workbook, and type your name into cell A1. Use cells A2 through 10 to add all other contact information such as your company name, address, phone number, website address and email.

  2. 2

    Click in cell C1 and type "Invoice Date" and the date you are creating the invoice.

  3. 3

    Click in cell C2 and type "Payment Due" and the due date for the payment.

  4. 4

    Type the word "Invoice" into cell B11 and press "Enter."

  5. 5

    Click in cell A14 and type a category for the items you are invoicing such as "Services Rendered," "Item number" or other relevant category. Press "Enter."

  6. 6

    Click in cell A15 and enter the name of the first item you are billing. Press the "Tab" key, which will take you to cell B15. Enter the dollar amount you are billing as a number, without the dollar sign (e.g., 12.50). Don't worry about the text in A15 getting cut off; this will be fixed later.

  7. 7

    Continue adding invoice items and amounts in the cells below A15 and B15. When you have added all of these items, click in the cell below your last item in column A and type "Subtotal."

  8. 8

    Press "Tab" to go to the column B cell adjoining the subtotal and type "=SUM" (without the quotation marks); then, click and hold your mouse button on cell B15, and drag your mouse down to the last number above your "Sum" line. Release the mouse button and press "Enter." Your subtotal will appear in the appropriate cell.

  9. 9

    Click into the cell below where you typed "Subtotal" and type "Discounts" or "Deposit," if you are reducing the total cost for any reason, such as a prepaid deposit or a reduced cost. Press "Tab," and then enter any discount or deposit amount inside parentheses, such as "(150)"; Excel reads numbers in parentheses as negative numbers.

  10. 10

    Type "Total" into column A in the row below your discounts. Press "Tab," then type "=SUM" into the adjacent column B cell and highlight your subtotal and discount amounts with your mouse. Release the mouse button and press "Enter."

  11. 11

    Type any payment instructions into column A, such as "Make checks payable to company X" or "PayPal full amount to" Include any other necessary information here as well, such as late fees.

  12. 12

    Click on the bar between columns A and B and drag it to the right to adjust the width of column A to show all necessary information. Use the same method to adjust any other rows and columns to your liking.

  13. 13

    Click on column B to highlight the entire column. In the top menu, click "Format," then "Cells," then select the "Number" tab. Choose "Currency" and select the currency style you prefer. This will add the dollar sign to all numbers in column B. Adjust any font sizes and styles to your liking to complete your invoice.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.