Author: Oscar Cronquist Article last updated on August 30, 2017


This post descibes how to use a basic invoice template I created. The invoice template let´s you use dropdown lists to quickly select products on a price list. You can easily add/remove data on "price list" sheet.


  • Formula calculates totals
  • Find products easily with dependent drop down lists
  • Drop down lists contain unique categories, no duplicates
  • Ranges expand when new data is added to the price list

How to use invoice template

  1. Specify quantity
  2. Select a category
  3. Select a product and the formula calculates the total price.

How to copy dependent drop down list

  1. Select a cell containing drop down list
  2. Copy cell
  3. Right click on new cell
  4. Click "Paste Special..."
  5. Click "Validation"
  6. Click OK!

Download excel sample file for this tutorial.
Invoice template.xls
(Excel 97-2003 Workbook *.xls)

Recommended blog articles