00:26
Faizan
Price lists give you a quick breakdown of items or services and their prices. You can use them for inventory or reference. Price list templates are completely reusable. As such, they should only include the layout for the price list, not the actual items or services you'll add in later. You should have ample space to accommodate the items on your list. You can create the template in a spreadsheet application, such as Microsoft Excel, OpenOffice Calc or Google Spreadsheets.
Starting the Price List
Start Microsoft Excel, OpenOffice Cal or Google Spreadsheets.
Go to cell A1 and type placeholders as follows:
[company], [address], [phone]
Press "Enter" twice to move to cell A3. Type in the title you want to use, such as "Price List," "Vendor Price List" or "Product Price List."
Press "Enter" twice to move to cell A5.
Type "Item Number" in cell A5, "Item Name" in cell B5, "Description" in cell C5 and "Unit Price" in cell D5. Press "Enter."
Click and expand the column headers between columns "A and B," "B and C," "C and D" and "D and E" until column E is the last column on the page.
Highlight cells A1:D3 and press "Ctrl+B" to bold the selected text. Highlight cells A5:D50 or the number of rows you need. Go to the "Completing Price List" section for your application to finish the template.
Completing Price List in Word
Click the "Customize Quick Access Toolbar" and "More Commands" to add the AutoFormat button to the Quick Access Toolbar. A window opens to the Customize tab.
Select "All Commands" from Choose commands. Click the "AutoFormat" button, press "Add" and click "OK."
Click the "AutoFormat" button in the Quick Access Toolbar. Pick a table format in the dialog box and press "OK." The format is applied to the highlighted cells.
Click the Office Button and select "Save As." Change "Save as type" to "Excel Template" in the dialog box. Name the file and click "Save."
Completing Price List in OpenOffice Calc
Select "Format" and "AutoFormat" from the menu.
Pick a chart format in the AutoFormat dialog box and click "OK."
Select "File" and "Save As" from the menu. Change "Save as type" to "ODF Spreadsheet Template" in the dialog box. Name the price list template and click "Save."
Completing Price List in Google Spreadsheets
Click the "Borders" button in the menu. Click the "All Borders" option (top, right) to add a border around the selected cells.
Select "File" and "Save a copy" from the menu.
Name the file in the pop-up box and click "Save."
Starting the Price List
Start Microsoft Excel, OpenOffice Cal or Google Spreadsheets.
Go to cell A1 and type placeholders as follows:
[company], [address], [phone]
Press "Enter" twice to move to cell A3. Type in the title you want to use, such as "Price List," "Vendor Price List" or "Product Price List."
Press "Enter" twice to move to cell A5.
Type "Item Number" in cell A5, "Item Name" in cell B5, "Description" in cell C5 and "Unit Price" in cell D5. Press "Enter."
Click and expand the column headers between columns "A and B," "B and C," "C and D" and "D and E" until column E is the last column on the page.
Highlight cells A1:D3 and press "Ctrl+B" to bold the selected text. Highlight cells A5:D50 or the number of rows you need. Go to the "Completing Price List" section for your application to finish the template.
Completing Price List in Word
Click the "Customize Quick Access Toolbar" and "More Commands" to add the AutoFormat button to the Quick Access Toolbar. A window opens to the Customize tab.
Select "All Commands" from Choose commands. Click the "AutoFormat" button, press "Add" and click "OK."
Click the "AutoFormat" button in the Quick Access Toolbar. Pick a table format in the dialog box and press "OK." The format is applied to the highlighted cells.
Click the Office Button and select "Save As." Change "Save as type" to "Excel Template" in the dialog box. Name the file and click "Save."
Completing Price List in OpenOffice Calc
Select "Format" and "AutoFormat" from the menu.
Pick a chart format in the AutoFormat dialog box and click "OK."
Select "File" and "Save As" from the menu. Change "Save as type" to "ODF Spreadsheet Template" in the dialog box. Name the price list template and click "Save."
Completing Price List in Google Spreadsheets
Click the "Borders" button in the menu. Click the "All Borders" option (top, right) to add a border around the selected cells.
Select "File" and "Save a copy" from the menu.
Name the file in the pop-up box and click "Save."
Posted in: Products & Brands
