How to Make a Sales Order Form in Excel 2007

Written by shreya mehta
  • Share
  • Tweet
  • Share
  • Email

Eliminate paperwork and begin recording sales order information in a computerised system. It will help avoid losing important documents, and keep all sales orders organised. Using Microsoft Excel to create a sales order will help the user save time because some of the calculations are done automatically with formulas. There is no need to calculate subtotals and totals manually. Excel has easy-to-use templates that will help users get started in creating a sales order form.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • Microsoft Excel 2007

Show MoreHide


  1. 1

    Open a new workbook in Microsoft Excel 2007. Click on the "Office" button on the top left hand corner and select "New."

  2. 2

    Select the Microsoft Office Online under "Templates" and type sales order in the search box. Hit "Enter."

  3. 3

    Select a template such as "Sales order (Simple Blue design)." Click on the "Download" button.

  4. 4

    Fill in information on the company name, slogan, date, invoice, customer ID, return address, and shipping address. In order to add the company logo, go to cell A1 and click on the "Insert" tab in the toolbar. Click on "Picture" and find the picture on your computer and click on the "Insert" button.

  5. 5

    Enter the following information pertaining to the order: salesperson's name, job, shipping method, shipping terms, delivery date, payment terms, due date, quantity, item number, description, unit price, discount, and sales tax. The line total cell is automatically calculated by multiplying the quantity by the unit price, and subtracting any discounts. The total discount cell, subtotal, and total cells are also automatically calculated using formulas.

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.