2. Then enter the relevant information of suppliers and contacts according to the following figure.
3. Then make a specific quotation sheet and enter the corresponding subjects according to the following details.
4. You can add a picture column after each serial number, so that the quotation unit can insert pictures.
5. Finally, enter the explanatory information that needs attention, and enter the inquirer and contact information in the lower right corner of the form.
How does excel make a quotation with pictures? Excel is used to make quotations. We can see if there are any free templates in Excel. Now many offer quotation templates. Of course, there are also some that need to be paid. You can refer to their styles. Then, through a series of operations in excel, the center was merged and the line spacing was widened, and a quotation was quickly made.
As for pictures, you can select the Insert and Picture buttons in excel to insert pictures. Complete the quotation sheet quickly with pictures.
Of course, if you want to make a more professional quotation, you can borrow the software. At present, there are some good quotation softwares on the market, such as "quotation optimization", which has built-in quotation templates of 10000+ famous enterprises for users to use at will. The most important thing is that it is free. For users who don't want to spend money but want to find a good template, this software is quite practical.
Excel self-made quotation
Method/step 1:
Choose from A 1 to H 1.
Method/Step 2:
Click Merge Center.
Method/Step 3:
Then write "quotation" on the first line.
Method/Step 4:
The second, third and fourth lines are merged and centered respectively.
Method/Step 5:
Write the words as shown in the picture.
Method/Step 6:
In the following lines, as shown in the figure, write down the product name, specification, quantity, unit price, amount, etc.
Method/Step 7:
The bottom should be marked with lowercase and uppercase, and the format is as shown in the figure.
Method/Step 8:
Note: the middle cell is merged, and the last five items are also merged in the middle.
Method/Step 9:
Finally, write down the offeror and approver.
Method/step 10:
Select all, right-click the cell format, add grid lines, and the quotation is ready. I hope it helps you!
How to make a price list with pictures in EXCEL 1 When the computer opens the Excel table, first enter the column headings.
2. Select a cell and click Add All Borders.
3. After adding the border, adjust the size of the table.
4. On the Insert page, click Insert Picture.
5. After clicking on the input picture, select the picture to be inserted.
6. After inserting the picture, you can click on the surrounding white dots to zoom in and out.
7. Finally, drag the picture into the cell and enter the price.