How to make quotation sheet with EXCEL? Create a new excel table and rename it as a reference, which is convenient for us to find files.

Select the cells in columns A-G, then select "Merge Cells", click in the middle, and enter the title "Report Unit Price".

Change the height of the title line to 35. You can set it freely here, as long as it looks beautiful.

Then in the second line, we fill in the product number, product name, specification, quantity, unit price, amount, delivery date and other information. , and can also be deleted freely according to actual needs.

Here I marked "Communication" in white on a black background, so as to distinguish it from the upper part, facilitate reading and finding important information, and the color can be set freely, which is very beautiful.

In the second half, we need to add the buyer's contact person, the buyer's contact phone number, the buyer's fax phone number, the buyer's address and the buyer's postal code.

Supplier contact number, supplier contact person, supplier fax number, supplier address and supplier postal code.

After filling in all the information, we set the table border as a solid line, thus completing a simple quotation.

How to make a quantity × unit price table? This table usually uses five cells in a row.

Column name:

1. Serial number (numerical value)

2. Name (text)

3. Quantity (numerical value)

4. Unit price (numerical value)

5. Subtotal (numerical value)

1, 2, 3 and 4 columns need to be filled in manually, and the calculation formula needs to be filled in the subtotal column.

Because this step of writing formulas is very important, the details are as follows:

1) Click the cell under Subtotal;

2) Write "=" in the edit field;

3) Click the cell under the quantity;

4) Enter "*" (multiplication symbol) in the edit field;

5) Click the cell under "Unit Price";

6) Click "_" on the left side of the edit bar.

The formula of "quantity × unit price" of cells under "subtotal" is designed.

If the serial number is ***50 lines (50 items), copy and paste the cell with the formula into other cells in the Subtotal column, and automatically calculate the subtotal of each line.

How to make a quotation 1 First, we open a form.

2. First, we fill in

market quotations

Titles such as "a company's quotation"

3. After the title is written, mark "Query Unit".

4. Then there is the quotation list, which generally includes commodity name, commodity specification, unit price, quantity and amount, and it should be indicated whether tax is included.

5. If the quoted goods have a brand, we need to mark the brand name, then the supply cycle and so on.

6. Just fill in the quotation date at the bottom.