How to create a simple price list

Written by sharika sanku
  • Share
  • Tweet
  • Share
  • Email

Listing the prices of items is fundamental to any business. Whether it be a local grocery store or a major computer manufacturer, creating price lists is an easy and necessary task. Just a few simple steps can enable your business to be more organised and your customers more satisfied with a clean and easily understandable list of products and prices. Not only does this take relatively little computer knowledge, but also will reflect well on your business.

Skill level:
Easy

Other People Are Reading

Things you need

  • Microsoft Excel
  • Printer (If desired)

Show MoreHide

Instructions

  1. 1

    Create an Excel file and label two columns: "Product" and "Price." Use these titles in the first row starting with the first column labelled 'A'. It is easiest to use columns immediately next to each other. (Price list functions)

  2. 2

    Enter Product names in the Product column. The fastest way to create a price list would be to enter all the names first followed by respective prices. Be sure to enter only one product name per row.

  3. 3

    Enter appropriate prices in the "Prices" column. To make it easier to handle the currency used, right-click the top of Row B, then select "Format Cells." Under the "Numbers" tab, select "Currency," then change the other settings (decimal point, currency) to your liking. Click "OK" to return to your spreadsheet. Now, simply type in the numbers for the pricing; the data will take the formatting you specified.

    After typing in each price, be sure to check your records that the price and product association is correct.

  4. 4

    Print the document by selecting "Print" in the "File" menu. If the list of products and prices is long, then the printer may produce more than one sheet.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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