How to make a product form template with pictures-suppose there is a template picture in excel, how to insert the needed picture?

How to make a quotation 1 with pictures? First make a header, enter the company name in the first column, and enter the word "quotation" in the second line. You can merge cells to display the entered text in the middle.

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 to use excel20 10 graphic template In order to make my data perspective more attractive, I tried my best to dress up the chart beautifully. However, in the future work, if you need to create a similar chart again, do you want to beautify the chart again? Next, I will bring you the usage of excel20 10 graphic template.

Excel20 10 graphic template setting steps are as follows:

Save template

In Excel20 10, you only need to save your beautiful chart as a chart template, and when you create similar charts in the future, you can quickly create the same beautiful chart based on this chart template.

1. First select the designed pivotchart in the Excel worksheet, then switch to the design context tab of the pivotchart tool, and click the Save As Template button in the type option group, as shown in figure 1.

Figure 1 Save as Template button

2. In the Save Chart Template dialog box that opens immediately, give the chart template an easy-to-understand name and click the Save button to save it in the default directory, as shown in Figure 2.

Figure 2 Save template

Application template

After saving the chart template, when you need to create a chart with the same appearance again (the chart can be a perspective view or an ordinary Excel chart), you can quickly generate a beautiful chart according to the template. This paper introduces the creation of an ordinary Excel chart as an example.

1. In the Excel worksheet, select the chart data source, switch to the Insert tab, and click the dialog launcher button in the chart options group, as shown in Figure 3.

Figure 3 Dialog Box Launcher

2. In the open Insert Chart dialog box, click the template in the left navigation bar.

FOLDER

, and then in the My Templates list, select the previously saved chart template, as shown in Figure 4.

Figure 4 My template

3. Click OK to close the dialog box, and a beautiful chart similar to the template is successfully created. At this time, you only need to enter meaningful title text in the "title" placeholder according to the actual situation, and you can finally complete the chart production, as shown in Figure 5.

Figure 5. Quick chart making.

Since the chart template has been established, it can be used to simplify the chart making every time you design a chart.

work efficiency

Has been effectively improved.

Recommended articles about excel20 10 graphic template;

1.excel20 10 Creating a Template Tutorial

Excel20 10 production

Gantt chart

Template course

3.3 How is it done? Excel20 10 converts data into graphics?

Suppose there is a template picture in excel, how to insert the needed picture. If you mean how to insert a picture, you can choose Insert-Picture, then select the picture to be inserted and edit the inserted position.

If you want to include the required picture in the new template, you can insert the required picture in the template and save it in xlt format.