Are you looking to create a professional and organized price list for your business? Google Sheets, with its user-friendly interface and powerful features, is an excellent tool for this task. In this article, we'll guide you through creating a price list template in Google Sheets, complete with formatting, calculations, and customization tips to help you stand out.
Before we dive in, ensure you have Google Sheets open and create a new, blank spreadsheet. Now, let's get started!
Setting Up the Basic Structure
First, let's set up the basic structure of your price list. In Row 1, enter the following headers: 'Item/Service', 'Description', 'Unit Price', 'Quantity', and 'Total'. Format these headers using bold text and a fill color for better visibility.
Freeze the top row for easy navigation as your price list grows. To do this, click on the row below the headers (Row 2), then go to 'View' > 'Freeze' > '1 row'.
Formatting for Readability
Apply alternating row colors to improve readability. Select the data range (A1:E100), then click on 'Format' > 'Conditional formatting'. Under 'Format cells if...', choose 'Custom formula is', and enter '=MOD(ROW(),2)=0'. Click 'Done'.
Next, adjust column widths for better presentation. Click and drag the line between column headers to resize columns. You can also double-click the line to automatically fit the column width to its content.
Calculating Totals Automatically
To calculate the total price for each item, enter the following formula in cell E2: '=C2*D2'. This multiplies the unit price (Column C) by the quantity (Column D).
Drag this formula down to copy it for the rest of your items. Now, your price list will automatically update totals as you change quantities.
Customizing Your Price List
Make your price list unique by adding your business logo, contact information, and a compelling header. To add a logo, insert an image by clicking on 'Insert' > 'Image'. Resize and position it as desired.
Add your business name and contact details in a text box. Click on 'Insert' > 'Text box', then enter your information. Format the text using bold, italic, or larger font sizes to make it stand out.
![Printable Price List Sheet Templates [PDF Included]](https://i.pinimg.com/originals/f8/b5/5b/f8b55bcaee8cb5db547e6c58b9f1316f.jpg)
Adding Taxes and Subtotals
To include taxes in your totals, add a new row below your items with a header like 'Subtotal'. In the cell below, enter the formula '=SUM(E2:E100)' to sum up all item totals.
Create another row for 'Tax' and enter your tax rate as a decimal (e.g., 0.08 for 8%). In the cell below, enter the formula '=E110*F110' to calculate the tax amount.
Displaying Grand Total
Finally, calculate the grand total by adding subtotal and tax. In the cell below the tax amount, enter the formula '=E111+F111'. This will give you the final total for your price list.
Format this cell with a border and fill color to make it stand out. You can also add a label like 'Grand Total' to the left of this cell.
Congratulations! You've just created a professional and functional price list in Google Sheets. Regularly update your price list to keep it current, and don't forget to share it with your clients or embed it on your website. Happy selling!